calculated measure in ssas

Hi all,

how to put these calculated measures under the folder "sales line". i want to see it under the drop down...

Thanks

ran

September 2nd, 2015 9:59am

Hi,

once u can enter the display folder in the GUI of calculated measures or if u use scriptview add

,DISPLAY_FOLDER ='Sales Line', or if u have BIDS HElper update the calculation properties

Free Windows Admin Tool Kit Click here and download it now
September 2nd, 2015 10:22am

Hi,

I lost the folder total gm % can you guide me how to get it back??

September 2nd, 2015 11:47am

can u post the calulation script?

Free Windows Admin Tool Kit Click here and download it now
September 2nd, 2015 2:33pm

Hi Ranjan DS,

In Analysis Services, the folder appear in SSMS is measure group. Based on your screenshot, it looks like the Total GM% is a calculated measure. If you want to add the Total GM% into the "Sales Line" measure group, you could add the Associated_Measure_Group="Sales Line" at the end of the Create Member statement. 

Reference:
CREATE MEMBER Statement (MDX)

Regards,

September 5th, 2015 3:52am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics