Data write-back with businessobjects?

general discussion
1

Hello,

is it possible to write-back planing data in a database from business objects? If there is a way to make this, how can I do it?

Thanks
Andreas

sban (BOB member since 2003-12-11)

2

Please, start with this “old” but still true thread.

Andreas :de: (BOB member since 2002-06-20)

3

I’d forgotten about that old thread…

In short, the answer is NO (thankfully). Even with VB coding, it would be very difficult. You’re VB program would use BO’s API to get data, but you be completely independent of BO for writing to the database.

Steve Krandel :us: (BOB member since 2002-06-25)

4

Something changed after 9 years?

bmvrus (BOB member since 2011-05-08)

5

I don’t think so.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

6

Sort of. Not so much with the WebI world, but with Xcelsius you can writeback from a dashboard with add-on components. I have also heard of people doing similar things with Crystal, but I’m not sure why nor have I seen it in real life.

edurda :us: (BOB member since 2005-09-08)

7

You can write-back with xcelsius without any components - if you can code it yourself. I can connect to a database, open it and run SQL over it through xcelsius, so I could probably write back to the database too. Can’t imagine any scenario in which I might want to though…

Debbie

Debbie :uk: (BOB member since 2005-03-01)

8

I’d imagine a stored procedure query would be able to do both - build an underlying table and push a summary of what it has written to the end user.

9

Debbie,

I know that we’ve seen people use the writeback functionality for two main reasons. The first, to send back what-if scenarios for future review and the second as a simple data entry for explaining why values are what they are. For instance, user A opens the dashboard, sees an odd value, makes a few phone calls and when she knows why the value is odd, puts a brief explaination directly into the dashboard so why user B opens it, she knows why the value is what it is.

In any case, we’ve had a lot of success with writeback and seen some really cool and valuable uses of it.

edurda :us: (BOB member since 2005-09-08)