SHARE
TWEET

Untitled

a guest Jun 15th, 2019 60 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE DYNAMIC SET CURRENTCUBE.[Latest]
  2. AS strtomember('[Date].[Date Key].&['+
  3. vba!Format(DateAdd('d',-1,Now()),'yyyyMMdd')+']');
  4.      
  5. CREATE MEMBER [TwoDaysBack] AS
  6. (
  7.       [Date].[Date Key].currentmember.prevmember,
  8.       [Measures].[PL]
  9.     ) ;
  10.      
  11. CREATE DYNAMIC SET CURRENTCUBE.[Latest]
  12. AS strtomember('[Date].[Date Key].&['+
  13. vba!Format(DateAdd('d',-1,Now()),'yyyyMMdd')+']').prevmember;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top