Writting data into table

[former_member745856]

Hi,

Im trying modify the selected value (unnasigned) from table for a dimension value. The table look like this

ACCOUNT | PROJECT | PEP    | TAG   | BILLABLE
SAMPLE     SAMPLE   SAMPLE  SAMPLE   UNNASIGNED
SAMPLE2    SAMPLE2  SAMPLE2 SAMPLE2  UNNASIGNED

the Billable dimension:

ID | DESCRIPTION
0     UNNASIGNED
1     Billable
2     Nom Billable

I need modify the unnasigned value by Billable dimension value according to the user choice. In this point im created a popup with radiobutton with this code:

var sel = Table_1.getSelections();
if(RadioButtonGroup_1.getSelectedKey()==="billable" && buttonId === "button1"){
		Table_1.getPlanning().setUserInput({"ASSET":sel[0]["ASSET"],
						   "BILLABLE":sel[0]["BILLABLE"],
						   "PEP":sel[0]["PEP"],
						   "TAG":sel[0]["TAG"],
						   "Account":"[Account].[parentId].&[Total]"},"1");
	
	Table_1.getPlanning().submitData();				
	Popup_1.close();
   } else if (RadioButtonGroup_1.getSelectedKey()==="no_billable" && buttonId === "button1") {
	   Table_1.getPlanning().setUserInput({"ASSET":sel[0]["ASSET"],
						   "BILLABLE":sel[0]["BILLABLE"],
						   "PEP":sel[0]["PEP"],
						   "TAG":sel[0]["TAG"],
						   "Account":"[Account].[parentId].&[Total]"},"2");
	 
	   
	   Table_1.getPlanning().submitData();	
	   Popup_1.close();
   }

i recived this error

Sorry, we couldn't carry out your data entry because one or more conditions for entering data haven’t been met. executed: undefined

Help please!

Thanks!

[saurabh_sonawane · Accepted solution]

we will not delete the row we will replace a value against the dimension.

Please find below link that will help you

https://help.sap.com/doc/a2c49c40bbe549ef9c291537aa561430/release/en-US/index.html

Thanks,

Sairabh S.

[saurabh_sonawane · Accepted solution]

If you find above info helpful, feel free to up-vote (arrows on the left) and accept (accept button at the bottom). This will help grow knowledge based.

[WissamChebli · Accepted solution]

The link is not working anymore

[saurabh_sonawane]

Hi,

To meet the above requirement I would suggest go with the data action.

With the application designer, we cant overwrite the one dimension value with a new value so for that, we have to use a data action.

Thanks,

Saurabh S.

[former_member745856]

Hi saurabh.sonawane

Thaks im gonna check it. Do you think that from the popup i can delete a row and then insert another equal with the modified field?

thanks!

[saurabh_sonawane]

Hi

With the help of advanced formulas in data action, you can do it.

The note identifies the lowest granularity of the data and passes it with the value that needs to be changed in the data action.

(you can create a parameter in the data action and use that in the application designer)

Below link will help you.

https://www.youtube.com/watch?v=9gQuFNt4ayQ

https://help.sap.com/doc/a2c49c40bbe549ef9c291537aa561430/release/en-US/index.html

Thanks,

Saurabh S

[former_member745856]

Hi,

Thanks for answering saurabh.sonawane. Can you suggest me a way to do it with data actions to search for information on the internet please.

Thanks you so much.