If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

What function should i use to get member in DMR filter

Started by inu, 27 Oct 2016 08:32:11 AM

Previous topic - Next topic

inu

Hi Guys,

When i try to use member in slicer member set using set function , i get error

Set([Agreement Fact - Monthly (Analysis)].[Time Dimension(Fiscal)].[Date].[Quarter] -> ?om? --[Quarter] is level
Set([Agreement Fact - Monthly (Analysis)].[Time Dimension(Fiscal)].[Date].[Quarter].[Quarter Name] -> ?om? -- [Quarter Name] is member

Can i use member in slicer filter.
Requirement: I set use value as Quarter_key , passed on parameter ?om? and used above filter,,how to resolve the issue.
Error: XQE-PLN-0253

      An invalid value was assigned to Prompt 'Par_From_MonthYear'. The prompt expects a member, but the value assigned is not a member.




Your response is really appreciated.
PFA


Regards,
Inam