Hello,   I have a SAS VA 7.4 report with 2 tabs. Each tab has a list table, each with its own data source.   These tables are linked together so when a record in Tab 1-List Table 1 gets clicked, it drills down to Tab 2-List Table 2 and displays a record.   The issue that I am having is that when the report first loads, it loads every record in the data source in both List Tables. This is expected behavior, however, I would prefer that List Table 2 on tab 2 NOT load every record. i want List Table 2 to be empty unless someone clicks on a row in List Table 1.   Is this possible? ... View more

Hello,   I am not sure which location to do this under so I will ask the question here.   We have a SAS environment that uses Oracle as its data source. Most of our connections connect directly to a Schema that has all the views and/or tables that we need for that specific project.   We have no issues setting this up.   We do have one team that wants to come onboard and they have multiple schemas with multiple tables in the same Oracle database and they want us to surface this via SAS.   Our administrator created a database connection and was successful, however, because this database account has read access to so many schemas and tables, they did not specify a schema when the connection was created. This makes it impossible to register any tables(because the database account doesnt have any tables associated with it directly)..   What I'd like to know is, is it possible to surface all the tables I need from all the schemas that my oracle account has access to in one library so I can register them via SMC?      ... View more

Hey guys,   I have been using SAS VA for about a year, but have worked on multiple other reporting/BI tools before. Most of these tools provide this functionality I am about to describe by default, but it doesnt seem like SAS VA does.   I have several SAS VA reports with Date range filters. The reports work fine and the date filters adjust depending on the data.    I want to know if there is a way to automatically set the end date of these date filters to "today" or whatever the "latest  date" is in the data. So if a user logs into VA on 2/23/2017, the end date on that filter defaults to 2/23/2017, or the newest date available in the data itself.   Is this possible?     ... View more