Interested to Buy Any Domain ? << Click Here >> for more details...
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 ?
- 1 Answers
- 8480 Views
- Virtusa, I also Faced
- E-Mail Answers
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
What are the join problems comes appart from loop,chasm & fan Traps
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
what is the difference b/w the refresh and buffered data?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
What are the steps to be taken to schedule the report?
Explain what are the steps to do to use alerts in bo?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
Explain 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)?
how to create metric universe ?
Can more than 1 metric be applied on an analytic in business objects?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
What Is Snow Flake Schema?
How to open a universe with out using the Designer ??
