Read and Writing from/to data source

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.

Any takers?

Andreas
Beltsville, MD


Listserv Archives (BOB member since 2002-06-25)

Andreas

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.

Mike McErlain

At 04:52 PM 3/3/2000 -0500, AFleckenstein@MICROS.COM wrote:

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.

Any takers?

Andreas
Beltsville, MD

OR search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’ Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’


Listserv Archives (BOB member since 2002-06-25)

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.

Thanks,

Andreas


Listserv Archives (BOB member since 2002-06-25)

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.

Any takers?

Andreas
Beltsville, MD


Listserv Archives (BOB member since 2002-06-25)

Hello Roger,

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 Poole
rpoole@nswc.navy.mil


Listserv Archives (BOB member since 2002-06-25)

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.

Any takers?

Andreas
Beltsville, MD


Listserv Archives (BOB member since 2002-06-25)

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.

Paul Jarrett
Gamar Limited
United Kingdom


Listserv Archives (BOB member since 2002-06-25)

Paul,
Can a user direct the results to the database rather than returning the results to the PC and then exporting?

Thanks

Kathy Vazquez


Listserv Archives (BOB member since 2002-06-25)

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?

-L’


Listserv Archives (BOB member since 2002-06-25)

Kathy,

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.

Debbie


Listserv Archives (BOB member since 2002-06-25)

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.

Kathy Vazquez


Listserv Archives (BOB member since 2002-06-25)

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.

Paul Jarrett
Gamar Limited
United Kingdom


Listserv Archives (BOB member since 2002-06-25)

Paul Jarrett,
Are you referring to a VBA module? Do you have any examples?

Thanks
Kathy Vazquez


Listserv Archives (BOB member since 2002-06-25)