Analytics Software

All the OBIEE gurus, thanks for checking out this post.


Background: We have a common DIMENSION referencing two FACT tables having different granularity.


DIM = Customer Dim

FACT = Forecasting (Weekly granularity)

FACT = Sales (Daily granularity)


There is a need to report from the Customer Dimension table AND access the Forecasting FACT (weekly grain) & Sales FACT (daily grain).


Example of query is listed below:

Give me customer = 'ABC' and the forecast and sales for a specific time period.


What will be the best way to handle something like this? I have seen examples of handing multi-fact table access in OBIEE but the granularity of both the FACT tables is different (weekly vs. daily).

Any help with an example is greatly appreciated.

Thanks,

Sunshine