cancel
Showing results for 
Search instead for 
Did you mean: 

Saving comments as short-text on SAP BPC 10.1 Embedded

Former Member
0 Kudos

Hi everyone,

I am trying to enable the comments functionality in my planning model for BPC 10.1 Embedded.

I have gone through some forums earlier and have carried out the following steps to save the comments as a short-text:

1. Created a DSO (Direct-Update) and set the Planning Mode to ON.

2. Added a characteristic in the Data Fields and set the Characteristics as Key Figure as ON within the DSO.

3. Created a MultiProvider on my Planning Cube  and the DSO.

4. Created an Aggregation level on the MultiProvider.

5. Created an Input-Enabled query and added "Amount" and "Comment" in the Key Figures.

6. Created an EPM Input Form. Version of EPM (10.0 SP 25 Patch 1 .NET4)

7. While saving the data, getting an error as below:

Kindly Help!

Accepted Solutions (1)

Accepted Solutions (1)

former_member200327
Active Contributor
0 Kudos

Can you check if your DSO is in Planning mode and not in Load mode?

Former Member
0 Kudos

Hi,

DSO is in Planning Mode with Direct Update. Please see the below screenshot:

Former Member
0 Kudos

Hello,

Might be already you have checked. Is the Query is input ready for those fields combination.

Check this link

DataStore

The data records located in the DataStore define the valid characteristic combinations and are used for characteristic derivation.

Only combination check: You can select all InfoObjects from the DataStore object (except for key figures).

With Derivation: You have to select the keys of the DataStore object as source characteristics.

Target characteristics can be InfoObjects from the data part of the DataStore object (except for key figures).

The keys for the DataStore objects can be restricted in any case; the restricted part is then used for the combination check or derivation. The restrictions can be parameterized with variables that must be replaceable without the dialog.

We recommend that you use only small DataStore objects (with few characteristics, few records).

I guess you have created the aggregation level on multi provider check the combination of key for planning.  Check this blog for planning DSO.

Check this if it helps.

Thanks & Regards,

Geeta

Former Member
0 Kudos

Hi Geeta,

Thanks for sharing the document. I changed the structure and added all the fields in the DSO to my Aggregation level. The error has changed now to:

