BookmarkSubscribeRSS Feed
vivekk17
Calcite | Level 5

How data query is stored internally. Is this stored as metadata or stored as query/code at particular location?

 

 

 

 

3 REPLIES 3
TejaSurapaneni
Lapis Lazuli | Level 10

Hello Vivek,

 

Please refer the below link,

 

http://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#p1eetf3dmyzgf4n1cngxq...

 

Hope this helps.

 

Thanks & Regards,

Teja Surapaneni

Madelyn_SAS
SAS Super FREQ

Query information is stored in metadata and also in the SharedServices database. See the SAS(R) 9.4 Intelligence Platform: Middle-Tier Administration Guide for more information about the database.

http://support.sas.com/documentation/cdl/en/bimtag/68217/HTML/default/viewer.htm#p1wm2vva6wgsynn11oa...

 

 

vivekk17
Calcite | Level 5

Thanks Madelyn information is really helpful . I was facing issue as I was upading source metadata but query doesn't adapt accordingly and was using old values (i.e label for existing column used in query) but new columns when used from same source table used latest updated metadata value (i.e label in this case).

 

I could see Query stored as transformation object but was not able to trace other details .

 

Thanks for information.

 

 

sas-innovate-2024.png

 

Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.

 

Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer. 

 

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
  • 3 replies
  • 955 views
  • 0 likes
  • 3 in conversation