bsp question

[Former Member]

Here is what I am trying to do. I have a query based on a multiprovider which has 3 cubes. When the user executes the query and sees the result, he should have an option to change one of the columns. This should be updated back into an ODS in BW. Is this possible using BSP? Is there an easier approach? I am on 3.5. Would this be possible in 2004s without having to use BSP?

[Former Member · Accepted solution]

Is this

> possible using BSP?

You can do a javascript which calls an RFC function that reads the modified data and updates the ODS. I would think you can do something similar using BSP if you want, however you would still need some jscript to get there.

Is there an easier approach?

You can do it entirely in BSP where the user gets to see all the data (fetched using a query or some other such API or MDX) and update it. Not sure if it would be easier.

Would this be possible in 2004s without

having to use BSP?

You will need to use something (some code); it will not be possible without code. At some point in time you can use IP to write to a txnl ODS but not in current versions, and certainly never to a standard ODS.