on 05-29-2012 3:32 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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)
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
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)
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.