Open BI Administration
---build physical model---
New Repository (the cube)
follow the wizard, select repository location, password and data source (can be oracle tns, or odbc, etc.)
from the data source, select the physical tables to be imported (Dim, Fact)
To delete a table from the physical model, right click and delete
To add new tables into the physical model, File->import metadata, follow the wizard
From physical model, can view data and update row count, or create allias for the tables
--link tables--
select the tables/alias from physical model, and view Physical Diagram
From Physical Diagram, create joins between tables, basically drag a link from Fact to Dim, so it creates
a many to one relation
---build Business Model and Mapping---
create a Business Model (if not visible, go to View -> Business Model and Mapping), give it a name
select the physical tables/alias, and drag them into the Business Model
View the Business Model Diagram. The joins (relations) should be created automatically based on the
relations in the physical model.
Each logical table in the Business Model comes with a source pointing to the physical table
Double click the source to edit the source name, column expression and column mapping..
In this way, it maps physical columns to logical columns, and add derived columns.
Delete useless logical columns to save some space
There is a tool->utilities->rename wizard that helps to rename logical columns by rules (e.g. replace underscore by space)
--Create measures
double click the number column (e.g. Amount) of the fact. Set default aggregation from none to Sum / something else.
Then the column automatically becomes a measure
---build presentation layer---
This is the layer that surface the data to end user and build dashboards
Create Subject Area in Presentation layer
Drag logical tables and columns into the subject area
---a simple repository is done---
Check global consistency of the model
If all good, the logical model becomes green.
Save the repository and close
---deploy repository---
Goto Fusion Middleware Control Enterprise Manager:http://<machine name>:7001/em
Make some configuration... dis-select caching...
Upload BI Server Repository, choose the RPD file just saved.
click Activate Changes
Click Restart to apply recent changes
---Create and Run an Analysis--
goto: http://<machine name>/:9704/analytics
---create dimension hierarchy---
from logical model, create logical dimension
level-based hierarchy: country-> state-> centre (every level is a different attribute)
parent-child hierarchy: employee(director)->employee(manager)->employee (every level is the same attribute)
Give every level a name, drag the attributes to each level (e.g. Country level may contain country name and country code)
Choose a key for each level, the bottom level's key must contain the primary key of the dimension (the most detailed level)
Very easy to start using, but there are a lot details behind.