6/4/24, 12:06 AM Entering Measures into a table using script - SAP Community

Community

SAP Community  Products and Technology  Technology  Technology Q&A

 Entering Measures into a table using script

All community  What are you looking for today?

Options

Entering Measures into a table using script

ahfadoo
Participant

on ‎11-03-2023

 0 Kudos

Hi, I have a table with manually inputted dimensions but their measures have come up as
empty. Is there any possible way to generate measures using scripts or any other
features within SAC?

Thank you for the help!

SAP Managed Tags:

SAP Analytics Cloud

 Show replies

Answer

https://community.sap.com/t5/technology-q-a/entering-measures-into-a-table-using-script/qaq-p/12808714 1/6
6/4/24, 12:06 AM Entering Measures into a table using script - SAP Community

Accepted Solutions (0)

 Answers (1)

N1kh1l
Active Contributor

‎11-03-2023

 0 Kudos

ahfadoo

ahfadooYou can explore the Planning API setUserInput(selectedData: Selection JSON,

value: string): boolean

https://help.sap.com/doc/958d4c11261f42e992e8d01a4c0dde25/release/en-
US/index.html#Planning_MsetUser...

Another solution could be to generate the measure values by Data Action. The selections
could be passed from the table to the data action.

Br.

Nikhil

 Show replies

 You must be a registered user to add a comment. If you've already

registered, sign in. Otherwise, register and sign in.

Comment

https://community.sap.com/t5/technology-q-a/entering-measures-into-a-table-using-script/qaq-p/12808714 2/6
6/4/24, 12:06 AM Entering Measures into a table using script - SAP Community

ahfadoo
Participant

‎11-06-2023

 0 Kudos

Hi nikhil_1486,

Thanks for the help! The setUserInput function was just what I was looking for!
Although I seem to be running into an error every time my script runs in SAC.

This is the error I keep gettting: Sorry, we couldn't carry out your data entry because
one or more conditions for entering data haven’t been met....

This is my current code. I am using the variable t to store my boolean result for my
setinput. My plan for the setinput is to look at the new member that gets created and
input a manual value accordingly. Any help at all would be appreciated!

 image.png 

https://community.sap.com/t5/technology-q-a/entering-measures-into-a-table-using-script/qaq-p/12808714 3/6
6/4/24, 12:06 AM Entering Measures into a table using script - SAP Community

Ask A Question

Type your question here...

Continue

Recommendations

 Calculated measures based on restricted measures 
‎03-01-2024


 Re: Combining measures with dimensions in table co... 
‎02-08-2024


 Get all the metadata of webi report using pyhton s... 
4 weeks ago


 Using PAL Procedures embeded in SQL Script (anony... 
‎02-08-2024


 Groovy script udf to handling script length 
‎02-25-2024

Related Content
CI/CD with SAP AI Core 
in Technology Blogs by SAP Wednesday

What’s New in SAP Datasphere Version 2024.10 — May 7, 2024 

https://community.sap.com/t5/technology-q-a/entering-measures-into-a-table-using-script/qaq-p/12808714 4/6
6/4/24, 12:06 AM Entering Measures into a table using script - SAP Community
in Technology Blogs by Members 4 weeks ago

SAC scripting: Change measure based on value of a dimension input control? 

in Technology Q&A 4 weeks ago

What’s New in SAP Analytics Cloud Q2 2024 

in Technology Blogs by SAP a month ago

SAP Datasphere News in April 

in Technology Blogs by SAP 05-03-2024

Top Q&A Solution Author

SAPSupport  70

William_Yu  9

bill_froelich  8

Edrilan_Berisha  7

john_p_grimes  6

Jitendra_Kansal  5

Ryan-Crosby  5

N1kh1l  5

MioYasutake  5

https://community.sap.com/t5/technology-q-a/entering-measures-into-a-table-using-script/qaq-p/12808714 5/6
6/4/24, 12:06 AM Entering Measures into a table using script - SAP Community

JefB  4

View all

Latest Posts
Re: Build SSAM 2405 failed - Missing extension SAM...

Re: SAP CI XI Adapter Exception Handling

Re: Wrong GL is debited in Landing Cost JE

How to make different colour for editable KPIs

Re: How to send data's SAP Environment Management ...

View all

Follow

Privacy Terms of Use

Copyright Legal Disclosure

Trademark Newsletter

Support Cookie Preferences

https://community.sap.com/t5/technology-q-a/entering-measures-into-a-table-using-script/qaq-p/12808714 6/6