Answer Posted / tilak
1)usinf aggregated tables
2)using shortcut joins
3)removing unwanted classes and objects
4)removing unwanted joins
5)lov should be based on smaller look up tables
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Explain what is the difference between business requirement document and use case document.
Explain about a tricky situation for which you found a very simple solution?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
Explain how to schedule the report in b.o?
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 The Difference Between Oltp And Olap?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
When we use aggregate awareness function in designer?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
what are the tables used in health care domain project and columns used in report?
how to create reports on screech?
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...
8. How much supervision have you typically received in your previous job?
how many reports have u created ? explain a few.
Which versions are used in the bo dashboard work?