Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Unable to click 'Explore Results' for queries created by specific user

Reply
Occasional Contributor
Posts: 10

Unable to click 'Explore Results' for queries created by specific user

Hi all,

 

One of our SAS users creates queries in SAS Visual Data Builder - the problem though is that when he or anyone else runs his queries (queries that he has created with his user account), they are unable to click the 'Explore Results' link - it is simply grayed out and does not allow users to click it. This being said - the initial results from the query do show on the page, it's just the 'Explore Results' link that won't seem to work. When the user in question runs queries created by other users, the 'Explore Results' link functions normally. I thought perhaps his user account authorities might be the culprit, but his authorities don't look any different than other users. If anyone can point me in the right direction here to solve this problem, it would be much appreciated. I have included an image below to better demonstrate which link I am talking about when I refer to the 'Explore Results' link.

 

Thanks!

sas_example.PNG

 

SAS Super FREQ
Posts: 586

Re: Unable to click 'Explore Results' for queries created by specific user

Posted in reply to MarkESmith

Do the users have the ability to use SAS Visual Analytics Explorer?

Occasional Contributor
Posts: 10

Re: Unable to click 'Explore Results' for queries created by specific user

Posted in reply to Madelyn_SAS
Yes - and like I mentioned in the initial post - it's only one particular user's queries that result in a non-working 'Explore Results' link - this user can click the 'Explore Results' link without problems after running a query created by anyone else.
SAS Super FREQ
Posts: 586

Re: Unable to click 'Explore Results' for queries created by specific user

Posted in reply to MarkESmith

I'm sorry if this is an obvious question, but is the Output Table a LASR table? I'm asking because Data Builder does enable you to output to a SAS data set as well.

 

 

Occasional Contributor
Posts: 10

Re: Unable to click 'Explore Results' for queries created by specific user

Posted in reply to Madelyn_SAS
Yes, the output is to a LASR table.
Occasional Contributor
Posts: 10

Re: Unable to click 'Explore Results' for queries created by specific user

Posted in reply to MarkESmith

Bumpity bump.

 

Anyone seen this issue before?

 

 

SAS Super FREQ
Posts: 586

Re: Unable to click 'Explore Results' for queries created by specific user

Posted in reply to MarkESmith

The only reasons that I am aware of that would prevent Explore Results from working are:

  • The query has not been executed successfully at least once in the current session.
  • The output table is not a LASR table.
  • User doesn't have access to Visual Analytics Explorer or Explorer is not installed.

 

I think you will need a Tech Support track to dig a little deeper.

 

 

 

SAS Super FREQ
Posts: 586

Re: Unable to click 'Explore Results' for queries created by specific user

Posted in reply to Madelyn_SAS

I found a fourth possible reason for the Explore Results link to be disabled. This can occur if you unlock the code for the query. Is it possible that the user has done that?

Occasional Contributor
Posts: 10

Re: Unable to click 'Explore Results' for queries created by specific user

Posted in reply to Madelyn_SAS

Possible - but I'm not sure exactly what you mean. If I have full administrative rights, how could I verify that?

 

 

SAS Super FREQ
Posts: 586

Re: Unable to click 'Explore Results' for queries created by specific user

[ Edited ]
Posted in reply to MarkESmith

Actually, I see from your first screen shot that the code is not unlocked.

 

If that isn't the issue, could you post the code from the Code tab, removing any confidential details.  

Occasional Contributor
Posts: 10

Re: Unable to click 'Explore Results' for queries created by specific user

Posted in reply to Madelyn_SAS

You are correct - code was not unlocked.

 

Here's the query's code, slightly redacted:

 

/** QUERY **/
options validvarname=any validmemname=extend;

/* Register Table Macro */
%macro registertable( REPOSITORY=Foundation, REPOSID=, LIBRARY=, TABLE=, FOLDER=, TABLEID=, PREFIX= );

/* Mask special characters */

   %let REPOSITORY=%superq(REPOSITORY);
   %let LIBRARY   =%superq(LIBRARY);
   %let FOLDER    =%superq(FOLDER);
   %let TABLE     =%superq(TABLE);

   %let REPOSARG=%str(REPNAME="&REPOSITORY.");
   %if ("&REPOSID." ne "") %THEN %LET REPOSARG=%str(REPID="&REPOSID.");

   %if ("&TABLEID." ne "") %THEN %LET SELECTOBJ=%str(&TABLEID.);
   %else                         %LET SELECTOBJ=&TABLE.;

   %if ("&FOLDER." ne "") %THEN
      %PUT INFO: Registering &FOLDER./&SELECTOBJ. to &LIBRARY. library.;
   %else
      %PUT INFO: Registering &SELECTOBJ. to &LIBRARY. library.;

   proc metalib;
      omr (
         library="&LIBRARY."
         %str(&REPOSARG.)
          );
      %if ("&TABLEID." eq "") %THEN %DO;
         %if ("&FOLDER." ne "") %THEN %DO;
            folder="&FOLDER.";
         %end;
      %end;
      %if ("&PREFIX." ne "") %THEN %DO;
         prefix="&PREFIX.";
      %end;
      select ("&SELECTOBJ.");
   run;
   quit;

