COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: inu on 27 Oct 2016 08:32:11 AM

Title: What function should i use to get member in DMR filter
Post by: inu on 27 Oct 2016 08:32:11 AM
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