BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
DavidPhillips2
Rhodochrosite | Level 12

Two working days in a row I ran into a scenario where all of the columns in one of my Visual Analytics data queries was deleted.  The laser table was not deleted because in both cases I was modifying the input table for the data query and did not run the data query.  The last time that it occurred I was adding a column. 

 

The steps I took were:

I updated the Oracle table using Enterprise Guide

I updated the metadata in Management Console

I updated the metadata library that pulls from the library updated.  I did this using Enterprise Guide, update library metadata, update and add table definitions in metadata with the actual tables and columns.

In Visual Analytics Prepare Data the inputs screen is blank.

The data query I am working with is on dev VCU/Enterprise Analytics and Advanced Research/Data Queries/Retention data query.

 

It is possible that this occurred because I accidently forgot to include a grant to the oracle group that uses the table before refreshing the metadata?  Do you know of a way to keep from having to re-create the data query? 

1 ACCEPTED SOLUTION
1 REPLY 1

sas-innovate-2024.png

 

Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

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
  • 1 reply
  • 669 views
  • 0 likes
  • 1 in conversation