Thanks ,

for the reply, what i did eventuaually was to create a set as advised, then from the set created i was able to create measures for any of...

What I am trying to do is to pick a month(dynamically) in a set and construct a turple with it

for example

If I have a dimension of dimdate with English month...

What I am trying to do is to pick a month(dynamically) in a set and construct a turple with it

for example

If I have a dimension of dimdate with English month...

I used ole db provider for sql server and it is ok now

Thats not the issue, but i can spot what is happening , but i cant fix it,

the situation is that

DFB JAN FEB MAR APR

0...

the problem was with my subcube

select

(nonempty([PTF].[Cred].[cred].ALLMEMBERS,[Measures].[Acc Count]))

on columns

from

[MYCUBE]);

Thanks for the response, I wa clicking on the chart area instead of on the area that has the value I will like to enable the drill through action on

AS regards the Hidden data,

The example I was following online by roopesh (https://www.youtube.com/watch?v=keHDpyeuHkg).

in the tutorial, when he declared the parameter , the dataset was created automatically...

Hi, Please do you have an idea, why the hidden dataset is not showing, and also any book you can recommend that deals in ssrs for mdx , cheers

I was following a tutorial online, but the authour did not specify that I had to create another dataset for the parameter. so I

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6ce3fbaa-bc6d-4411-bb1f-aaecaaede3cc/ssrs-passing-multivalued-parameters-to-mdx?forum=sqlreportingservices

then cretaed another dataset...