Wednesday, 15 June 2011

Annualised Revenue - SUM of revenue for last 12 complete months SSAS mdx calculation -


I'm new to the MDX world and currently enhances the SSAS cube.

I am trying to create members of the computation in the SSAS cube (SUM of revenue for the last 12 full months) started under the MDX query to get the annual income for each device (product) As the beginner, but showing only its device name shows annual revenue (zero).

Need any correction for this MDX query? Or appreciate, if someone can give me an example on the basis of the Adventure Works Cube

calendar month], [invoice date]. [Calendar month]. [All duration]) .Log (12): Closing Period ([Invoice Date]. [Calendar Month]. [Invoice Calendar Month], [Invoice Date]. [Calendar Month]. [All Period]), [Measure]] Choose [Measure]. [Annual income] at 0, [Terminal]. [Terminal ID]. 1 to [cube_txn] Mimms; <[Code] [Calendar month]. [Invoice calendar year]. & Amp; [2013]) "

P> When it runs, it should be pick-up in the form of a base in the current month and should be calculated for the recurrence of the last 12 months

I expect the results below ( Ignore jan14 & j1515):

  DeviceID SumOfAnnualisedRevenue Jan 14 Jan 15 --------- --------------- ------- ----- ------ A10001 12,4500 5000 15000 A10003 45,50000 15000 78000 A10006 78,00 12000 890 A10008 89 45 450 120 

with this help?

  [measure] with member. [Annual income] AS Sum (closing period ([ Alan Date]. [Calendar month]. [Invoice calendar month], [date of invoice] [calendar month]. [All tense]). Lag (12) .item (0) .item (0): Closing Period ([Date of Invoice]. [Calendar Month]. [Invoice Calendar Month], [Invoice Date]. [Calendar Month]. [All Tenses]) .image (0) .im (0), [remedy]. [Volume]) SELECT [Measures] [Annual revenue] at 0, [terminal]. [Terminal id]. Mimes 1 to [cube_txn];  

If this is giving an error to [terminal]. [Terminal ID] .MEMBERS Then try one of the following (I can not say to make sure that which will work without seeing [terminal]. [Terminal ID]. [Terminal ID] .MEMBERS [Terminal] .MEMBERS [Terminal ID]. [Terminal ID] .MEMBERS


No comments:

Post a Comment