How to to combine multiple date dimensions - LinkMember?

[Dundonian]

Hi Bill

It's all 2K based (SQL Server and Analysis Services).

In the database, I've added a TimeDimension table with all dates from 01 Jan 1999 up to 2030, and in the cube I've added a copy of this table with a suitable alias for each date in the fact table. I'm then using the date field from these aliased tables for my date dimensions rather than directly using the dates in the FACT table - otherwise I've found that some data seems to be missing in the cube after processing. Is this what you mean by "role-playing dimension treatment"? What's the next step to combining the aggregates of two different dates?

Colin

[Island1]

Sorry to hear you're not on 2k5 or later ... the suggestion I made earlier is not supported in 2k...

Are you moving to 2k5 soon? The built-in capability for role-playing dimensions is far superior to any "workaround" we might devise for 2k - and you'll almost certainly be reworking same upon upgrade if you do choose to work around it in 2k ...

Bill

[Island1]

Sorry to hear you're not on 2k5 or later ... the suggestion I made earlier is not supported in 2k...

Are you moving to 2k5 soon? The built-in capability for role-playing dimensions is far superior to any "workaround" we might devise for 2k - and you'll almost certainly be reworking same upon upgrade if you do choose to work around it in 2k ...

Bill