regarding html prompts within Visual Analytics making use of job execution

acordes — Tue, 21 Nov 2023 12:33:48 GMT

I am following on the subject Task Prompts used in Viusal Analytics which was nicely explained in a tutorial written by @XavierBizoux

https://communities.sas.com/t5/SAS-Communities-Library/Create-a-SAS-Viya-Job-with-a-prompt-using-Task-Prompts/ta-p/658639

I'm struggling to populate the list box with levels available in a data source that relates to a caslib.

The relevant block for the prompt generating code is:

Highlighted you can see my failed attempts to direct the data source to the table "REMA" in caslib "PUBLIC".

It gives an error or fails to load the data source.

So how do I change sashelp.cars to public.rema?

<?xml version="1.0" encoding="UTF-8"?>
<Task schemaVersion="7.2">
    <Registration>
        <Name>Filter Cars</Name>
        <Description>Prompt for SASHelp Cars report</Description>
        <Version>5.2</Version>
    </Registration>
    <Metadata>
        <DataSources>
<!--             <DataSource name="dataset" defaultValue="CASUSER.VENTAS_OPE_FORM1" where="false" required="true" readOnly="true"> -->
<!--             <CasResource server="cas-shared-default" defaultValue="REMA" library="PUBLIC" table="REMA" locale="en_US"/> -->
        <DataSource name="dataset" defaultValue="SASHELP.CARS" where="false" required="true" readOnly="true"  >
<!--             <CasResource server="cas-shared-default" library="PUBLIC"/> -->
<!--             <DataSource name="dataset" defaultValue="REMA" where="false" required="true" readOnly="true"> -->
                <Filters>
                    <Filter name="originFilter">
                        <Column column="MAKE" sortBy="label" sortDirection="ascending"/>
                    </Filter>
                    <Filter name="typeFilter">
                        <Column column="MODEL" sortBy="label" sortDirection="ascending"/>
                        <Where>
                            <Expressions>
                                <Expression operation="eq">
                                    <Column column="MAKE" sortBy="label"/>
                                    <Value option="var_origin"/>
                                </Expression>
                            </Expressions>
                        </Where>
                    </Filter>
                    <Filter name="driveTrainFilter">
                        <Column column="DRIVETRAIN" sortBy="label" sortDirection="ascending"/>
                        <Where>
                            <Expressions>
                                <Expression operation="in">
                                    <Column column="MODEL" sortBy="label"/>
                                    <Value option="var_type"/>
                                </Expression>
                            </Expressions>
                        </Where>
                    </Filter>
                </Filters>
            </DataSource>
        </DataSources>

Re: regarding html prompts within Visual Analytics making use of job execution

XavierBizoux — Tue, 21 Nov 2023 13:03:14 GMT

Hi Arne,

In order to be usable by the prompts, the library should be defined in the Compute session used behind the scene to retrieve the data. Usually, CAS libraries are not assigned upfront for the compute contexts. You should make sure that the library is defined in the autoexec of the compute server or that you have created the library with the flag "Assign and connect to data sources at startup" is checked as described in the following blog.

That should fix the issue.

Regards,

Xavier

topic Re: regarding html prompts within Visual Analytics making use of job execution in SAS Viya

regarding html prompts within Visual Analytics making use of job execution

Re: regarding html prompts within Visual Analytics making use of job execution