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 |
I HAVE MONTHS AS DEC,JEN,MAY,APRIL... WHICH PROMPT IS USED TO GET REPORT IN SEQUENCE?
1.what is the difference between development,maintainace and support in bo? 2.what is dynamic date prompt?Is it feasible to create dynamic date prompt in universe?what is the procedure? 3.how can u say that a report is complex ,simple or medium? 4.yesterday i had run the report it took max 30 sec to run the report.but today i came and refresh the same report ,more than two hours completed,still result not came?where is the issue might be?note that at universe and report level no issues?where u will go fro 3rd verification?
can anybody tell me about complicated object you have created
every reports have docid,when i export a report docid will change or not?
Hi frns, In the report level i have dragged objects in the query panel. If i check the sql query it is displaying 2 separate queries. What will be the possibilities for this?
What is the merge dimension?
6.what is conformed dimension? R u used?
what is universe null
What is #refresh,#hash,#Comupation error and How to resolve #refresh,#hash error.
1. What is difference SAP BW, SAP BI and SAP BOXI integration? 2. Which is good for carrier wise? 3. Which is latest one (BW/BI/SAP BOXI Integration)?
What is the diff b/w BO webi reports, crystal reports and xcelsius ? Thanks...
Can anybody tell me what are the tuning problems?