Query is not picking up right data from the cube

[Former Member]

Hi Bi expert,

I added one infoobject (0cust_group) on the cube and when I display data through ‘manage’ option on RSA1 transaction, I can see that the infoobject nicely populated. But when running query, it’s coming under ‘Not assigned customer group (s)’. Could you please help me on this matter? I have activated cube and update rule and even generated the query using transaction ‘RSRT’.

Thanks for your help.

[Former Member]

Run hierarchy/attribute change run

Go to transaction RSA1 -> Header menu -> Tools -> Apply Hierarchy attribute/change Press infoobject lise -> Select your infoobject -> Press Execute-> After the change run get finished execute your query again

[Former Member]

How do you fill the customer group char in your rules?

1 - using master data of customer or 2 -datasource sending it from R3?

case 1:

check that 0customer attributes are filled and active ( objvers = A)

case 2: check it in r3 using RSA3 transaction, to see if it is extracting it?

derya

[Former Member]

it’s coming under ‘Not assigned customer group (s)’

Do you customer group hierarchy in the report ?

Or

Are the values being displayed as " # "

[Former Member]

Hi Jr,

Values displayed under 'Not assigned customer group (s)’ not as #. I Reloaded cube and ran the report afterwards. But it's not happening at all. Please suggest me.

Thanks.

[Former Member]

This should not happen. The best way to nail down this would be to use the same selection condition for the query output as you did for "Manage". Since 0cust_group was added later, it is quite possible that you are looking into the initial records. If the option permit,

try a reload OR

close the BEx application, restart and run the query