dbTalk Databases Forums  

AS2005: looking for a "generic" period to date formula...

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss AS2005: looking for a "generic" period to date formula... in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jéjé
 
Posts: n/a

Default AS2005: looking for a "generic" period to date formula... - 03-07-2006 , 07:47 AM






Hi,

I want to create a calculated measure which is a "first member to date"
formula.
So I'll cumulate all data from the first member to the current one.

but I want a generic formula which works with "any" attribute from the time
dimension.
because the user not allways go through my standard hierarchy (year, month ,
day) and can select any attribute directly, I don't want to write 4 times
the formula for each attribute available.

I have not found a "currentdimension" formula.

so... there is any solution?

thanks.

Jerome.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.