Enterprise Transformations, It's all About Performance Management

Drill-through Reports: With drill-through reports, you create spreadsheet reports that display data retrieved directly from external relational data sources. Until release 11.1.1, you created drill-through reports using Integration Services. Starting with release 11.1.1, you can also create drill-through reports in Essbase Studio. CREATING DRILL THROUGH REPORTS USING ESSBASE STUDIO Step 1: Create tables in relational database and then create data source steps are already mentioned in the previous posts. Step 2: Create “Product” Hierarchy like this: Step 3:  You can preview “product” hierarchy by clicking “Preview” Step 4:  Now right click on the data source in the metadata navigator for creating “Drill through report” Step 5:  Now drag the created hierarchies or click the “Add” option for selecting hierarchies in the “Intersections” in the context tab of the drill through report Step 6:  Now go to “Report Contents” tab of the

Here is the next section in the sequence of cube designing using Essbase Studio, today we will concentrate on creating Alias! Below are the sequence of steps which are self explanatory: Step 1: To start we need tables containing member name and respective Alias, we can have them in the same table or in a different one: Step 2:  Create alias set by right click on the folder in the metadata navigator or you can create one more folder under root folder and create alias set under it Step 3:  Give name to alias set as “Default” and then click on “+” sign. Though you can give any name, but if its other then Default then you need to go to properties and choose the Active Alias table manually     Step 4:  Select “Product Name” from Product table in Binding source and select “Product Alias” from Product_Alias in Binding expression and then click “OK” Step 5:  Now you can see the created bindings in the “Bindings” and click “Ok”

Essbase Studio: Loading Text and Date Oracle Essbase Studio is a single environment to simplify the construction and administration of Essbase applications. Essbase Studio provides a single interface for performing tasks related to data modeling, cube design, and construction of analytic applications. Essbase Studio provides a consistent platform for building outlines and loading data by consolidating cube construction activities into one interface. Here we will be discussing how to load Text and Date values from a relational database into an Essbase Cube using Essbase Studio. 1. Create tables in Relational database or use an existing database for warehouse table, here we will be using a fresh one: 2. Load the data in SQL tables: 3. Login to Essbase Studio and go to File->New->Data Source 4. Enter  the name and password to connect to the Sql tables 5.Click Test Connection 6. Select the table from available tables and pull