Feature Request..

[vidhya]

Hi,

I find no option to pass the fields in a MDX Query to the message template or formatted message process action just like passing fields from a SQL query to message template or formatted message process action in design studio.

pls provide clarification on the above feature.

thanks
vidhya.

[bugg_tb]

The difference is in the result set, if you drag the result set of both sql and mdx to and xaction output you will see the difference between what is being written.

[vidhya]

Hi...


select NON EMPTY {[Measures].[SI], [Measures].[Rolematch]} ON COLUMNS,
NON EMPTY Crossjoin({[Proj.Hierarchy].[Project_Code].Members}, Crossjoin({[Email.Hierarchy].[Employee_Email].Members}, Crossjoin({[Name.Hierarchy].[Employee_Name].Members}, {[Role.Hierarchy].[Role_Name].Members}))) ON ROWS
from [SI_Alert]


I need to pass that Proj_Code to my msg template...

And my msg template doesn't recognise, anything which declared as a 'dimension' in the Cube..


Thanks,
Vidhya

[vidhya]

Hi...

Has no one tried passing the dimension of a mdx query to the "message template" of DS and been sucessfull at it?

Is this a bug...?Wen will this feature be incorporated in DS.
We are in the verge of our project and stuck with this issue for a long time..

-Vidhya