In our first blog on VOX, we discussed the basic options of custom reporting, and now we’ll dive deeper into the Advanced Options.
Customers often use the Advanced Options tab when creating custom DQL Reports and DQL Templates. Advanced Options allow you to run SQLite commands to access and manipulate the DQL output database that gets created when your DQL Script executes.
To explore additional resources for SQLite functions, you can refer to the following SQLite links:
Select the Advanced Options tab after creating your custom DQL Query or the DQL Template you are using.
Once in Advanced Options, check the box beside Run SQL commands on generated DQL output database. If you select View DQL output database schema, this shows you the table your DQL Script creates and the column names.
You will notice that some of the column names may not be very user-friendly. For example, absname returns the full file path. Let’s use Advanced Options to create column names that are more intuitive for our end users. (Please note that you can also create more intuitive column names within Power BI itself.) Now let’s specify the folder location where we want our report exported.
At the bottom of my DQL template for PSTs, there is a section called Advanced SQL Queries.
The code in this script will not execute, because it is commented out, being enclosed with /* and */. We will copy the script found inside /* and */, and paste it into Advanced Options. The script within Advanced Options performs many useful tasks:
This is a simple example of how customers can use the Advanced Options feature. Other examples include:
In our next blog, we will discuss how to create a Microsoft Power BI Desktop Template and how to use it with your Data Insight reports. In the meantime, you can explore on Gartner Peer Insights why customers are calling Veritas Data Insight a "really good end-to-end analytics and risk identification tool." Veritas Data Insight was named a Gartner Peer Insights Customer Choice in the fall of 2020.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.