BookmarkSubscribeRSS Feed
agesser
Obsidian | Level 7

Hi all,
we have a request to write complex queries based on the information regarding alerts client have in AML 8.3 (VI 10.8)
we were thinking about creating some views in the VI internal DB that will help us to query the data.
is this possible?
what is the best practice for this? a difference scheme, etc?

Thanks ,
Alex.

1 REPLY 1
AchinGupta
SAS Employee

It's better to create a new Schema with all the custom views so that these are more manageable. however, you could create views in existing schemas form where the data is being sourced. Adding new tables and views shouldn't impact future HFs or upgrades.

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

Discussion stats
  • 1 reply
  • 1314 views
  • 0 likes
  • 2 in conversation