Home > Archive > MS SQL Data Warehousing > July 2005 > Cube and DW Design









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Cube and DW Design
Hiram Fernández

2005-07-22, 8:23 pm

Hello,

I have a fact table with the following fieds:

docID
DueDate
Amount


And I want to design an OLAP Cube that contains these indicators:

Current A/R
1 to 30
31 to 60
61 to 90
> 90


And these dimensions

Products
Customers
Stores
Time (Year, Month, Day)

But i don't want to make a snapshot of each period of time. I want to be
able to calculate on the fly the indicators using [time].CurrentMember

Any Ideas

Regards,


Hiram


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com