Skip to Content
author's profile photo Former Member
Former Member

Wildcards in WEBI table

Hi all,

I am building a WEBI report based on a BEx query in BI 4.0 SP13.

In the report, I want to filter sales organizations using wildcards.E.g I want to display sales organizations starting with 500(like 500*). But I need to filter this in

the report, not in the selection screen.In addition, I can not handle this in BEx because there are many webi reports on the BEx query.

So I tried to add a filter to the table in the report using “equal to “ operator.But In the filter of the table, I can not write 500*, because it forces me to select sales orgs which already exist in the report, not allowed to write 500* manuelly. In addition, using between or in list operator does not satisfy the requierement, because it forces me to select existing sales orgs in the report and there might be missing sales orgs which are not available in the report at that time.

Therefore, I tried to create a dimension variable called var_salesOrg. and var_salesOrg= salesorg where (salesorg between("5000000";"6000000")). It works fine without the measure.When I add the measure to the table, it shows #unavailable.

Any ideas on how to handle this requierement?

Regards

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Apr 26, 2012 at 03:19 PM

    I have a couple of suggestions...

    1. Try creating a report filter where salesorg is between 5000000 and 6000000.
    2. Create a variable whose formula is "=substr([salesorg]; 1; 3)" and call it something like salesorg_prefix. Put that variable on your report as a new column and hide it. Then create a report filter where your new salesorg_prefix variable is equal to 500.

    I hope one of these works for you, but it would certainly be much nicer to be able to use a wildcard or to have a "Like" operator.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 26, 2012 at 08:43 PM

    I don't think you could handle 'like' type of filtering in BEx query even if you created report specific BEx query.

    Suggestion #2 from Noel looks promising except that wildcard specific data filtering would occur within WEBI ad potentially could cause massive data volums sent from SAP BW to BO server before 'like' type filter is applied.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2012 at 09:53 PM

    HI,

    Select the Table

    Click on Analysis

    Click Filter - add filter

    select block1 ( if you have only one block) - depends

    add filter

    seelct the dimension (sales organization)

    select between

    start value = 5000000

    end value = 600000

    click on ok

    If this would not solve your prob. please try to attach screen shot. It may help people for prompt response.

    Hope this helps.

    Thanks,

    Rajendra

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.