INTEGRATED PLANNING

[Former Member]

Hi Experts,

We are currently undergoing planning phase in project,can anyone suggest either i should use HANA optimized real time infocube or Direct update DSO in integrated Planning.

Thanks in Advance ,

Vineet.

[former_member363885 · Accepted solution]

hi vineeth,

both is having some advantages and disadvantages.it depends on your need.

some advantages using Info Cube compared to Direct Update DSO are as follows :

- WHM integration: a planning enabled DSO is a 'direct write' DSO, i.e. one cannot use WHM methods to load data; an InfoCube has full WHM integration

- an InfoCube can have audit dimensions, a DSO not

In addition InfoCubes are build around 'delta' delta records, i.e. InfoCubes are insert only, delta records are saved, OLAP cache can get delta updates; one has the technical infrastructure of requests.

A DSO has a key, this means one can only write records will all key fields known (insert, update, delete); this is more time consuming.

The following are some of the advantages of using Direct Update DSO compared to Real time info cube:

-non-cummulative key figures can be used

-planning of no aggregation key figures (NO2) is possible

-The option 'Characteristic as Key Figure' allows planning of short texts, ...

hope this information will help you

[dmitri_marinin]

Hi Vineet,

What version of BW are you going to deploy? If BW 7.4 or lower you can't use Advanced DSO for planning. If BW 7.5: I suppose you should use Advanced DSO for planning (http://scn.sap.com/docs/DOC-67635).

Regards,

Dmitry.

[Former Member]

Hi Dimitry,

Actually version is BW 7.4 , but i want to use either Direct update DSO or HANA optimized Real time infocube..suggest upon this.

Thanks in Advance,

Vineet

[soundra_vel]

Hi Vineet,

It depends upon your existing flow for Actuals. If your actuals infoprovider is DSO based, better go with Direct update DSO, otherwise go for Infocube.

From BW 7.5 Edition for Hana there is no cube, everything will be based on Advanced DSO. You won't face issues while during upgrade point of view also.