Advertisement
Guest User

Untitled

a guest
Oct 31st, 2014
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1. With
  2. Member [Time].[Period] as
  3. Aggregate( ${dateFromParameter} : ${dateToParameter} )
  4.  
  5. Member [Measures].[Unit Price] as [Measures].[Sales] / [Measures].[Quantity]
  6.  
  7. Member [Measures].[Contact Name] as
  8. [Customers].CurrentMember.Properties("Contact First Name") || " " ||
  9. [Customers].CurrentMember.Properties("Contact Last Name")
  10.  
  11. Set CUSTOMERS as Filter( [Customers].[Customer].Members, [Measures].[Sales]>0 )
  12.  
  13. Select
  14. CUSTOMERS on ROWS,
  15. { [Measures].[Contact Name],
  16. [Measures].[Sales],
  17. [Measures].[Quantity],
  18. [Measures].[Unit Price]
  19. } on COLUMNS
  20.  
  21. From [SteelWheelsSales]
  22.  
  23. Where
  24. ( [Markets].[${territoryParameter}].[${countryParameter}],
  25. [Product].[${productParameter}],
  26. [Time].[Period] )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement