Forum Discussion
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...
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
We replicate directly from ECC into SQL Server. We do not touch BW. By having all theSAP tables in SQL server, you can create SQL scripts which will create any required data, which you can feed into Tabular, or Power BI.
A variable is another field, from a table, that you use to filter: that's pretty straighforward in SQL, using the WHERE clause.
The replication is in real-time, so when a change is made in ECC, it is reflected in SQL server within seconds.