Cognos report based on DMR cube issue

[Juni]

Hi,
I am having an issue with my Cognos 10 report which is based on DMR. The cube has got 2 dimensions with following levels
Financial Date --> Year --> Half Year --> Quarter --> Month
Placement Date --> Year --> Half Year --> Quarter --> Month
The report has got one prompt based on Financial Date --> Year --> Half Year --> Quarter --> Month with parameter p_Date
I have two queries in the report q_JobOrder and q_Placements
Month filter for q_joborder is [Operations Cube].[Financial Date].[By Financial Date (Daily)].[Financial Month] -> ?p_Date?
Month filter for q_Placement is [Operations Cube].[Placement Start Date].[By Placement Start Date].[Financial Month] -> ?p_Date?
In my report q_placement is not filtered correctly and now showing correct data. Looks like it is filtered based on Job ORder date and not placement date.
Hope I am able to explain my issue
Please help. Thanks

[imeu]

Try using the subsitute function along with MUN to pass different values of the same parameter

[Juni]

Thanks for the reply. Can you please explain this in more detail. Cheers.

[Juni]

I tried the below but it is not working. Parsing error
[Operations Cube].[Placement Start Date].[By Placement Start Date].[Financial Month] -> #sq(substitute('[Financial Date].[By Financial Date (Daily)]','[Placement Start Date].[By Placement Start Date]',?p_Date?))#

[Operations Cube].[Placement Start Date].[By Placement Start Date].[Financial Month] ->  substitute('[Financial Date].[By Financial Date (Daily)]','[Placement Start Date].[By Placement Start Date]',?p_Date?)

Anyone help please.

[MFGF]

I tried the below but it is not working. Parsing error
[Operations Cube].[Placement Start Date].[By Placement Start Date].[Financial Month] -> #sq(substitute('[Financial Date].[By Financial Date (Daily)]','[Placement Start Date].[By Placement Start Date]',?p_Date?))#

[Operations Cube].[Placement Start Date].[By Placement Start Date].[Financial Month] ->  substitute('[Financial Date].[By Financial Date (Daily)]','[Placement Start Date].[By Placement Start Date]',?p_Date?)

Anyone help please.

What is the MUN of a Month member from the Financial Date dimension? Can you post it up? Can you do the same for a Month member from the Placement Date dimension? It may be possible to construct each MUN using a prompt macro, but we'd need to see the MUNs first to know if this is viable.

MF.

[Juni]

the two MUNs are
[Operations Cube].[Financial Date].[By Financial Date (Daily)].[Financial Month] -> [all].[2015].[2].[3].[201501]

[Operations Cube].[Placement Start Date].[By Placement Start Date].[Financial Month] -> [all].[2015].[2].[3].[201501]

Thanks,