I am unable to submit data using planning in SAP BW via Analysis Office

[FaisalKamal]

Hi Expert,

I'm currently trying to use planning as an input method via Analysis Office in SAP Business Warehouse. However, I encountered an issue when the input data exceeds 250 characters. The info object used as a key figure only supports a maximum length of 250 characters (CHAR).

From my understanding, only info objects set as key figures can be used for input data in query planning. Unfortunately, I can't use fields with SSTRING, which have a maximum length of 1333 characters, nor can I use the long text setting on the info object. This is because planning only reads the key of the info object, not its description.

Do you have any suggestions or workarounds for a requirement to input data using planning in Analysis Office when the data exceeds 250 characters?

Regards,
Faisal

BW (SAP Business Warehouse) SAP Business Planning and Consolidation, version for SAP BW/4HANA SAP Analysis for Microsoft Office 

[gregor_dieckmann]

Hi Faisal,

for commenting you can use BW DocumentStores, there you don't have the 250 characters limit:

https://help.sap.com/docs/SAP_BW4HANA/107a6e8a38b74ede94c833ca3b7b6f51/eef879a25ca940ea996b79c96a777...

Regards,

Gregor

[MKreitlein]

Hello @FaisalKamal ,

as far as I know there is no possibility to plan comments (which you obviously plan to do) in fields longer than 250 digits. If you want to store more data, then you need to create two or four of those fields, so that you can store 500 or 1.000 digits.

When you load the planned data into another DSO after planning, then maybe you can concatenate it into a bigger field. But anyways, my latest info was that XXL attributes cannot be used in reporting either. Maybe that changed in the meanwhile, or in BW4. I don't know.

BR, Martin

[FaisalKamal]

Hi Martin,

I really appreciate your reply.

I couldn't agree more with the method of using more than one info object to store data in a DSO.
Since the maximum characters allowed for reporting is only 250, the only way to handle this is by splitting the data into multiple info objects.

Thank you.

Regards,
Faisal

[FaisalKamal]

Hi Martin, I really appreciate your reply. I couldn't agree more with the method of using more than one info object to store data in a DSO. Since the maximum characters allowed for reporting is only 250, the only way to handle this is by splitting the data into multiple info objects. Regards, Faisal