Guest User

Untitled

a guest
May 26th, 2018
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.02 KB | None | 0 0
  1. with
  2. set [Measure Set] as '{[Measures].[ACTUAL_PPD]}'
  3. set [Company Set] as 'Filter({[Corporate Enterprise].[Company].Members}, ([Corporate Enterprise].CurrentMember.Properties("Accounting Number") = 151))'
  4.  
  5.  
  6. member Time.ref as [Time].[Date].[2011-12-31]
  7.  
  8. set DateRangeMonth as lastPeriods(12,
  9. Ancestor([Time].[Date].[2011-12-31],Time.Month)
  10. )
  11.  
  12. set DateRangeToday as lastPeriods(30,[Time].[Date].[2011-12-31])
  13.  
  14. set DateRangeTrailing as
  15.  
  16. Order({[Time].[Date].[2011-12-31].lag( 0),
  17. [Time].[Date].[2011-12-31].lag(30),
  18. [Time].[Date].[2011-12-31].lag(60),
  19. [Time].[Date].[2011-12-31].lag(90),
  20. [Time].[Date].[2011-12-31].lag(120),
  21. [Time].[Date].[2011-12-31].lag(150),
  22. [Time].[Date].[2011-12-31].lag(180),
  23. [Time].[Date].[2011-12-31].lag(210),
  24. [Time].[Date].[2011-12-31].lag(240),
  25. [Time].[Date].[2011-12-31].lag(270),
  26. [Time].[Date].[2011-12-31].lag(300),
  27. [Time].[Date].[2011-12-31].lag(330)
  28. },Time.currentMember.level.ordinal)
  29.  
  30.  
  31. set dateset as DateRangeMonth
  32.  
  33. member [Measures].[MCD_FLAG Days] as 'Aggregate(LastPeriods(30,Time.currentMember), ([Measures].[MCD_FLAG]))'
  34. member [Measures].[MCA_FLAG Days] as 'Aggregate(LastPeriods(30,Time.currentMember), ([Measures].[MCA_FLAG]))'
  35.  
  36. member [Measures].[Actual PPD new Days] as 'Aggregate(LastPeriods(30,Time.currentMember), ([Measures].[Actual PPD new]))'
  37.  
  38.  
  39. member [Measures].[MCD_FLAG] as '(1.0 - [Measures].[MCD])'
  40. member [Measures].[MCA_FLAG] as '(1.0 - [Measures].[MCA])'
  41.  
  42. member [Measures].[ACTUAL_PPD] as 'IIf(([Income Statement].CurrentMember.Name = "Medicare Part A Total"), [Measures].[MCA_PPD], [Measures].[MCD_PPD])'
  43.  
  44. member [Measures].[MCD_PPD] as 'IIf(([Measures].[MCD_FLAG Days] = 1.0), NULL, [Measures].[Actual PPD new])'
  45. member [Measures].[MCA_PPD] as 'IIf(([Measures].[MCA_FLAG Days] = 1.0), NULL, [Measures].[Actual PPD new])'
  46.  
  47. select
  48. dateset ON COLUMNS,
  49. ([Company Set] * [Measure Set]) ON ROWS
  50. from [GL Actual and Budget]
  51. where [Income Statement].[Income Statement].[Revenues].[Patient Care Revenue].[Medicare Part A Total]
Add Comment
Please, Sign In to add comment