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?
-
Offizieller Kommentar
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
Thanks Isaac Oard and we'll look forward to this.
0Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.
Kommentare
3 Kommentare