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 |
Is it possible to Delete duplicate rows at row level?
What do you mean by mstr?
What do you mean by dimensional modeling and relational modeling?
Write the components microstrategy metadata?
What is report as filter in microstrategy?
How does microstrategy object manager determine if two objects in different projects are the same?
Can intelligence server integrate with my existing data structure?
To save time, can many reports be run at the same time?
What do you mean by xml cache?
Intelligent cube is a public object or schema object in microstrategy?
What happens if the owner of an object does not exist in the destination project?
Can I deploy a single bi application in multiple languages?