Post reply

Presenting multiple cubes to user in Excel pivot table - possible?

  • November 10, 2008 at 10:28 am

    #215090

    I have a couple of scenarios where forecast data is maintained at a higher level than the detailed actual data. I realize I need to maintain two different fact tables, each at their appropriate level of granularity.

    My question is, what is the best way to present this information to the user? The users like the idea of using Excel and pivot tables. Is there a way for them to view actuals and forecasts in the same pivot table since they are coming from different fact tables (and therefore, I think, different cubes)?

    Thanks,

    Steve

  • November 11, 2008 at 9:37 am

    #897026

    Assuming AS2005/8 you don't need multiple cubes, simply use multiple fact tables (Measure Groups) and join from the facts to associated dimensions at the appropriate level (e.g. Plan may join to Time on Month instead of Day).

    For AS2000, you could use linked cubes which has the same result as above but has a few other requirements on Dimensions.

    HTH,

    Steve.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply