1. can we create report using multiple universes and how ?
2. how can we move the objects from universe A to universe B
in report ?
3. how can we create aggregate table at universe level ?
4. if there is only one fact table in that universe, what
happens if we get fan trap ?
Answer Posted / mark
1. Yes, by using multiple data providers. Bear in mind,
though, whether or not it is meaningful to do so.
2. Objects are not moved between universes at the report
level, they are managed within Designer.
3. Aggregate tables cannot be created at universe level.
Derived tables that act as aggregate views can be created
but will not perform anywhere near as well as physical
aggregate tables.
4. Alias the non-fact table containing the measure, create a
second context containing the alias and derive the measure
object from the alias table.
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What is the difference between business requirement document and use case document.
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
Explain what would you consider as your biggest achievement and why?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
8. How much supervision have you typically received in your previous job?
What is the difference between absolute and relative div positioning?
Explain what are the steps to do to use alerts in bo?
Explain what are the steps to be taken to schedule the report?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Explain is data mart?
Can Bo generates the Report from the cubical data Explain?
How to execute the plsql procedure from the report by clicking with mouse?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?