when we go for snow flake schema rather than star schema ?
Answer Posted / murali
snow flake schema is used for the dim tables contains more fields and the Dim_DB Tables are in the Normalization form.
Draw-back: Slow performance for executing the query.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
Explain when we use aggregate awareness function in designer?
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...
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!!!
How can you first report in Business Objects by using broadcast agent?
Explain what three things do you consider to be the most important factors for a manager?
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)?
When we use aggregate awareness function in designer?
Can we Save (save as) WEBI Doc as DESKI?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
What is Indexing? how did u implement indexing?
Which versions are used in the bo dashboard work?
what will be the contents for a functional requirements specifications
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
Differences between business objects and web intelligence reports?