cancel
Showing results for 
Search instead for 
Did you mean: 

Error in Infocube Data

Former Member
0 Kudos

Hi Gurus,

I am trying to see data in a cube in one field. It should show date but it is showing some figure.

Any idea why its happening and how can I fix that?

Regards

Accepted Solutions (1)

Accepted Solutions (1)

dennis_scoville4
Active Contributor
0 Kudos

Work backward from the InfoCube to the PSA and find out if the data is coming with that value into the PSA via the extractor. Once you find the source, you can have the business correct the data at the source or create a routine to cleanse the data. It would behoove you to have the data corrected at the source, because not only will it resolve your issue, your end customers will not be able to transact on that record if the data isn't in the prescribed format.

Former Member
0 Kudos

Hi Dennis,

Data is correct in PSA. So, as per your suggestion I need a routine to correct the data??

Yes or No?

If yes, where can I get the sample code for that?

Regards

dennis_scoville4
Active Contributor
0 Kudos

If the data in the PSA is truly date data and not some random figure as you have in your InfoCube, you should analyze where it's getting transformed instead of creating a routine to cleanse it. Wherever it's getting transformed from date data to figures should be changed to a straight mapping.

Former Member
0 Kudos

Thanks

Appreciate.

Answers (0)