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

Creating Date Prompt Using DMR Package

Started by Mpotla, 04 Oct 2010 10:14:38 AM

Previous topic - Next topic

Mpotla

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




rockytopmark

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.