Looking for some expertise. Does BO have the capability to allow a user to extract certain data facts. Then, once these data are extracted, enter in additional data which can then be used in calculations. And then can the results of the newly entered data and newly calculated data be written back to the source. Example would be as follows:
Pull Data A & B from Datawarehouse
manually enter values C and calculate variance between A and C, resulting in value D
Then write values C & D back to the data source using BO.
My understanding is that BO can pull data from the DW but cannot write to the DW.
You could actually do what you want do using VBA to write a macro to accomplish this. BusObj by nature is a 'read-only" tool but VBA is not. I have successfully written data to a database table using VBA macros.
Looking for some expertise. Does BO have the capability to allow a user to extract certain data facts. Then, once these data are extracted, enter in additional data which can then be used in calculations. And then can the results of the newly entered data and newly calculated data be written back to the source. Example would be as follows:
Pull Data A & B from Datawarehouse
manually enter values C and calculate variance between A and C, resulting in value D
Then write values C & D back to the data source using BO.
My understanding is that BO can pull data from the DW but cannot write to the DW.
Thank-you. I would be interested in learning more about how you did this, however my knowledge of VBA is zero. If you have time and or inclination, I’d like to see how you managed this for my future reference.
Hello Andreas,
Bus Obj can indeed write to a database, Oracle for instance. A user is not able to do it, but a Designer has the capability to write any report back to the db as an Oracle table. Maybe this will help you.
Roger Poole
rpoole@nswc.navy.mil
Hello BO World,
Looking for some expertise. Does BO have the capability to allow a user to extract certain data facts. Then, once these data are extracted, enter in additional data which can then be used in calculations. And then can the results of the newly entered data and newly calculated data be written back to the source. Example would be as follows:
Pull Data A & B from Datawarehouse
manually enter values C and calculate variance between A and C, resulting in value D
Then write values C & D back to the data source using BO.
My understanding is that BO can pull data from the DW but cannot write to the DW.
Have you created a report like this? Can you send an example of the report and also do we need to write some special code that will let us(designer) write to the database?
Thanks for your help
Harpreet
Hello Andreas,
Bus Obj can indeed write to a database, Oracle for instance. A user is not able to do it, but a Designer has the capability to write any report back to the db as an Oracle table. Maybe this will help you.
Roger,
I am interested in this “writing to a table on the dB” issue. Where in designer would I set the option to have the report write to a table on the dB? Can you have the user submit the report via BO and then results not return to the user, but rather write these results to a table on the dB?
Thanks
Kathy Vazquez
Hello Andreas,
Bus Obj can indeed write to a database, Oracle for instance. A user is not able to do it, but a Designer has the capability to write any report back to the db as an Oracle table. Maybe this will help you.
Roger Poole
rpoole@nswc.navy.mil
Hello BO World,
Looking for some expertise. Does BO have the capability to allow a user to extract certain data facts. Then, once these data are extracted, enter in additional data which can then be used in calculations. And then can the results of the newly entered data and newly calculated data be written back to the source. Example would be as follows:
Pull Data A & B from Datawarehouse
manually enter values C and calculate variance between A and C, resulting in value D
Then write values C & D back to the data source using BO.
My understanding is that BO can pull data from the DW but cannot write to the DW.
The ability to export the results of a query to a database is core functionality that is granted/revoked via the Supervisor Module of BusObj. The Designer or Supervisor can define the connection to the target database account and the user can select connections from the Data Manager. This is the functionality that exists in V4.x, as our migration to V5 is not planned to start until April 2000, I cannot verify if V5 operates in the same manner. Hopefully one of the BusObj community on this list will be able to confirm V5 retains this functionality.
In theory, yes, however this scenario would be able to be handled by the core functionality of the Business Objects User module. In the case of an ORACLE ‘back-end’, I would suggest using a free-hand SQL script based on the ORACLE command ‘CREATE TABLE AS subquery’ where the subquery is SQL that the Business Objects Data provider would have created.
I hope this is assistance to you.
PJ
From: Vazquez, Kathy A [SMTP:kathy.vazquez@EDS.COM]
Paul,
Can a user direct the results to the database rather than returning the results to the PC and then exporting?
Maybe I don’t understand the question, but couldn’t you go into View Data – Export, click on Export to RDBMS, then choose a connection with write privileges? I’ve tried this on both UDB and Oracle databases and was surprised at how easily it is to write the results of a query to the database. This works in BO 4.1.3, 4.1.5 and looks like it’ll work in 5.0.1. Hope this helps.
Deborah,
My main concern is large datasets being returned to the desktop. I would like to direct results to the warehouse rather than the user. Any ideas? Thanks.
Thanks Paul,
This is more of a step-by-step version of what Paul is saying below. You can export the results of a standard Bus Obj report to an Oracle (and other DBMSs I assume) table. (Harpreet, any of your reports will work.)
After running the report, select Data.View then click the [Export] button. One of the choices is to Export to RDBMS. Click the radio button, then select which connection you want to use. Click [Ok] and you have done it.
If the Export to RDBMS is greyed out, and won’t let you select it, that means you need to define a personal or shared connection to the RDBMS you want to export to, with Write capability. Use Designer or Supervisor for this.
Roger Poole
rpoole@nswc.navy.mil
Roger & Andreas,
The ability to export the results of a query to a database is core functionality that is granted/revoked via the Supervisor Module of BusObj. The Designer or Supervisor can define the connection to the target database account and the user can select connections from the Data Manager. This is the functionality that exists in V4.x, as our migration to V5 is not planned to start until April 2000, I cannot verify if V5 operates in the same manner. Hopefully one of the BusObj community on this list will be able to confirm V5 retains this functionality.