Data-driven-content in VA: how to pass parameters & vars in order to update a cas table

acordes — Thu, 04 Jun 2020 13:05:11 GMT

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.

And the user input gets recorded.

This would be the excel killer.

Is this possible experts?

{
    "version": "1",
    "resultName": "dd696",
    "rowCount": 2,
    "availableRowCount": 2,
    "data": [
        [
            "A5065",
            "GOLF",
            24
        ],
        [
            "A5066",
            "GOLF",
            24
        ]
    ],
    "columns": [
        {
            "name": "bi694",
            "label": "obs",
            "type": "string"
        },
        {
            "name": "bi697",
            "label": "MODELO",
            "type": "string"
        },
        {
            "name": "bi698",
            "label": "APLAZ",
            "type": "number",
            "usage": "categorical",
            "format": {
                "name": "COMMA",
                "width": 12,
                "precision": 2,
                "formatString": "COMMA12.2"
            }
        }
    ],
    "parameters": [
        {
            "name": "pr52",
            "label": "target_column_name",
            "dataType": "string",
            "value": "adjustment"
        },
        {
            "name": "pr663",
            "label": "adjustment",
            "dataType": "number",
            "value": 0.02,
            "format": {
                "name": "PERCENT",
                "width": 12,
                "precision": 0,
                "formatString": "PERCENT12."
            }
        }
    ]
}

Re: Data-driven-content in VA: how to pass parameters & vars in order to update a cas table

XavierBizoux — Thu, 04 Jun 2020 13:49:34 GMT

Hi,

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.

You might find some ideas on how it can be implemented in https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2020/4138-2020.pdf.

Let me know if you have questions.

Regards,

Xavier

topic Re: Data-driven-content in VA: how to pass parameters & vars in order to update a cas table in SAS Visual Analytics

Data-driven-content in VA: how to pass parameters & vars in order to update a cas table

Re: Data-driven-content in VA: how to pass parameters & vars in order to update a cas table