Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: inu on 02 Nov 2016 01:15:57 AM

Title: what function should be used in dmr report for multi select
Post by: inu on 02 Nov 2016 01:15:57 AM
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
Title: Re: what function should be used in dmr report for multi select
Post by: MFGF on 02 Nov 2016 03:36:24 AM
Quote from: inu on 02 Nov 2016 01:15:57 AM
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.
Title: Re: what function should be used in dmr report for multi select
Post by: inu on 02 Nov 2016 09:06:53 AM
Quote from: MFGF on 02 Nov 2016 03:36:24 AM
...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
Title: Re: what function should be used in dmr report for multi select
Post by: MFGF on 02 Nov 2016 10:20:46 AM
Quote from: inu on 02 Nov 2016 09:06:53 AM
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.
Title: Re: what function should be used in dmr report for multi select
Post by: inu on 03 Nov 2016 02:12:06 AM
Quote from: MFGF on 02 Nov 2016 10:20:46 AM
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
Title: Re: what function should be used in dmr report for multi select
Post by: bdbits on 10 Nov 2016 05:05:31 PM
Use a #prompt macro with defaultText.
Title: Re: what function should be used in dmr report for multi select
Post by: inu on 11 Nov 2016 12:14:32 AM
Quote from: bdbits on 10 Nov 2016 05:05:31 PM
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
Title: Re: what function should be used in dmr report for multi select
Post by: MFGF on 11 Nov 2016 03:28:57 AM
Quote from: inu on 11 Nov 2016 12:14:32 AM
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.
Text only | Text with Images