Print Page - Drill through on in dynamic cube on time dimension not working.

Title: Drill through on in dynamic cube on time dimension not working.
Post by: Srik on 30 Nov 2018 09:20:04 PM

Hi,

When i try to drill through from Dynamic cube to Report studio report on time dimension. it fails with below message. Also tried converting field in Report studio to Date format.

XQE-PLN-0019
Need to resolve prompts.
XQE-PLN-0103 Invalid format for prompt 'p_ar_period_date'. Expected format for date: CCYY-MM-DD.

Any idea how it can be resolved.

Title: Re: Drill through on in dynamic cube on time dimension not working.
Post by: MFGF on 03 Dec 2018 04:21:26 AM

Quote from: Srik on 30 Nov 2018 09:20:04 PM
Hi,

When i try to drill through from Dynamic cube to Report studio report on time dimension. it fails with below message. Also tried converting field in Report studio to Date format.

XQE-PLN-0019
Need to resolve prompts.
XQE-PLN-0103 Invalid format for prompt 'p_ar_period_date'. Expected format for date: CCYY-MM-DD.

Any idea how it can be resolved.

Can you share with us the filter expression you are using in the target report?

MF.

Title: Re: Drill through on in dynamic cube on time dimension not working.
Post by: Srik on 03 Dec 2018 07:34:39 AM

filter in Report studio report. I'm converting as create_date from date time to date.

"cast([Create_date],date)" in_range ?start_date_p?

Title: Re: Drill through on in dynamic cube on time dimension not working.
Post by: andigrill on 13 Feb 2025 07:09:53 AM

What value are you passing to the report?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Dynamic Cubes => Topic started by: Srik on 30 Nov 2018 09:20:04 PM