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
U r project in which stage in implementation?
Explain what is the difference between slice and dice and cross tab report?
Can we configure two instances of CMS pointing to two different CMS system databases?
Explain about a time when you discovered a more efficient way to do a work task?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
How to generate the report from excel sheet?
how get the grand total in master-detail report?
Explain what are the steps to do to use alerts in bo?
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!!!
what are the day to day activities of BO administrator ?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
How many universes can be created in a project?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
What is object stores?
What is the difference between absolute and relative div positioning?