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

Number Range Filter

Hello,

We have a requirement that sales orders starting with 25 ( 25xxxxx) and 28 ( 28xxxx) should be update only in Infocube rest other series to be ignored. Or if this can achieved at Query Level ?

Please help,

Regards,

VM

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • Best Answer
    Posted on May 12, 2015 at 05:30 PM

    Hi Mv,

    Business requirement may take deadly turn at any of time, today they are asking you sales order start with 25* and 28*, in future they may ask you 21* and 22* etc that time its very difficult job to extract data again to cube start with 21 and 22 ( and this is very bad data modeling ), so you always look at future requirement so please extract all sales order into cube and restrict at report level as per requirement.

    As suggested by the Raman 3rd point restricting at BEx level.

    OR


    Create one more characteristics for same cube and write routine and fill 25, 28 , 21, 22 based on sales order number, you can create direct variable to restrict data at BEx level or filter directly at designer level.


    OR

    You can crate customer for newly created infoobject based country/user/region etc fill the variable like 25 or 28 etcc.



    Please check all possibility before proceeding.

    Thank you,

    Nanda

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 12, 2015 at 12:43 PM

    Hi,

    Assuming as you need sales order which start with 25 and 28 series.

    Sales order number length is 10 digits

    3 Ways you can achieve you requirement.

    1. at Info pack level - Here we can use selections on sales order - 2500000000 - 2599999999 , 28000000 - 2899999999

    2. at DTP level you can maintain filter routine on sales order by using proper series numbers.

    3. at bex level you can restrctic sales orders by using select options like

    sales order -->rigth click-->restrict--> you can give ranges like between 2500000000- 2599999999.

    similurly you can gave between range 2800000000 to 2899999999.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 15, 2015 at 10:08 AM

    Thanks a lot everyone,

    I applied global filter for values 250000 to 289999 covering entire range at BEx level. It worked and as suggested by all experts here, futureproof.

    Regards,

    m

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 13, 2015 at 03:41 AM

    I fully agree with Nanda that it is best to avoid this kind of hardcoded filtering of Sales Orders. It's better to achieve this in the reporting layer. Even if the current user only want 25* and 28* orders tomorrow he could come up with a requirement to also include say 30* orders.

    Especially, this scenario looks like it could be related to a document type (or some other characteristic on the Sales Order). Usually in the source system, they have a way of numbering the orders so the numbers stand for a particular doc type. For instance, 25* orders could be doc type A while 28* orders could be doc type B.

    Please find out if such a scenario exists for your requirement - because if it does, the whole problem becomes much easier and all you need to do is to filter based on the doc type.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 12, 2015 at 12:26 PM

    If the infocube is used by you, better set the filter in DTP with the sales order number range

    25000000 to 28000000

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 12, 2015 at 03:11 PM

    Hi MV,

    Just filter the SALES ORDER object in your DTP with these values:

    2500000 - 2599999

    2800000 - 2899999

    Regards,

    Loed

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 12, 2015 at 05:30 PM

    Hi Mv,

    Business requirement may take deadly turn at any of time, today they are asking you sales order start with 25* and 28*, in future they may ask you 21* and 22* etc that time its very difficult job to extract data again to cube start with 21 and 22 ( and this is very bad data modeling ), so you always look at future requirement so please extract all sales order into cube and restrict at report level as per requirement.

    As suggested by the Raman 3rd point restricting at BEx level.

    OR


    Create one more characteristics for same cube and write routine and fill 25, 28 , 21, 22 based on sales order number, you can create direct variable to restrict data at BEx level or filter directly at designer level.


    OR

    You can crate customer for newly created infoobject based country/user/region etc fill the variable like 25 or 28 etcc.



    Please check all possibility before proceeding.

    Thank you,

    Nanda

    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.