2.What is loop? How resolve the loop?explain it?
Answers were Sorted based on User's Feedback
Answer / swades
If your universe is simple in terms of tables then go for
alias.
If your universe is complex in terms of tables then go for
Context.
Alias entails the propogation of the universe.
Contexts are not liked by the enduser because we are
forcing the enduser to the database which is the against to
the universe basic rule ie to keep the endusers away from
the database.
| Is This Answer Correct ? | 10 Yes | 17 No |
what is maximum scope of analysis --> can we define more than 3 levels?
How to link two different universes ?
HOW YOU WORKED WITH MULTIPLE DATA SOURCES?IF YES ?HOW DO YOU LINK THEM?
How to change English language to Chinese in BO Desiner (Universe)?
What task is 98% of the required work of a business analyst?
How can we acheive Correlated sub-query in Designer?
2 Answers Infosys, TCCX, Wells Fargo,
What are the traps ? What are the disadvantages of traps?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
what is custom sorting?how we can do this expalain with procedure???
how to improve the performance of the report
when you have three fact table and there is no relationship between them. How you will tackle the issue.
When we go for OLAP , and When we go for OLTP for generating the reports ?