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 / 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 |
WHAT IS CARDINALITY?
What are Alerter, Filters, Breaks and Conditions?
Is it mandatory to give a cardinality ? If cardinality is not given what will happen?
There are 2 types of strategies are there? 1. Built-in Strategy 2. External Strategy can you please explain them in complete that what are these? Thanks in Advance
every reports have docid,when i export a report docid will change or not?
Can anybady tell me , what is the aggrigate awareness.how to use it . could u plz give me the practical example.
How can we improve performance?
What is the difference between Report Bursting and Report scheduling?Explain both of them in detail?
What is slicing and dicing in business objects?
How to generate the report from excel sheet?
how do u resolve contexts ?
what do u mean by variable functions ?