How can one extract dimension values from an ESG Program?
I've set up dimensions in an ESG Program, for example:
Having saved these, when I query on ESG Program data (such as through a connection to a Factbook), I want to be able to show the Dimension value name. However, a query with this program as its source has only a "Dimensions" field whose values are in this form:
Dimension name : Value ID
E.g.:
In other words, the Value Name does not seem to appear in the program at all. I was thinking this is probably stored in another table and I could join on it, but I can't find anything in Wdata that seems to store this.
How/where can I access the dimension value names?
-
Official comment
With Workiva's ESG solution, Query now includes the Program dimension data source. You can read more about it in Support Center: https://support.workiva.com/hc/en-us/articles/7604055021332-Include-ESG-Program-data-in-query-results
Hi Andrew McKenzie
There is a new Program source table out there for Program Dimensions.
This currently isn't available yet but we'll give it a week for testing and then plan for production release Monday the 28th.0
Comments
3 comments