cancel
Showing results for 
Search instead for 
Did you mean: 

what is the format of 0calmonth data in flat file

Former Member
0 Kudos

Hi,

What is the format for 0calmonth field data in flatfile to load data in to cube.

Thanks .

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Rohith,

First of all, check your datasource defintion, if field format is marked external and there is conversion PERI6, you can use the format like 12.2009. but, if it is internal without any conversion, you shoukd use format as 200912(YYYYMM).

Regards,

Harpal

Answers (1)

Answers (1)

Former Member
0 Kudos

The format is yyyymm (you can change it if you adjust the conversion accordingly.

Kind regards,

Alex

Former Member
0 Kudos

Hi,

Thanks for the answer, but when iam trying to maintain the data in flat file it is automatically converting to Jan 15, june18 like that how i need to write & maintina the data for 0calmonth in flat file.

Former Member
0 Kudos

How do you mean 'converted to Jan 15'? Do you mean when you open it in Excel or something? Or do you have a flatfile with the actual values 'Jan 15'?

Kind regards,

Alex

Former Member
0 Kudos

Hi Alex,

Thanks for your response. Iam providing 0calmonth field data as 200904 ,200905 and further then at the time of loading it is throughing error like

Value '090420 ' of characteristic 0CALMONTH is not plausible BRAIN 27

Please suggest me.

Thanks.