This winter, we upgraded our on-premise OBIEE 11g (11.1.1.9) to Oracle Analytics Cloud (OAC). This posts outlines some of the pain points we faced that others, (who are still using 11g) may run into while upgrading. We had assistance from Oracle’s Cloud Lift Services (CLS) team, who created the OAC instances within Oracle Cloud Infrastructure […]
Read More →I recently tried out Metabase, an light weight open source reporting solution. The premise is straight forward. It’s a simple reporting tool allowing users to ask “questions” using a GUI, selecting physical columns from the tables in a connected database. Installation was simple – download a .JAR file, run via JDK command line and within […]
Read More →
Using the results of a SQL statement as a new fact table with RPD opaque views.
Read More →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 →Developing a solution to do a quick health check after a deployment or maintenance activity to ensure RPD database connections are functioning properly as well as easily check which database an environment is connecting to.
Read More →
RPD modeling of a degenerate dimension with multiple levels of aggregation and creation of level based measures on this dimension.
Read More →
How to create a tag cloud visualization in OBIEE showing a categorical dimension as a tag cloud with color and size based on measures.
Read More →
Creation of a calendar like visualization in OBIEE using Pivot table and various DATE dimension columns.
Read More →