on 07-21-2009 7:26 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.