Yeah. Thats a nice idea pravin. i will follow the same.

Thank you...

Converting MDX2Json that doesn't matter here.

In background task, i am quiting json. I dont know how to store the json into a session.

In general if i write like this,

S json=..ConvertMDX2JSON(MDXQuery)

I will get json data for the MDX Query. But, if i go for complex MDX, it will take more time to convert and will get timeout error.

So i am doing this in background task and want to store the result json in session.

Hi Peter,

When i try with single value filter, I didn't get any error. Lets say.

%FILTER %OR([HOMED].[H1].[ZIP].&[32000])

Here 32000 is not a member. This executes fine and i got result 0 without any error.

When trying with multiple value filter, if any non member exists in filter thrown error.

if all are member in a filter, works fine.

Is there any way to restrict this?
Front end user will select anything in filter. But it should work.

32000(non member) gives result 0. 
32006(member) gives result 13.

if user selects 32000 and 32006, it should give (0+13=13).

I Didn't find the same situation or logic in holefoods or patients cube.

Hi Eduard,

I need to write mdx in the below format.

Because, i convert my MDX into JSON and using the json string i do some calculations and finally displaying all together into html table in zenpage.

 If i use listing concept. I don't know it will work.

I want to display only these records which are shown above in blue text. So my output will be like this

i.e , Group by FileName, Top1 Record from each filename, Order by AuditDate Desc(latest filestatus).

Great.

This is working fine in both pixels and percentage in 2016.1 version.

But, In 2014.1 version width calculates only in pixels(Not in percentage).

Thanks