What type of schemas did you use in your project?Andwhy did
you use that schema
- 1 Answers
- 5334 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / manasa
Schemas are three types.These are star schema,snowflakes
schema,galaxy schema.
In my project i am using star schema.star schema is nothing
but a facttable is surrounded by dimensional tables.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
Explain is there any other repository domains rather than universe, security, document?
Explain when to use local filter and when to use global filter?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
What would you consider as your biggest achievement and why?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
Explain about a tricky situation for which you found a very simple solution?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What is the functional & architectural differences between business objects and web intelligence reports?
what are the day to day activities of BO administrator ?
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...
How to create Index to the table in the universe designer and how it improves the Query performence
