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 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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