1 . | Use a different technique to create a logical dimension for Time. Right-click the D1 Time logical table and select Create Logical Dimension > Dimension with Level-Based Hierarchy. |
---|---|
2 . | A new logical dimension, D1 TimeDim in this example, is automatically added to the business model. |
3 . | Rename D1 TimeDim to H1 Time . |
4 . | Expand H1 Time . Notice that two level were created automatically: D1 Time Total and D1 Time Detail. D1 Time Detail is populated with all of the columns from the D1 Time logical table. |
5 . |
Rename D1 Time Total to Time Total,
and rename D1 Time Detail to Time Detail.
|
6 . |
Right-click Time Detail and select New
Object > Parent Level to open the Logical Level dialog box.
|
7 . |
On the General tab, name the logical level Week, and
check Supports rollup to higher level of aggregation. |
8 . | Click OK to close the Logical Level dialog box. The Week level is added to the H1 Time logical dimension. |
9 . | Repeat the steps to add the remaining logical levels: Month as a parent of Week Quarter as a parent of Month Half as a parent of Quarter Year as a parent of Half Your final results should look similar to the screenshot: |
OBIEE , INFORMATICA, OBIA DAC TRAINING FOR DETAILS CALL 09959531832 email ID: obieetraining03@gmail.com
OBIEE 11G Create a Logical Dimension for Time
Subscribe to:
Post Comments (Atom)
Popular Posts
-
How to get a difference between two dates (in terms ) of days,weeks,months what every it may be The below formula gives you no.of days b...
-
https://forums.oracle.com/forums/search.jspa?forumID=378&threadID=&q=%22timestampadd%22+&objID=f378&dateRange=all&userI...
-
A Column Selector view adds a column selector to the results. A column selector is a drop-down list from which users can dynamically...
-
In this topic you create time series calculation measures using Oracle BI time series functions. Time series functions include AGO, T...
-
In OBIEE, the dashboard prompts are aligned to the left by default. One of the OBIEE developers I am working with asked me to fin...
-
I was requested the other day for a custom job within OBIEE. The request was for an extra “Go” button which would be placed on to...
-
In this topic, you learn how to create an analysis with a Pivot Table view, format, add a calculated column to a pivot table, add a...
-
A presentation variable can be created as part of the process for creating a column prompt or a variable prompt. When the presentat...
-
Calculating grand total column or % of grand total is easy in pivot table view. But how can I create the same in a table view? ...
No comments:
Post a Comment