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
Explain how to execute the plsql procedure from the report by clicking with mouse?
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
What is the functional & architectural differences between business objects and web intelligence reports?
What is the difference between the public object&schema object?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
is it possible to export the webi reports to crystal reports?with out using businessview?
How to execute the plsql procedure from the report by clicking with mouse?
Explain the difference between detect alias and detect context?
How to open a universe with out using the Designer ??
what are the tables used in health care domain project and columns used in report?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
Explain is it the job of a business analyst or systems analyst to draw the class diagram?