Hi ,
I have DMR package created, Which time dimension is one of the dimension with Year->Qtr->Month->Date.
I want to allow the user to select dates using the Date prompts.
When i created the Date prompt by taking Date level . Its giving me error
OP-ERR-0217
An unexpected type of parameter value was encountered. The specified parameter type is 'date', but the expected type is 'memberUniqueName'. Error processing filter 'members([Data History].[Time].[Time].[Date]) = ?Date?' .
i have tried adding the Members of to the level and getting the same error.
Please help me resolving the issue. I am Creating the report for the first using the DMR package.
Regards,
Potla
Try:
[Data History].[Time1].[Time2] = ?pDate? ... for selection of a single member
or
[Data History].[Time1].[Time2] in (?pDate?) ... to allow for multiple member selection
...assuming Data History is a Namespace, Time1 is a Regular Dimension and Time2 is a Hierarchy defined within the dimension.