Print Page - Date Format in SAP BW

Title: Date Format in SAP BW
Post by: anandapr on 19 Sep 2010 06:36:51 PM

Hi-

Greetings.

I have a column PAYMENT DATE as character data type.
Sample Data
09/10/2010
09/11/2010

We need to create a Date Prompt to query between the dates, Cognos by defaut returns a value like "Sep 10 2010" or " Sep 11 2010", If i pass the prompt its not working in the expected way.

I tried changing the data-type to SHORT VALUE, Can you please throw some Inputs

PS- The data source is SAP BW as no local functions are supported

Thanks
Anand

Title: Re: Date Format in SAP BW
Post by: gshilpa24 on 20 Sep 2010 04:26:42 AM

Hi,
You cannot use to_date or to_char function in yr query ?

Title: Re: Date Format in SAP BW
Post by: anandapr on 20 Sep 2010 10:59:19 AM

Yes Shilpa i agree as SAP BW use OLAP functions only, we cannot use relational functions like to Cast, etc..
is there any other inputs.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: anandapr on 19 Sep 2010 06:36:51 PM