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
The above error message appears when drilling through from Analysis Studio OLAP source to a Report studio report to pass a date parameter.
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
- Open the Cognos 7.x Transformer model in Cognos 8.x Transformer and re-build the cube
|Business Analytics||Cognos Business Intelligence||Analysis Studio||Windows||8.3|