Hi,
Due a bunch of limitations on business date/time fonction on a SAP BW datasource under reportnet(it is an olap and not rdbms datasources...), we would like to pass all filter values via some parameter/prompt.(we tried several alternative before considering doing this via SDK, such as calculation, parameter map etc.. but all of that does not work for a BW datasource under reportnet).
therefore, We have created a table where all the prompt values are stored and updated daily.
can someone provide a commented exemple of java code/class in order at the execution of the report that the parameter values are obtained from the sql database and passed to the report before running on the SAP BW cube.
There is an exemple in the SDK but it requires manual user input, and would like all of this to run in the background. thanks david
Due a bunch of limitations on business date/time fonction on a SAP BW datasource under reportnet(it is an olap and not rdbms datasources...), we would like to pass all filter values via some parameter/prompt.(we tried several alternative before considering doing this via SDK, such as calculation, parameter map etc.. but all of that does not work for a BW datasource under reportnet).
therefore, We have created a table where all the prompt values are stored and updated daily.
can someone provide a commented exemple of java code/class in order at the execution of the report that the parameter values are obtained from the sql database and passed to the report before running on the SAP BW cube.
There is an exemple in the SDK but it requires manual user input, and would like all of this to run in the background. thanks david