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
Try using the subsitute function along with MUN to pass different values of the same parameter
Thanks for the reply. Can you please explain this in more detail. Cheers.
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.
Quote from: Juni on 20 Jul 2015 09:46:01 PM
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.
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,