Info [Server]: (#19) Data slice '0001(0001)' protects the characteristic combination; MsgClass: RSPLS_CR

If you can assist further.

Thanks,

Prateek

Answers (3)

Answers (3)

Former Member
0 Kudos

While saving the Amount and comment, we have to refer both of then to the DSO.

Earlier i was mapping the Amount to the InfoCube and Comment to the DSO. However, as soon as i mapped both of them to the DSO, i am able to save the comment and the amount both.

Now i am not sure if now i will have to do all my planning in the DSO itself. This needs to be explored further. But the basic issue has been resolved.

0 Kudos

Hi Prateek,

just as a clarification: a MultiProvider is a union of the part providers, say a real-time InfoCube IC and a planning enabled DataStore Object DS. To define what you get from the part providers IC, DS you have to define a mapping of the characteristics and key figures. Observe that for currency/unit characteristics the mapping is done implicitly, i.e. currency and units are mapped if the currency or unit is used in a key figure of type amount or quantity, respectively.

If in your DataStore Object you have a unit/currency in the key part and no key figure of type amount/quantity is mapped to a corresponding amount/quantity in the MultiProvider then also the currency/unit will not be mapped. In this case you will get the above mentioned messages.

In this case you should add one key figure of type amount/quantity in the DataStore Object and map these key figures to the corresponding key figures in the MultiProvider to ensure that the corresponding currency/unit are also mapped. In a DataStore Object all characteristics in the key have to be mapped to allow planning.

Regards,

Gregor

Former Member
0 Kudos

Hi Gregor,

Yes, I have done the same here. I have added "Amount" type "Curr" in the DSO and also the "Comment" type "Char as KF" in the DSO.

Amount is added in the Real Time IC as well and mapped in the MultiProvider.

But when i add the KF's in the Query, they have to be restricted with the InfoProvider Property.

Now, For Amount if i give the Infoprovider as "Real time IC" and for Comment i give it as "Input Enabled DSO" , the data doesnt get saved from the Input Form for the Comment. On the other hand, If i give the property for both - Amount and Comment as the DSO, then it allows me to save the data from the Input Form.

So, the only thing is, the Amount KF get populated in the DSO rather than the InfoCube. This makes me wonder that do i actually need the infocube then? As the entire planning can be done on the DSO itself.

Any suggestions?

Regards,

Prateek

Message was edited by: Prateek Garg

0 Kudos

Hi Prateek,

'data does not get saved' is not clear enough. Maybe the 'comment' simply is not input-ready. You should use proper formatting in the EPM Add-In or use AO or RSRT to check whether the cell you try to change is really input-ready.

You can have the amount in an InfoCube and the 'comment' in a DSO, this is no problem at all. But you have to ensure that the cell coming from the DSO is input-ready. Most probably some restrictions are missing, e.g. the currency. As I said, to write data back to a DSO all key fields have to be uniquely determined (including 0INFOPROV, unit, currency if used); you may use disaggregation then you can change also aggregated cell values, in case of key figures with aggregation NO2 then disaggregation 'copy' is used. But the characteristics 0INFOPROV, unit, currency if used always have to be uniquely determined.

Regards,

Gregor

Former Member
0 Kudos

Hi Gregor,

I will try and explore this further. Will get back to you in a days time.

Thanks for the support.


Regards,

Prateek

Former Member
0 Kudos

Thanks for the assistance Gregor, I was able to use the functionality as explained by you.

Regards,

Prateek

Former Member
0 Kudos

I have managed to get rid of the error message by following the above post. But now, when i am inputting the data in the EPM Input Form. The system is not recognizing the Comment cells as Input-able. I have checked the below points:

  • DSO is Direct Update
  • DSO is Input ready
  • KF (Comment) in the Bex Query is Input-enabled.

Still i am facing the below issue:

Please help.

Regards,

Prateek

Former Member
0 Kudos

What is the error. Clcik on Yes button and check it might save the record to backend.

Thanks & Regards,

Geeta

Former Member
0 Kudos

It's saves only the data under the Amount Key Figures. The report refreshes and the Comment cells are empty.

Regards,

Prateek

Former Member
0 Kudos

What are your system configurations...

Check this link for the system configurations,,,,, and similar issues what you have

https://scn.sap.com/thread/3640641

0 Kudos

HI Prateek I guess you cant save the comment on bex query report, you need to create another report on the bex query then try to save the comment, it will work

Former Member
0 Kudos

Hi Chandrakanth, Thanks for your prompt response. I tried doing that as well. I created a new query and tried to save only the comments. Still got the same error.

former_member222556
Contributor
0 Kudos

Hi Prateek,

Please check you authorization and also check the below. This might help you.

Editing Short Texts in Queries - Using the SAP HANA Database - SAP Library

Thanks

Obaid

Former Member
0 Kudos

Hi Obaid,

I have SAP_ALL Authorization, as it's on DEV Server rite now. Also, yes I have referred the link u sent and also this one Example: Entering Comments in a Query - Using the SAP HANA Database - SAP Library

Still facing the same error. Just to clarify. Can EPMSaveComment be used in SAP BPC 10.1 Embedded Environment?

former_member222556
Contributor
0 Kudos

Hi Prateek,

Below scenario is exactly same as your. Please look at blog:

There might be something wrong in Comment restriction. have you assign the key figure to the comment object?

Thanks

Obaid

Former Member
0 Kudos

Hi,

Nopes, I am unable to assign the key figure to the comment object. Lemme try that again once. Will get back to u in a while.

Many Thanks

Prateek

Former Member
0 Kudos

Hi Obaid,

In the blog, While creating the Bex Query, the Amount (Standard) Keyfigure is passed as an restriction to Measure(KF) Characteristic. I am unable to do this particular step.

I have added an Info object in my DSO, But am unable to restrict the same in my query.

Can u guide how to achieve this?

Blog screenshot:

DSO:

Query:

former_member222556
Contributor
0 Kudos

That is only applicable if you have multiple keyfigures in model and you want to store comment for each key figure differently.

So I dont think that should an issue.

Can you try by putting 0CURRENCY in the restriction of comment KF?

Former Member
0 Kudos

Hi Obaid,

Done that. Still the same error.

Error Message

Info [Server]: (#46) 'Comment ' is not input-ready: Data slices, characteristics relationships; MsgClass: RSPLS_CR
Warning [Server]: (#17) Characteristic combination cannot be assigned to a part provider; MsgClass: RSPLS_CR
Warning [Server]: (#28) Characteristic: '0CURRENCY' ; Characteristic value: 'INR'; MsgClass: RSPLS_CR