BookmarkSubscribeRSS Feed
MarkESmith
Obsidian | Level 7

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

 

13 REPLIES 13
Madelyn_SAS
SAS Super FREQ

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

MarkESmith
Obsidian | Level 7
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.
Madelyn_SAS
SAS Super FREQ

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.

 

 

MarkESmith
Obsidian | Level 7
Yes, the output is to a LASR table.
MarkESmith
Obsidian | Level 7

Bumpity bump.

 

Anyone seen this issue before?

 

 

Madelyn_SAS
SAS Super FREQ

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.

 

 

 

Madelyn_SAS
SAS Super FREQ

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?

MarkESmith
Obsidian | Level 7

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

 

 

Madelyn_SAS
SAS Super FREQ

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.  

MarkESmith
Obsidian | Level 7

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)
   );

Madelyn_SAS
SAS Super FREQ

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.

MarkESmith
Obsidian | Level 7

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?

Madelyn_SAS
SAS Super FREQ

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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 13 replies
  • 1438 views
  • 1 like
  • 2 in conversation