Strange Values in Characteristic selection screen

[Former Member]

hello,

We have a situation here where there are some strange values appearing in the selection screen for a particular characteristic. e.g. for Business Area we expect to see only "A" and "K". But we have a wide range of values showing up like 0001 and 300 etc.

I cannot see how these values got into the selections.

- I checked the infoobject and there is no master data load for this infoobject.

- There is a text load which contains text for 4 values (the ones we expect to see).

- I checked each of cube that the infobject is used in an used one of the invalid values as a restriction to see if I got any results back, but there was no luck here.

I thought perhaps the values came from the transaction data loads (seeing as there is no master data load for it). Is this a correct assumption? or is there any other explanation for these values being there.

Thanks for any help you can give.

Thanks,

Allan

[Former Member]

F4 can accept value only from masterdata or from infoprovider (or from some custom exit...)

Bye,

Roberto

[Former Member]

Thanks Eugene, Roberto.

That is what I assumed. Is there any other way to trace where these values came from?

I tried looking at the data in the cubes and restricting by the value, but to no success.

Thanks,

Allan

[Former Member]

So, do you see the strange data in the Business area master data?

How do you load your data, from flat file or..?

Best regards,

Eugene

[Former Member]

It's from SAP R/3

regards,

Allan

[Former Member]

Allan,

You didn't answer the question: do you see the strange data in the master data of the IO?

And what you meant under "I tried looking at the data in the cubes and restricting by the value, but to no success."?

You cannot see the strange data in the cube? Can you just look at Business area data in the cube without any data restriction during selection?

Best regards,

Eugene

[Former Member]

Eugene,

My apologies. here's the answers.

do you see the strange data in the master data of the IO?

I am not able to see tha master data in the IO. In the config of the IO, the "With Master Data" option is unchecked.

The IO is used in a number of cubes. So in order to try and see if the values came from transaction data, I went to each of those cubes and ran a quick check of the infocube contents. I focused the search on one of the "incorrect" values. (The volume of data in the cubes is enormous). I did not get any results from this search.

can you suggest anything more I can do?

best regards,

Allan

[Former Member]

Ok, Allan.

Then try the other way. In BEx try to design a query which will include Business area (restrict it to a one strange value), date (or another time char if you don't have date), some other chars on your choise.

Then the query results use as a filter when you will look again at the cubes content. Let's know if you see your strange values then. If yes, try to figure out what is common in that strange records and how they differ from the normal ones.

Best regards,

Eugene

[Former Member]

Hi Allan,

If you checked just only requests for master data load then look at the master data of this IO. The strange values could come from transactional data load.

Best regards,

Eugene