what function should be used in dmr report for multi select

[inu]

Hi Team,

In relational model i was using the following statement in detail filter as
[Agreement Fact - Monthly (Analysis)].[Branch].[Region].[Region] in ?Par_Region?

But in dmr when i use set([Agreement Fact - Monthly (Analysis)].[Branch].[Region].[Region]->?Par_Region?) in slicer, for multiselect,  i get error.


Can you please suggest me here.


Regards,
Inam

[MFGF]

Hi Team,

In relational model i was using the following statement in detail filter as
[Agreement Fact - Monthly (Analysis)].[Branch].[Region].[Region] in ?Par_Region?

But in dmr when i use set([Agreement Fact - Monthly (Analysis)].[Branch].[Region].[Region]->?Par_Region?) in slicer, for multiselect,  i get error.


Can you please suggest me here.


Regards,
Inam

...and the error is?...

MF.

[inu]

...and the error is?...

MF.

Parameter was conflicting with relational model.
I used detail filter , it worked...But i wanted to use set() function using slicer.

Thanks,
Inam

[MFGF]

Parameter was conflicting with relational model.
I used detail filter , it worked...But i wanted to use set() function using slicer.

Thanks,
Inam

What is the error? It can't be that difficult to tell us, can it?

MF.

[inu]

What is the error? It can't be that difficult to tell us, can it?

MF.

Thanks a lot...
Yes MF. now error is resolved , but if i use slicer, then it will be required prompt. i want to set this filter as optional.
Is it possible to make slicer as optional.?



Regards,
Inam

[bdbits]

Use a #prompt macro with defaultText.

[inu]

Use a #prompt macro with defaultText.

Yes, I am using this one but not working for default value..

Can you please give me the syntax..


Regards,
Inam

[MFGF]

Yes, I am using this one but not working for default value..

I can't believe how hard you are making it for people trying their best to help you! What does "not working" mean? Error? Wrong result? No result? Something else?

Please give as much detail as possible.

MF.