How we can create the Intelligent cubes in Microstrategy?
Answers were Sorted based on User's Feedback
Answer / bharath kashyap
Intelligent Cubes can be created in microstrategy in public
objects folder or in a particular user folder. We can create
a report and point the report to a cube or right click in a
folder and click on cube option to create a new cube. once
the cube is created, choose the report objects (attributes
and metrics) which is required and save the cube. once the
cube is saved and ran to check without any errors, one can
create multiple reports out of a cube. also, you can add new
attributes and metrics when ever necessary and those will be
readily available when you run the reports next time.
| Is This Answer Correct ? | 16 Yes | 0 No |
Answer / praveen
Intellegence cube are created with the required attributes
and metrics and run the cube.
for the first time IC will run against the datawarehouse
and publish the data in a cube.
so IC is a memory to store certain amount of data.
On top of IC we create a report and run it.
Here report will not go and hit to the datawarehouse,it
gets the data from the IC.
Mainly IC are used when mulitiple reports are used to built
So instead of creating all the reports.It is better to
create an IC and on top of it create a report.
So that it will hit to IC instead of datawarehouse.
If we bulit multiple reports with out creating IC all the
reports go and hit to the datawarehouse.
| Is This Answer Correct ? | 3 Yes | 1 No |
how can we direct the sql generated to use a specifc table?
What is Element cache and give me one example?
How does microstrategy object manager determine if two projects are related?
Your application mode has crashed. How would you run your i-server?
What do you mean by consolidations?
What is non-aggregate metric?
What is smart metric?
Your colleague installed microstrategy on solaris or unix without root access. Will he be able to start/ restart this server?
What is fact degradation?
what are the different types of tests done on a microstrategy report?
Explain attribute?
what do you mean by custom groups?