Wave Analytics SAQL, XMD 2.0, and dataset Row-Level Security
In this section, we will briefly discuss Salesforce Analytics Query Language (SAQL) used in lenses and dashboards, and how one can use XMD 2.0 to customize and enhance the dashboards. At the end of this section, we will cover how one can add Row-Level security to the Analytics Cloud dataset.
Salesforce Analytics Query Language
We have seen the creation of lenses and dashboards. Behind the scenes, these use Salesforce Analytics Query Language for aggregating, filtering, grouping, ordering, and other operations. We will not cover the introduction to this language and how to debug it; for an in-depth understanding, it is recommended to refer to the official documentation (https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_saql.meta/bi_dev_guide_saql/bi_saql_intro.htm).
For the lens we created in the Creating a lens from dataset section, the SAQL can be easily obtained by enabling Show SAQL. Consider the following screenshot...
