Home > Archive > MS SQL Server OLAP > December 2005 > MDX lag()









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 MDX lag()
sd@dbconn

2005-12-29, 9:23 am

hi,
i'm not shure about the implementation of the lag() function in AS 2005.
What happens when the lag() goes backward the firs member in the level.
Using the following Statement:
max([Due Date].[Fiscal Time].currentmember:[Due Date].[Fiscal
Time].currentmember.lag(6)
I get strange Results for the firs 5 members of 'current level' ....

thanks for help




Sponsored Links





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

Copyright 2008 droptable.com