Generic DataSource with "opening balance" option

[Former Member]

Hi!

I am trying to create a generic datasource for loading a Non cumulative Infocube.

As far as I know, I need to select "opening balance" field in this datasource to enable initial loading of data to the InfoCube.

But I find that "opening balance" is not activated ( i.e. I cannot select it) for my generic DataSource.

Please tell me, how can i create Generic DataSource with "opening balance" option?

Thanks

Pradeep

[Former Member · Accepted solution]

Pradeep,

You can not set this for a generic datasource. You must either create a flatfile, UD or DB connect datasource. You can get around the systematic restriction by updating roosource table for your data source and setting field stockupd = 'X' for your generic datasource.

Regards,

Dae Jin

[Former Member · Accepted solution]

Hi Dae

Thanks for your reply.

I have created a new flat file based Data source for initial loading.

Do I need to create the transformation and DTP for data target ( i.e non cumulative InfoCube) in normal way... I mean, is there any special setting for initial loading of opening balance?

cheers

Pradeep

[Former Member · Accepted solution]

Once you've created a transformation from your datasource to Cube, the DTP will give you an option in Extract Mode "Initial Non-Cumulative for Non-Cumulative Values" in the "Extraction" tab. If you select this and execute the DTP, the records will be loaded and the marker set with those values.

Regards,

Dae Jin

[Former Member · Accepted solution]

Thanks! Your replies were very useful in solving my problem.