Identifying source of entry in a cube

[Former Member]

Hi,

We have this cube with a characteristic, Color Indicator, X. When I did run listcube to see contents of Cube there was only one number ($59,000.30) without the indicator, X.

Incidentally, the users are complaining a GL entry of $59,000.30 on the R3 is not showing up on their BEx reports.

I verified the entry on the R3 side and it does not appear that the “X” concept is in R3.

What is the best way to at least assign the letter “X” to this number for test purpose to see if it will show up in the BEx report?

I suspected some type of mapping, where can I possible see this?

Also, how do I see the data exactly as it came from R3 before all the rules/mappings in BW came into effect?

I will appreciate if for any guide you give, you provide the steps to see it on BW.

Thanks

[Private_Member_9643 · Accepted solution]

Cross check with which R/3 field ur characterstic is mapped, and check data for that field in PSA.

[Former Member · Accepted solution]

On Kamaljeet's Response:

I am familiar with going into PSA when I load flat file data to cubes/ODS. But in this case the data was loaded through PC? Can you provide me with steps to identify the data in the PSA of a particular posting period?

(What if it turns out that the PSA has been deleted? How then will I approach my original issue?)

Thanks.

[udayabhanupattabhiram_cha]

Hi:

To look at PSA, first you have to determine in whch request you may see the required values. Then, go to Manage Cube, on the proper request, click on the Monitor.

From there, on the menu, IF you see PSA Icon, click on it. if there is PSA data, it will show up for selection.

Chamarthy

[former_member188975]

Hi Amanda,

Also is it corect that only those with X should show in the report...can you also check the query deifnition to see what is set up there...

Also chekc the logic behind why a records would have the X indicator....

[Former Member]

On Gupta's Response:

You are right, the query definition includes the indicator "X" and as such, they are the records we are looking to see in the report.

Thanks.

[Former Member]

Where are you deriving the X value from? Is the color indicator coming from R/3 or you guys deriving the value thru some routine in BI.

And what do u mean by <b>"I verified the entry on the R3 side and it does not appear that the “X” concept is in R3."</b>

[Former Member]

On Voodi's reponse:

That is what as a newbie, I am trying to figure out.

I have seen a screenshot of the transaction in R3 and there was nothing about "X" the indicator.

How do I know if it is being derived through some routine on BW or R3?

Thanks.

[Private_Member_9643]

->How do I know if it is being derived through some routine on BW or R3?

Just check with which field ur Indicator object is mapped in update rules, and check if there is any routine on that Object. Also check if start routine is making use of that infoobject?

[Former Member]

Check the way KJ suggested. If its not coming from ur source system, it is being derived within BI. And i suspect X should be a master data attribute of some IO (mostly 0MATERIAL). If thats the case, then the material in question doesnt have a value for color indicator in your master data.

[Former Member]

Reponse on second Voodi's Response:

".. If thats the case, then the material in question doesnt have a value for color indicator in your master data...."

This is an interesting point to note but the same data appeared in the report for all periods except the current period, Period 14. I thought this will give you the over all picture to rethinik through your previous comment.

Than ks.