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
- 1 Answers
- 9978 Views
- Cognizant, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
How is the number of passes in a sql query significant in performance evaluation?
What is a compound attribute in microstrategy?
what are the different authentication modes available in microstrategy?
What is an object prompt in microstrategy?
Explain security role?
Explain access control?
what do you mean by custom groups?
What are the different types of metrics available in microstrategy?
If your client wanted to customize the null value, how would you do that?
You have got the requirement from a client. Explain the technical approach you will take now.
Explain confirmed dimensions. When are they used?
What do you mean by static prompt report?
You are required to update a table in warehouse. Can you do it with the help of microstrategy?if yes, how?
Now, imagine this, you come across a situation where an aggregate table at higher level has a higher lts than the one at lower level. A.) What problems can you anticipate? B.) How would you solve the problem.
Can intelligence server integrate with my existing data structure?
