Dear SAS community, business users who are not analytically literate could refrain from using a beautiful, sas powered Visual Analytics report because they miss data-entry functionalities they have in excel.
I found some excellent topics regarding how data-entry in VA could look like, @Renato_sas, @XavierBizoux and Stu Sztukowski have made fantastic contributions in this regard.
It comes close to what I want to achieve.
The user can pass his input through controls to parameters. With a list or a cross table he selects which rows of the table he wants to update (here with the 2% adjustment).
The DDC calls the html file which updates the cas table.
I think that based on your description. It can be achieved using the DDC object.
What I would do based on your description is add a calculated measure to the table in VA. The calculated measure would evaluate the existing measure multiplied by the adjustment factor. The measure doesn't have to be displayed in the report but it can then be passed to the DDC object. This will then allow the DDC object to generate the correct call to a SAS Viya job that will update the source table in CAS or in a database. I think this should clearly meet your expectations.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.