Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


why consolidation and custom group not used in ic cubes. and
then i will over come by derived element..
what my question is ...even (consolidation and custom group)
also derived element,why we are not used.

Can any body give the assistant for this issues...

Regards,
sekhar



why consolidation and custom group not used in ic cubes. and then i will over come by derived elem..

Answer / adarsh katiyar

please get familiar with the basic concept of MicroStrategy Intelligent Cubes. There are certain limitation to MicroStrategy functionality when using Intelligent Cubes. You already mentioned Consolidations and Custom Groups... but there are further features to consider like Level metrics and so on...




Let me pick Custom Groups as example. A custom Group allows you to combine unrelated "queries" with each other. For example you can determine Top 20 customers, report the revenue of all customes with M, and add some regional figures in a single custom group. Technically this will result is different queries on the database, due to the fact that each calculation level is different. Most likely several, different fact tables are uses for each query.




When using an Intelligent Cube, you already have an in memory dataset. This dataset needs to contain all data in the required granularity. When you need data outside of the cube to perform certain calculations, this is not possible.... these data are missing.




My assumption is that certain features can simply not be used with cubes to avoid bad user experiences and reduce complexity.

Is This Answer Correct ?    7 Yes 0 No

Post New Answer

More Micro Strategy Interview Questions

hi i want to learn microstratogy please anyone help to me which institute is best in bangalore any one having related documents ,and video link please mail to this id avanthireddykv@gmail.com

0 Answers  


Can I access intelligent cubes without olap services?

0 Answers  


What happens if the owner of an object does not exist in the destination project?

0 Answers  


Explain fact table?

0 Answers  


Explain the Roles in mstr?

0 Answers  


How to do performance tuning on reports.

3 Answers  


What do you mean by trimming sql in microstrategy?

0 Answers  


Describe implicit attribute?

0 Answers  


What olap capabilities do I have within a microstrategy report services document?

0 Answers  


I have 5 different country names and their currencies like India-Rupee, USA-Dollar etc. when I run the report, the report should display only either currencies or country names.How to run the report?

3 Answers   L&T,


Explain three-tier connection?

0 Answers  


hi,can you share with me about,what is prompt order,how it uses and how it creates

1 Answers  


Categories