Skip to Content
avatar image
Former Member

characteristic Filter issue in BEX

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 26, 2015 at 09:37 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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