Skip to Content
avatar image
Former Member

Importing values from excel to variable restriction

Hi

We have created a query in BI7.0 which should allow the front end user to insert massive amounts of numbers from excell in the variable restriction.

In our old BW 3.5 we where able to simply copy paste from excell and into the "select values" screen -is this possible in BI7.0 and if so how do we do it?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Oct 03, 2008 at 10:05 AM

    There is no solution to this - SAP have said they will re-introduce this functionality, but they havent said when (as far as I am aware).

    However, we have developed a workaround (for Web reports anyway), let me know if you are interested.

    Patrick

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear Patrick,

      I'm also very interested in the functionality of selecting a mass of filter values within web.

      Thanks in advance.

      Best Regards,

      Daniel

  • avatar image
    Former Member
    Oct 03, 2008 at 10:20 AM

    Hi,

    Try this one.

    In the variable input screen goto-> show and select single values--> copy in Direct input.

    thanks,

    Ashok

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 03, 2008 at 10:28 AM

    Just to clarify, Xavier, are you working in v7 BEx or Web?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 05, 2008 at 05:59 PM

    Hello Patrick

    can you explain your workaround you have made?

    I am interested in your solution as we have the same need.

    Bye Markus

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 20, 2008 at 11:58 AM

    New sap version has implemented a solution for this incovineance. Thx for all input.

    Add comment
    10|10000 characters needed characters exceeded