Selection issue in RKF in Query

[Former Member]

I need to do a restriction in a RKF where I need to select only those materials stsrting with 'C' & 'G' & 'J'.

Means I need to  get values of a keyfigure only for the materials starting with 'C' & 'G' & 'J'. How can I do this??

If I do the selection as displayed in the screenshot as below, I dont get the values !

how can I achieve this?? Is there anyother way??

Rgds,

Vandana.

[Former Member]

Hi,

see whether that particular compounding object holds the characteristic values you have mentioned in master data if not then the selection  would not  work.

[former_member185132]

Hi Vandana,

This should work. If it is not working, can you please explain what output you are getting?

Also check by applying the same criteria in the MP; if the results match then the query is ok.

Regards,

Suhas

[Former Member]

No Suhas, Its not working, I get no values for the keyfig when i do selections as shown in the screenshot above, even though the values exist for the selections in the cube.

The results dont match, in the cube i can see values for the above selection, but in the report i cant get the values. however if i remove the selections & run the report the results match with the cube data.

Really surprised, but do u agree that the above selections is perfectly valid??

Rgds,

Vandana.

[former_member185132]

Is this (Batch Characteristic) a compounded field?

Also, please try to run the query (without the C*, G* etc restrictions) in Analyzer. Then in the Analyzer output, try to add the C*, G* restrictions and see if you still have problems.

[Former Member]

Yes Suhas its a batch char & compounded with 0material & 0Plant.

wat can be done in this case?

Rgds

[former_member185132]

Well, wildcards (like *) won't work if it is compounded. There are a couple of workarounds:

1. Do you know the values of both the compounded chars (material and plant)? If so, then restrict both of them also and try.

2. If not, then you may need to change the data model slightly. Add a new nav attribute to Batch - the values in this attrib will be the same as the batch itself. The reason for doing this is that the nav attribute will not have the compounding, and so you can restrict based on the nav attrib.

Regards,

Suhas

[Former Member]

Hi,

Try and create a characteristic with length 1 in your dataprovider .

If plant is the beginning then leave that much field space and trim the initial of material and load the data .

Then try to restrict the same in query .This should work.

Regards,

Akshay