Posts

Showing posts from 2015

My presentation from 1st SIOUG Analytics Meetup

Image
SIOUG has organised 1st SIOUG Analytics Meetup on 10th December 2015. The main topic was Oracle Business Intelligence 12c . I presented and demonstrated some key Oracle Business Intelligence 12c functions and features like Visual Analyzer, Data Mashups, Analytical Functions and some management tools that are new in 12c. You can download my presentation here . 

Use Essbase as an aggregate table and drill to relational

Image
In my two previous blog posts I wrote about how to add aggregated tables into you OBI data model and how to use Aggregate Persistence Wizard to manage your aggregates more efficiently . This is the last post in the series of three, in which I will focus on using an MOLAP (Essbase) cube as an aggregate for your base data model. The first step of all before you do any modelling is to import Essbase metadata into BI repository. Once you've done that you should follow standard method of setting the cube in the physical layer of the RPD. For example, define Measure dimension, flatten Measures etc. Once you've finished with these tasks, which are definitely different from the ones when you import and model relational database metadata, then Essbase cube is practically ready to be used. There isn't much changes required in logical and presentation layers. And even when you want to use Essbase "only" as an aggregated store, you would use Essbase basically in the same

Simplify Aggregates Management with Aggregate Persistence Wizard

Image
In my previous post  Using Aggregates and Combining Data Sources in OBIEE  I explained how to add aggregates to physical layer and how to include these in business model. In general that process is quite straightforward, but what if there are many aggregates that have to be brought into your repository. Well, in that case, using Aggregate Persistent Wizard to create aggregates might be better idea. So let's explore this tool that is available in BI Administration Tool. Before running Aggregate Persistence Wizard, you might want to run Global Consistency Check and Model to check if there are any errors or inconsistencies that might affect creation of aggregates. There shouldn't be any. Once you run both tools and check for issues, you ca run Aggregate Persistence Wizard. To start the six-step process, navigate to Tools menu in BI Administration Tool and select Utilities. When Utilities pop-up window opens, select Aggregate Persistence from the list of available utilitie

1st SIOUG Analytics Meetup on 10 Dec 2015

Image
We are meeting on Thursday, 10th December 2015, at Hotel Plaza in Ljubljana at 16:00 for the 1st SIOUG Analytics Meetup. This Analytics Meetup is organised by SIOUG and is dedicated to all those who use and/or would like to find out more about the latest release of Oracle Business Intelligence as the main theme  for this Meetup will be Oracle Business Intelligence 12c. We will take a look at new OBI features like Visual Analyser, Mashup queries, Analytical functions, new architecture etc. Check more details at SIOUG web page and join us for free.

Using Aggregates and Combining Data Sources in OBIEE

Image
Kimball defines "aggregate fact tables as simple numeric rollups of atomic fact table data built solely to accelerate query performance. These aggregate fact tables should be available to the BI layer at the same time as the atomic fact tables so that BI tools smoothly choose the appropriate aggregate level at query time. This process, known as aggregate navigation, must be open so that every report writer, query tool, and BI application harvests the same performance benefits. A properly designed set of aggregates should behave like database indexes, which accelerate query performance but are not encountered directly by the BI applications or business users. Aggregate fact tables contain foreign keys to shrunken conformed dimensions, as well as aggregated facts created by summing measures from more atomic fact tables. Finally, aggregate OLAP cubes with summarized measures are frequently built in the same way as relational aggregates, but the OLAP cubes are meant to be accessed di