Expected format for date: CCYY-MM-DD error when drilling through from OLAP source to relational report

Technote (troubleshooting)


Problem(Abstract)

The following error is received when drilling through from Analysis Studio OLAP source to Report Studio relational report based on Date:

QE-DEF-0381 Invalid format for prompt '<promptname>'. Expected format for date: CCYY-MM-DD

Symptom

The above error message appears when drilling through from Analysis Studio OLAP source to a Report studio report to pass a date parameter.

Cause

In this particular case, the transformer model was created in Cognos 7.4 Transformer and used in Cognos 8.3 as an OLAP data source.

Resolving the problem

Steps:

- Open the Cognos 7.x Transformer model in Cognos 8.x Transformer and re-build the cube


Cross Reference information
Segment Product Component Platform Version Edition
Business Analytics Cognos Business Intelligence Analysis Studio Windows 8.3

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Cognos 8 Business Intelligence
Analysis Studio

Software version:

8.3

Operating system(s):

Windows

Software edition:

All Editions

Reference #:

1393556

Modified date:

2009-07-13

Translate my page

Machine Translation

Content navigation