Forum Discussion

daanp's avatar
daanp
Frequent Visitor
9 years ago
Solved

SAP BW variable input not working

When i try to load a query from BW with optional variables i can't seem to enter any values:       It seems like everything i type in the input fiels gives me the 'Enter a List value' error...
  • daanp's avatar
    daanp
    9 years ago

    Hrmm i figured it out,

     

    If i put the variable fields in the query itself (the fields that are loaded). then a dropdown box appears

TORNALLY's avatar
TORNALLY
Helper I
9 years ago

daanp, there's an easier way - take a look at Simplement's Data Liberator.  This platform surfaces any SAP table directly into SQL Server, ready for Power BI:

 

             www.simplement.us

 

The Liberator provides any table in real time, including any and all Master Data, directly from the database, which would cover any variable you need.

 

   Mike McNally

[email protected]

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi TORNALLY,

     

       Any you tube video link for demo showing data libretaor connecting to sap bw cubes & fetchng data from there to sql tables. It is also mentioned that data libretaor uses sql server 2016 as database. I believe youmust be fetching data from cubes to sql tables. Is it the case??

      

    Regards,

    Hemant