| |
GeekInterview.com > Interview Questions > Data Warehousing > Business Objects
| Print | |
Question: Multiple data cubes for one report?
Answer: If we create a document from 2 documents or from 2 universes, can any one explain if the new document will have multiple data cubes or not? |
| February 02, 2008 02:50:12 |
#2 |
| manikandans25 |
Member Since: February 2008 Total Comments: 3 |
RE: Multiple data cubes for one report?
|
You can get data from tow different universe and create a single report, provided there are common dimensions between the two datasets.
1) Create New Report -> Create one universe -> Select objects say Processingmonth, Customer id, Total Salary Amount in SGD
2) Then Tools -> Insert new table -> Select another universe , select objects say Processing Month, Customer id , Total No of Days.
3) Goto the data manager, then click on the Procesing month from first query, Click on the link to button and link it to the second querys processing month. Similaryly link the customer ids aswell.
4) Then you can create a report joining the Total Salary amount and Total No of days.
Pls note joining microcube will give sensible results only if there are common dimensions. |
| |
Back To Question | |
