Can we do IP query on Write optimized DSO for char planning
Hi,
It is not possible to do a Planning on DSO. You can only do Planning on Real Time InfoCube. That is what we will use in BPC as well.
Check the below link for more info.
http://help.sap.com/saphelp_nw70/helpdata/EN/43/1dfeff41130bd5e10000000a422035/content.htm
Regards,
Raghu
Hi,
You cannot do planning on top of DSO. One of the prerequisite for integrated planning is a 'Real Time Infocube'.
Kindly refer to the below links for more details on real time infocube,
[http://help.sap.com/SAPHELP_NW04s/helpdata/EN/43/6d6c14ac856fc9e10000000a1553f6/frameset.htm]
[http://forums.sdn.sap.com/thread.jspa?threadID=1058465&tstart=0]
And moreover the planning query should be created on an aggregation level created on your planning infoprovider (real time cube or a multiprovider containing atleast one real time cube),
[http://help.sap.com/saphelp_nw70/helpdata/EN/43/1c3c7031b70701e10000000a422035/frameset.htm]
Hopes this clears your doubt about real time infocube.
Regards,
Balajee
Hi,
since DSO Planning is already mentioned in the above document I can give this information about planned functionality (with the usual disclaimer that SAP may change the plan at any time):
- a new or empty direct update DSO can be flagged as 'planning enabled'
- as attribute fields of the DSO only key figures are allowed
'Write back' is planned to be possible via aggregation levels as usual, but (maybe via disaggregation) on the 'lowest level' and via 'insert' or 'update' (i.e. there are no delta records).
Regards,
Gregor
HI Gregor.
OMG, I can't believe. DSO Planning - so many years we're waiting this.
> - as attribute fields of the DSO only key figures are allowed
Sorry, don't understand this. Please, more detail.
Hi,
an attribute is a non-key field.
Regards,
Gregor
Hi Gregor,
thanks for the update.
Do you know if the DSO planning functionality will be available only for BW 7.30 on HANA or also for BW 7.30 on a traditional database?
Hi,
for more details you have to wait for 7.30 SP08 release notes.
Regards,
Gregor
Can't wait... :-P
I'm actually in the middle of an upgrade project, installing 7.30 SP07... but I'll have a look, this thing could be very useful.
Thanks.
Any updates ?
Hi,
DSO Planning was shipped with BW7.30, SP08 (or BW7.31, SP05). Integrated Planning supports 'direct update' DSOs with the new flag 'Planning Mode' being set. This flag ensures that Integrated Planning creates the SIDs for master data values used in the DSO. The old standard API for 'direct update' DSOs cannot be used since SID generation is not supported there. The 'planning DSO' can only be filled via Integrated Planning, but a planning DSO can be used as a source of a DTP.
Planning DSOs are supported on all DB platforms supported by BW, including HANA. Except on HANA one has the ususal limit of 16 key fields. Check note 1735590 for more information about DSO Planning and PAK.
Regards,
Gregor
Message was edited by: Gregor Dieckmann Additional information can be found here: http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c01adca8-39f0-2f10-5297-c761f970d7af?QuickLink=index&overridelayout=true&57475252355294