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 |
how many user were there
what is fantrap?
how do you give security to universe ?
2 Answers InfoStep, Tech Mahindra,
Iam having an report it contain n number of rows i want to desplay each rows in one colur pls explain me its very important
What are different types of saving options in web intelligence?
How to open a universe with out using the Designer ??
What is metrics?
Explain about a tricky situation for which you found a very simple solution?
wat is the difference between full clinet report and thin client report?wat is the difference between desktop intelligence and web intelligence?
Can we link the Universes from two different sourcess?Explain?
Which one will be more preferable creating Derived table or Views on universe level.and Explain why also ?
please anyone explain me the derived table with the problem tables.