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

U r project in which stage in implementation?

2039


Explain what is the difference between slice and dice and cross tab report?

693


Can we configure two instances of CMS pointing to two different CMS system databases?

1582


Explain about a time when you discovered a more efficient way to do a work task?

738


How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

790






How to generate the report from excel sheet?

700


how get the grand total in master-detail report?

1897


Explain what are the steps to do to use alerts in bo?

701


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

1851


what are the day to day activities of BO administrator ?

2061


Explain is it the job of a business analyst or systems analyst to draw the class diagram?

679


How many universes can be created in a project?

677


can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

1032


What is object stores?

662


What is the difference between absolute and relative div positioning?

676