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


Please Help Members By Posting Answers For Below Questions

I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

3000


Explain what sort of existing documents should business analysts refer to when starting on a new project?

608


When we use aggregate awareness function in designer?

552


Explain how we drill up week to month?

643


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

1433






in sap bi we have wad, then why we go for sap bo

2779


What are all difference between business objects 6.5 and xi r2?

608


What is the difference in creating filters in designer and business objects?

592


Explain when to use local filter and when to use global filter?

610


How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

1894


Explain how to schedule the report in b.o?

567


is it possible to export the webi reports to crystal reports?with out using businessview?

1824


How many universes can be created in a project?

599


what are the day to day activities of BO administrator ?

1980


Explain what is aggregate table and aggregate fact table ... Any examples of both?

614