Using RPD Opaque Views
Using the results of a SQL statement as a new fact table with RPD opaque views.
Read More →Category: RPD Semantic Model
OBIEE Cache Clearing using Dynamic Repository Variables
I’ve found a lot of references to purging OBIEE cache using dynamic variables to assist with automating our cache purge process (to find a way to trigger the cache purging after ETL completes) Most references quote the Oracle admin guide: “When the value of a dynamic repository variable changes, all cache entries associated with a […]
Read More →
Modeling a Degenerate Dimension in the RPD
RPD modeling of a degenerate dimension with multiple levels of aggregation and creation of level based measures on this dimension.
Read More →