cancel
Showing results for 
Search instead for 
Did you mean: 

Characteristics value changes not captured to the data target

Former Member
0 Kudos

Dear All,


This requirement in a SAP BPS planning tool.


The changes made to the value of characteristics; (example: STATUS - changed value from D to F) are saved and even when we refreshed the planning tool, we could see that the changes remain as F. BUT When we close the frontend tool (portal) and reopen it, we could see that the changes do not reflect and the characteristic value is "D" again In other words only, it was saved to the cache/buffer and not to the realtime infocube / database tables, whereas the key figure changes were captured.


Also to denote, the characteristic "STATUS" is key field


Can you please help us to know how characteristic value changes can be captured to the data target.

Also to point out here for the scenario above to change the characteristic value, we tried using the reposting planning function but it had changed all the entries/records as specified in the parameter. Any Inputs in this area as well, TO SELECT and repost selected entry/ records/cell. 

Regards

Jerry


Thanking you in advance.


Regards

Jerry

Accepted Solutions (1)

Accepted Solutions (1)

Karim_Hamriche
Explorer
0 Kudos

Hi Jerry,

First of all I would like to know how do you save your data ? Are you using the "SAVE_DATA" function of your web template (for exemple through a button) ? Because if you don't, it will only change the value in the buffer but nothing will be modified in your infoprovider.

For your repost function ? Have you created a filter in your aggregation level, and when you call your planning function do you use a DataProvider type Filter based on this filter ?
Also, you need define your binding, for example, you can allow the "row selection"for your analysis_item and bind the data through this selection, so that the repost function will be correctly filtered and only needed value will be modified.

I hope it will help, let me know if there are problems,
Regards,
Karim

Former Member
0 Kudos

Dear Karim,

Can I please share your mail id so that I can share the respective screenshots of the configuration I had set in the backend.

jerry_raj2003 at yahoo dot com

Regards

Jerry

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi.

What do you mean by "changed value from D to F" ?

Changes in object's master data ?

Repost of values ?

Could you please provide some source and target line with its structure ...

Regards.

Former Member
0 Kudos

Dear Karim, Dear Andrey,

For Tried Solution-1

Here we have not used REPOST function

As this the planning tool, the value of the field STATUS (characteristics-master data/Key Column) will be changed from D (Draft) to F (Final) once the planning is done on the key figures. We are able to save it using the SAVE button in the fronend (web). We had changed the style in the layout by giving the option INPUT ON- BUT the problem is the chages are getting saved only to buffer and not to the target.

Once we close the tool and reopen it again, when it is called from the target again and not from the buffer/cache, we could see that the changes which had done on the characteristic value is back to original value.

For Tried Solution-2

We tried using the REPOST function

In BPS_WB, I had given REPOST function Button with details of area and level, Planning  function and parameter. Am I missing anything in the above configuration as the ON THE CLICK of repost button in the frontend (portal), ALL the entries of the characteristic field  'STATUS with value D changes to F BUT our requirement is only one or selected entries to repost the value.

Dear Karim: Also, you need define your binding, for example, you can allow the "row selection"for your analysis_item and bind the data through this selection, so that the repost function will be correctly filtered and only needed value will be modified. - WHERE DO YOU GIVE THIS BINDING AND CAN YOU PLEASE HELP ME TO KNOW THE STEPS FOR THIS BINDING.

Please find the BPS_WB for Repost configuration details

The fronend where we require the changes to STATUS. The STATUS was also greyed out earlier like the next column but we had changed the style to "input on"

Once the planning is completed to the key figure, here in this case to the first entry and when we hit the repost button that is created. Say I changed the first entry value of "BPrice 2009 from 0.50USD to 1 USD and SAVEd it using SAVE button.

As the first entry is planned, I need to change the "status" to F (Final). I select the entry and hit REPOST button I find all the entries in the selection page gets changed for the status field from D to F

I hope, you understand both the above tried solution with final result required. Require your kind help over this requirement..

Thanking you in advance.


Regards

Jerry

former_member93896
Active Contributor
0 Kudos

Jerry,

First you have to set the "row/cell" selection of the layout to "cell" or "line". Then add a variable selector component to the web interface. In this component, set the "source for selection" property to the layout component.

Now you can use the variable in your planning function. It will be filled at runtime with the characteristic values of the selected "cell" or "line".

Regards,
Marc
SAP Customer Solution Adoption (CSA)

Former Member
0 Kudos

Dear Marc,

Thank you very much.

First you have to set the "row/cell" selection of the layout to "cell" or "line". - I had selected it as line (earlier it was cell)

Then add a variable selector component to the web interface.-

I have added as variable selector/also there is Repost button created

Even though, the above configurations are done in bps_wb, I tried selecting the line and hit repost button, I find all the entries are getting changes as set in the parameter but not the selected line.

Am I missing any thing. Please be kind to give us more inputs and guidance on this.

Thanking you in advance.

Regards

Jerry

former_member93896
Active Contributor
0 Kudos

Jerry,

Here's a small example:

    

Layout1:

    

Char1    Char2    Kyf1

A             M100     100.00

B             M100     50.00

B             M200     30.00

BPS0:

    

PlanningPackage1:

Char1 = Var1

Char2 = Var2

BPS_WB:

    

- Layout1 has setting for "line" selection

- Variable selector for Var1: source for selection = Layout1

- Variable selector for Var2: source for selection = Layout1

    

When the user selects the first row, the system will set var1 = A and var2 = M100. If you run a planning function using planningpackage1, it will be restricted to the combination of the first row only.

Regards,
Marc
SAP Customer Solution Adoption (CSA)

Former Member
0 Kudos

Dear All,

I have raised a OSS message..Shall keep you updated,

Regards

Jerry