when we go for snow flake schema rather than star schema ?
Answer Posted / babu
whether the schema contains in normalized form and data should be redundancy is required then we go for snow flake schema and the dimension table should split into another child table in this situation we go for snowflake schema rather than star schema.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
(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 will be the contents for a functional requirements specifications
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
how to prepare the documentation in business objects and where to get the requirement?
explain in detail about type 3?
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...
Difference between b.o 5.1 and 6.1b?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Which command using Query Analyzer will give you the version of SQL server and operating system ?
What is the difference in creating filters in designer and business objects?
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
In banking domain how many Fact tables,Dimension table are present?
What is the functional & architectural differences between business objects and web intelligence reports?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?