Answer Posted / v.sivakumar
In the universe level there is a concept named derived
tables.
We can create a derived table with our own query comparing
2 or more tables as per our requirement and we can generate
reports using the object from that derivesd tables.
In universe level , derived table is consider as View.
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What sort of existing documents should business analysts refer to when starting on a new project?
Explain difference between zabo and webi?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
Explain in detail about type 2(scd),
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?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
What is object stores?
Explain is there any other repository domains rather than universe, security, document?
Explain is there any default username & pwd for bo designer & supervisor?
Explain what are the steps to be taken to schedule the report?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Did you face any problems while creating reports? Name? Solutions?
how to create reports on screech?