I have a cube that has the following:
[Measures].[Leads] , [Measures].[Sales]
The dimensions are [Publication] and [Date]

Right now I have the users access an Excel spreadsheet that is attached to
an OLAY cube as described above.
The users would also like to get [YTD Leads] and [YTD Sales] along with the
existing measures.

Can someone point me the approach I should take so that they can get all
this additional YTD info in the current spreadsheet?

Thanks,
S.Kumar

Here is the MDX for YTD...

Create two calculated Members in your cube.

Sum( YTD(), [Measures].[Leads] )
Sum( YTD(), [Measures].[Sales] )
"Suresh Kumar" <skumarNoSpamATpcdiDOTcom> wrote

Thanks... That did it.

"AshVsAOD" <.> wrote

Ash,
There is an additional request from the users.

They would like to know if the cube would present the spreadsheet in the
ascending order of a calculated field called [Cost per Sales].


"AshVsAOD" <.> wrote

Here is an example from the Foodmart database... Basically just use the
ORDER and the BDESC commands.

SELECT { [Time].&[1997] } ON COLUMNS ,

{ ORDER( { [Product].[Product Family].&[Drink].&[Alcoholic Beverages].&[Beer
and Wine].&[Wine].&[Top Measure].CHILDREN }, ( [Time].&[1997] ), BDESC ) }
ON ROWS

FROM [Sales]

WHERE ( [Measures].[Unit Sales] )

Good luck!



"Suresh Kumar" <skumarNoSpamATpcdiDOTcom> wrote

How do I incorporate this into the cube as one of the measures?
Can this be made into a calculated field?
Thanks in advance
S.Kumar

"AshVsAOD" <.> wrote