Thanks a lot.I was able to find time to try that out only today. It is working fine.

Hi,

Thanks pete.griffiths. I am doing it currently in the cube only and it is giving correct results. But since I have many more calculations based on this YTD and MAT...

Thanks Steve. I tried it and had been successful in implementing it for a single value that I pass. How do I dynamically decide the role based on the...

Thanks Dan, It works fine

Hi,

Thanks a lot brdudley and Hendra Eka Putra . I was able to get what I wanted using the Root function.When you get the reference for...

The following is the way I created the market share calculation

CREATE MEMBER CURRENTCUBE.[MEASURES].ValueMarketShare

AS

Case

When IsEmpty

(

[Measures].[Sales...

Hi,

Thank you. It works fine.But if I would like to decide whether it is for 2 years or three years dynamically by finding the difference between the years, How do...