solve the following loops?
dimension table
fact table fact table
dimension table
link will be there between tables?
Answer Posted / satya
By creating alias table for one dimension, we can resolve
the loop
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What is a bo repository?
What is difference between custom hierarchy and report based hierarchy?
What is difference between webi and infoview?
What is the profile and package?
Explain how to schedule the report in b.o?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What three things do you consider to be the most important factors for a manager?
(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.
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...
Which command using Query Analyzer will give you the version of SQL server and operating system ?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
What sort of existing documents should business analysts refer to when starting on a new project?
What is a fantrap in business objects?
What are the steps to be taken to schedule the report?
What is the difference between user and versatile user?