How to manage master data correctly direct to DB of Financial Consolidation?

[igor_klushnev]

Hello!

We have installed SAP BO Financial Consolidation 10.

There is a dimension called CONTRACT with db table ct_0100_contract.

When I insert new rows with the SQL INSERT operator to this table They don't appear in Financial Consolidation thick client.

All of the following fields are filled as if I would insert the row manually in Financial Consolidation thick client.

ID - filled by autoincrement

OWNER_SITE = -1

OWNER_WORKGROUP_ID = 0

ACCESS_MODE = 0

CREATION_DATE = UPDATE_DATE = current system datetime

AUTHOR_ID = UPDATE_AUTHOR_ID = id of user ADMIN

What's wrong?

[igor_klushnev]

That's great!

Many Thanks,

Igor

[Marc_Kuipers]

Hello Igor,

If you insert directly into the reference table (via SQL), you will need to restart the datasource. This forces the application to read the data from the DB

Thanks

Marc

[igor_klushnev]

Hello Marc!

Is it possible to restart the datasource via web service or system (OS) command? I use DataServices to load master data.

Thanks a lot

Igor

[Marc_Kuipers]

Hello Igor,

Yes, there are scripts available for this.

In folder C:\Program Files\SAP BusinessObjects\Financial Consolidation you will find:

- CtStartDataSource.vbe

- CtStopDataSource.vbe

For example, to stop the datasource (forced)

CtStopDataSource.vbe /BrokerComputerName:<server> /DataSourceName:<my_datasource> /ForceUninit:True

You can find examples of how to use these scripts in the SAP BusinessObjects Financial Consolidation Administrator's Guide, which can be found on http://help.sap.com

Best regards,

Marc