characteristic Filter issue in BEX

[Former Member]

Hi All

I am facing a issue while filtering the data in BEX report . I am creating a inventory report on 0IC_C03 infocube . In filter tab (characteristic Restriction ) I am using calday filter , for which I am using my input variable.

Now I am using MAP price as a characteristic (due to some limitation) in my cube 0IC_C03 . Field is of type CHAR. so I am using the field in row in my report .

Now my problem is that my filter is applied correctly on all my ketfigures and all of my stock values is correct in report .But since I am using MAP in row it is not restricting the data based on input variable.

I have few question:-

1. Is it the global filter in BEX report works only for the keyfigures and not for the characteristic values.

2. is it a way I am restrict my characteristic field based on calday (input variable). I tried to create a replacement path variable but it's not working.

Request you all to kindly help .

Regards,

Jagriti Jha

[karthik_vasudevan]

Hi Jagriti

Though you use MAP as characteristic, there is no change the way query restriction works.

This said, the characteristic value corresponding to MAP which is out of restriction should not appear in the report.

Lets us take a simple scenario. If you have a multiprovider and if you restrict the query to one infoprovider, you cant see any characteristic values based on other infoproviders. So its obvious to a single infocube as well. There should be some other unseen problem here.

Why do you think your query is not restricting MAP values. Could you please run the report with one calday and display the report.

For the same cal day, check the respective data in infocube. Please provide some screenshots for better understanding.

Regards

Karthik

[Former Member]

Hi Karthik

Thanks for reply .

Here is below filter I am using in report .

Say for sample material data in cube . Here in cube last transaction in month 09.2015 is happened on 25.09.2015 and MAP is 31 there .

Data is report.

I am running this report until date 30.09.2015 . so the MAP in the report should be 31 , but in report it's taking the latest MAP which is 100.

Request you to kindly help , if I am missing anything .

Regards,

Jagriti Jha

[karthik_vasudevan]

Hi Jagirti

Could you please have your calday in free characteristics to check before we do any changes.

What is the input calday that you are giving in variable screen. If its a range variable, please one date, say 25.09.2015 alone and see how the result appears.

Regards

Karthik

[Former Member]

Hi Karthik

Thanks for the reply !

I am using calday range as selection variable. I tried giving one value as suggested , but still I am getting the latest MAP whish is 100 in sample report .

I added calday in my free characteristic as well , still the result is same.

I am really clueless as why the filter is not restricting the characteristic value .

It would be great if u can help.

Regards,

Jagriti Jha

[karthik_vasudevan]

Hi

The reason for adding 0calday in free characteristics to see which when you have it in rows before MAP. Drag it in rows and show the report output.

In your infocube, did you restrict your display data selections to the data you have given in the variable screen?

Please share all the screens.

Don't worry, we could get to the bottom of it and find a solution for sure. As we cant see your system, we have to ask lot of questions to understand the issue properly. So don't mind please.

Regards

Karthik

[Former Member]

Hi Karthik

I am not doing any filtration on my data in cube . I am using standard Transformation for 0IC_C03 cube.

Here I can see the 0calday is being calculated with 0Doc_date, posting date and movement type 561.

I tried using posting date in my report filter and ran the report with same selection . I am not getting any data in that case whereas my posting date and calday is same in report.

Is is because of inventory cube and non - cumulative keyfigures. But again with calday filter I am getting all my non - cumulative keyfigures correct and perfect , the only problem is with MAP which is characteristic in report.

Not sure how I should filter my data in report. Kindly help .

Regards,

Jagriti Jha

[karthik_vasudevan]

Hi

You don't have to filter anything in report. Do the following and post the screenshot here

1) Add 0calday in the rows of your report (I think u have done this already)

2) Execute the report with 25.09.2015 only

3) Once the report output has come, take a screenshot with all characteristics in rows along with MAP.

I just want to see what is the calday populated when your MAP is 100.

Regards

Karthik

[Former Member]

Hi Karthik

Here is the screen shot . Now I can see for few plants it's showing the correct value 31 also , but for rest it's incorrect.

REgards,

Jagriti Jha

[karthik_vasudevan]

Hi

Now, execute the report only with the material to narrow down.

Display the data in infocube only with that material and see which plant/storage loc are coming correct and which is not.

The ones which are not coming right should have some issues obviously. I see you have some conditions in your report. Is that something to do with the display

[Former Member]

Hi Karthik

I checked the data in cube . There nothing relevant I could get from there . I mean if I am running the report for 25.09.2015 it's showing two lines .. one with the correct MAP and one with the latest MAP.

I am using a condition in report to show material where stock qty is not zero, not sure if it affects the characteristic values.

I will try running the report after removing the my condition as well.

Any idea anything else I can do ?

regards,

Jagriti Jha

[Former Member]

Hi

I tried running without any condition in my report putting the filter on calday .

So it's picking all the MAP price present both 31 and 100 . So now I guess I can't get a my correct MAP ever if am I using the field as characteristic. I am using this field of type Chac string as NUMC not accept the decimal values.

I am really hopeless with my error.

Do I have to use the field as keyfigure only .

If I am using it as keyfigure it's fine only one case it fails when for a material in a plant say S101 , in one storage location movement happened in period 09 and in one doesn't . so as per logic in report for the storage location movement happened it picks the current MAP but for which it doesn't happen it picks the last valid movement MAP only Since I am using storage location in row in report.

Kindly suggest what should I do . shall I use as a keyfigure only or characteristic.

regards,

Jagriti Jha

[karthik_vasudevan]

Hi

It seems your condition filters out the expected value. So there is only two ways to try resolving your issue.

Remove the condition which I think you cannot do, as you have some other keyfigures need the condition

Or change MAP as a keyfigure which I should have asked at the first point on what was your issue. Make it as KF and try resolving that issue. I think this should be right approach

Regards

Karthik