Explain the purpose of an (infocube/cube) and dimensions.
How do two components relate to each other? Why is it
important to identify an organisation’s key performance
indicators before developing a BI solution?



Explain the purpose of an (infocube/cube) and dimensions. How do two components relate to each oth..

Answer / suba

Cube is good for reporting .
If we have huge amount of data and need multidimensional
reporting then for best reporting performance cube is only
solution
Cube allows aggregates and compression which DSO not have .
Cube is good for line item level of data as it provides line
item and high cardinality dimensions.

So use a cube when data amount is large and good reporting
performance is required .

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Business Management AllOther Interview Questions

write a short note on inspection and supervision report and their uses

0 Answers  


Explain Risk Analysis?

0 Answers   MaxSolPro,


show that excise tax or sales tax imposes a Higher welfare cost than a lump- sum income tax of the same amount.

0 Answers  


What happened in the end and what did you learn from the experience?

0 Answers   John Clark Motor Group,


WHY I WANTED TO JOIN HAWKINS COOKERS LIMITED AS A HR?

0 Answers  






Differentiate between strategic and tactical decisions?

0 Answers  


explain different types of business memo

0 Answers  


Why we calculate supplier PPM (Part Per Million).WE can calculate Supplier performance in % also, why PPM ?

0 Answers   Honeywell,


Differance Between Stright Line and WDV Methed ?

0 Answers  


what are the main difference between saving with a bank and with insurance company.

0 Answers  


hello, where can i find the 1st sem mba vtu syllabus old question paper. regards, priya

0 Answers  


wat all we have to give answer for the question:- INTRODUCE ABOUT YOURSELF? pls specify the points which we've to mention in an interview.

1 Answers   FMCG, Hotel Jobs,


Categories
  • Business Administration Interview Questions Business Administration (517)
  • Marketing Sales Interview Questions Marketing Sales (1279)
  • Banking Finance Interview Questions Banking Finance (3208)
  • Human Resources Interview Questions Human Resources (745)
  • Personnel Management Interview Questions Personnel Management (68)
  • Hotel Management Interview Questions Hotel Management (29)
  • Industrial Management Interview Questions Industrial Management (113)
  • Infrastructure Management Interview Questions Infrastructure Management (14)
  • IT Management Interview Questions IT Management (97)
  • Supply Chain Management Interview Questions Supply Chain Management (16)
  • Operations Management Interview Questions Operations Management (39)
  • Funding Interview Questions Funding (79)
  • Insurance Interview Questions Insurance (494)
  • Waste Management Interview Questions Waste Management (1)
  • Labor Management Interview Questions Labor Management (48)
  • Non Technical Interview Questions Non Technical (73)
  • Business Management AllOther Interview Questions Business Management AllOther (546)