How data query is stored internally. Is this stored as metadata or stored as query/code at particular location?
Hello Vivek,
Please refer the below link,
Hope this helps.
Thanks & Regards,
Teja Surapaneni
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.
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Creating Beautiful Reports
SAS Visual Analytics Learning Center
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.