Using aggregates and combining datasources in Oracle BI

Track

Middleware

Date and time

Wednesday, 14. October 2015., 09:00

Room

Hall 5 Apartmants

Duration

45'

Aggregates are usually one of the key elements of any data warehouse. They are natural response to performance bottlenecks we usually face in real life. Using Oracle BI in combination with data warehouses this is not an exception. 

When running measure aggregations at different levels of dimensional hierarchy, we will sooner or later run into performance bottlenecks. In Oracle BI we can solve this quite easy by defining new aggregates as data sources for our logical models. However, if there are a lot of aggregates required, then manual management of aggregates is not that simple task anymore. Aggregate Persistence Wizard can be used to create and model aggregates in order to relieve the bottleneck and pre-calculate and store the data for better query response. Beside that we can reuse Aggregate Persistence Wizard scripts to manage and refresh data in our aggregated tables.

But what if your aggregates are stores in an Essbase cube? Well, Oracle Business Intelligence has answers for this case as well. Basically it you would combine an essbase cube in the same way as using aggregates. It is just another datasource type.

What if you have your actual and planning data in various data sources. Well, you will find out that Oracle Business Intelligence handles these type of situations very efficiently as well.

Do you want to find out how Oracle Business Intelligence does that? If yes, then join me for this demos based presentation.

Lecture details

Type: Lecture
Level of difficulty: General
Experience Level: No experience
Desirable listeners function: End user , Team leader , Manager

About speaker

HrOUG.hr

The conference is organized by the Croatian Association of Oracle users. More about the association can be found at Hroug.hr.

Follow us on Facebook

Follow us on Twitter

Keep yourself up to date with all updates!

Best Sponsor

Better Sponsor

Good Sponsor

Media Sponsor