1.How is "Query drill" mode different from standard drill
mode?.
2.Under what circumstances are you most likely to choose to
use "Query drill" mode instead of standard query mode?.
3.How do you implement the type2 slowly changing dimensions
in your project?.
4.what is meant by Junk dimension?.
5.what is meant by Drill across?.
Answer Posted / alok
4.A junk dimension is grouping of low cardinality flags and indicators. Like for ex when some one processing a order .No all the information like prouct price order id these are important dimension . But if the information is like order place on phone or online, coupon applied or not . like that .
5. drill across directs the drill path to entirely different dimensions or reports across a spectrum of datasets.Like link to new Report . For one report
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What Is Snow Flake Schema?
Is there any other repository domains rather than universe, security, document?
Explain how many universes can be created in a project?
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
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
can anybody tell me about complicated object you have created
How many universes can be created in a project?
What is the dense rank?
What is a bo repository?
How were the reports scheduled and how to resolve unexecuted documents?
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?
What is the difference between user and versatile user?
Explain is data mart?
What are the data types present in bo? What happens if we implement view in the designer and report?