%mend;

LIBNAME LASRLIB SASIOLA  TAG=VAPUBLIC  PORT=10031 HOST="xxxx.xxx.xx"  SIGNER="http://xxxx.xxx.xx:7980/SASLASRAuthorization" ;

LIBNAME DPPUBLIC BASE "/opt/sas94/config/Lev1/AppData/SASVisualAnalytics/VisualAnalyticsAdministrator/PublicDataProvider";

option DBIDIRECTEXEC;

/* Drop existing table */
%vdb_dt(DPPUBLIC.SPMIDMOrderOrigins);
proc sql noprint;
    
    create table DPPUBLIC.SPMIDMOrderOrigins AS SELECT
        '12_MONTH_RPL_&_AD_PEFORMANCE'n.'WQCUST#'n length=8 format=F11. label='Customer Number' AS 'WQCUST#'n,
        ORDER_DETAIL.ODSRCD length=6 format=$6. label='Source Code' AS ODSRCD,
        RPL_SUMMARY_FULL_HISTORY.MEDIA_CAT length=2 format=$2. label='Media Cat Code' AS MEDIA_CAT,
        ORDER_DETAIL.OROREC length=1 format=$1. label='Order Rec. via' AS OROREC,
        RPL_SUMMARY_FULL_HISTORY.SALE_DATE length=8 format=YEAR4. label='Sale Date' AS SALE_DATE,
        '12_MONTH_RPL_&_AD_PEFORMANCE'n.WQENROLLED length=1 format=$1. label='Customer Enrolled' AS WQENROLLED
    FROM
        LASRLIB.ORDER_DETAIL ORDER_DETAIL
    INNER JOIN
        LASRLIB.'12_MONTH_RPL_&_AD_PEFORMANCE'n '12_MONTH_RPL_&_AD_PEFORMANCE'n
            ON ORDER_DETAIL.ODCUST = '12_MONTH_RPL_&_AD_PEFORMANCE'n.'WQCUST#'n
    RIGHT JOIN
        LASRLIB.RPL_SUMMARY_FULL_HISTORY RPL_SUMMARY_FULL_HISTORY
            ON ORDER_DETAIL.ODSRCD = RPL_SUMMARY_FULL_HISTORY.SOURCE
    WHERE
        RPL_SUMMARY_FULL_HISTORY.MEDIA_CAT='LR'  
        OR RPL_SUMMARY_FULL_HISTORY.MEDIA_CAT='RE'  
        AND RPL_SUMMARY_FULL_HISTORY.SALE_DATE>'01JAN2017'd
        AND '12_MONTH_RPL_&_AD_PEFORMANCE'n.WQENROLLED='Y'  ;
quit;

/* Synchronize table registration */
%registerTable(
     LIBRARY=%nrstr(/Shared Data/SAS Visual Analytics/Public/Visual Analytics Public Data Provider)
   , REPOSID=%str(A5L1CQYX)
   , TABLEID=%str(A5L1CQYX.BG00014A)
   );

SAS Super FREQ
Posts: 586

Re: Unable to click 'Explore Results' for queries created by specific user

[ Edited ]
Posted in reply to MarkESmith

lt looks like a LASR table named  ORDER_DETAIL ORDER_DETAIL is the input table for the query, and the output table --SPMIDMOrderOrigins-- is being saved to the public data provider library:

 

LIBNAME DPPUBLIC BASE "/opt/sas94/config/Lev1/AppData/SASVisualAnalytics/VisualAnalyticsAdministrator/PublicDataProvider";

 

The data provider library is a Base SAS library. So, the output table is a SAS data set, not a LASR table. Explore Results is available only for LASR tables.

Occasional Contributor
Posts: 10

Re: Unable to click 'Explore Results' for queries created by specific user

Posted in reply to Madelyn_SAS

Interesting - thank you! I'll let you know if this was the crux of the problem (sounds like it probably is) when the end-user tests. I apologize for my assumption that the output was a LASR table - I'm more involved as a sysadmin with our SAS server so a lot of this query creation stuff is not familiar to me.

Another question I have - is the output library always explicitly specified by the user or does it take on a default?

SAS Super FREQ
Posts: 586

Re: Unable to click 'Explore Results' for queries created by specific user

Posted in reply to MarkESmith

The Table, Location, and Library have a default. For a new query, the Table name is always OutputTable. I believe that Location field and the Library field contain the most recently used values.

Ask a Question
Discussion stats
  • 13 replies
  • 194 views
  • 1 like
  • 2 in conversation