How we can create the Intelligent cubes in Microstrategy?
Answer Posted / 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 |
Post New Answer View All Answers
Does microstrategy intelligence server run on windows®, unix®, or linux®?
What is the order of precedence of vldb properties?
Can a record be inserted and updated in database using microstartegy?
What are prompted filters? Have you ever used them? Where?
Explain static reports?
Is it possible to get a floating window in microstartegy web? If yes, how?
Explain fact?
What do you mean by trimming sql in microstrategy?
1.Have u logical models in project? If s which logical model used? 2.how do u connect to production server? 3. how do u test the data in report is same as in DWH? 4. u created one report but there is no data in the attribute. But how can u extract the data from ware house? 5. u have two tables having different ids how do u merge those table in MSTR? 6. have u faced challenging situation in u r project? Give me one example?
What do you mean by dimensional modeling and relational modeling?
What is transformation metric in microstrategy?
Explain the difference between rolap and molap?
what are the different types of fact structures?
Explain fact table?
suppose the network connection between a webserver and clustered i-server gets lost. What will happen? Will the report still run?