Many people said to me that Microstrategy 7.2.X don't work well with a Star-Schema model.
To ask my doubts i research in Mstr support site and found the follow lines :
Question : "What types of schemas does MicroStrategy 7.x support? Is there a preferred schema? Does MicroStrategy 7.x support star schemas?
Answer:
MicroStrategy 7.x supports almost all schemas other than a consolidated star schema with level indicators. MicroStrategy does not recommend the use of consolidated star schemas since they limit functionally and are maintenance-intensive. "
Defects and Enhancements addressed in MicroStrategy 7i-7.2
MicroStrategy SQL Generation Engine(Product) 136745(log ID) 7.1.2(versão reportada) 123742(case) - Incorrect results with star schema and Partitioning when the attribute display is not the ID (last join to lookup table causes a partial Cartesian join)
I need your help...
I'll wish to know what your experience tell you about this "relationship" Mstr7.2.X - Star-Schema ...
Many Thanks..