dbTalk Databases Forums  

Last periods - passing current date

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


Discuss Last periods - passing current date in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
bhorwatt
 
Posts: n/a

Default Last periods - passing current date - 11-07-2003 , 07:57 AM







I would like the member in the lastperiods function to be the member
that is the current date or current month, ie, the last date with data
in it in the cube. Filtering on the last not IsEmpty date seems
inefficient when I know what date I want. I am trying to convert an
Essbase cube to AS. To accomplish this task in Essbase, I used
substitution variables to pass in the member that was current date. I
am looking for equivalent technology in AS.


--
Posted via http://dbforums.com

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.