Interested to Buy Any Domain ? << Click Here >> for more details...
solve the following loops?
dimension table
fact table fact table
dimension table
link will be there between tables?
- 4 Answers
- 7756 Views
- I also Faced
- E-Mail Answers
Answer Posted / riaz
link like......
dimension table TO 2 fact table1s
this is called "CONFORMED DIMENSION"
dimension table which is connected to multiple fact tables
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain how to execute the plsql procedure from the report by clicking with mouse?
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...
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Explain is there any other repository domains rather than universe, security, document?
Can we create universe with no cache??
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 generate the report from excel sheet?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
explain in detail about type 3?
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
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
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
