Using Oracle Materialized Views

[bluecosta]

Hello,
I'm using Microstrategy with more than two fact tables and i need to relate them. Does anyone have a suggestion on how can this be accomplished? I'm trying to use Materialized Views (Oracle database) but how can this be reflected in terms of Microstrategy project design.
Thanks and regards.

 

[jef2]

If your 2 tables are identical in terms or fields name, I think the path is MicroStrategy Partition mapping.

If you use Oracle rewrite and your 2 tables are at different levels, like hour and day. Then a report with the attribute hour in it would go to the hour table and if there's only day it could go to the day table..

 

[bi4fun]

BI4fun, And u ?

 

[myrcmstr]

I am getting 'time out error' while running the report. How can I solve this? What are the different ways?

 

[reisw]

Can you be a little bit more specific? What do the two tables have on them? What are the common columns?