Enterprise Insights: Need a lookup table for Strategic Initiative ID and Values

XMLWordPrintable

      The Strategic Initiative Dropdown values used on the Theme records are created on the Administration > Settings > Platform Settings > Dropdowns: Strategic Initiatives.
      Using API it retrieves the ID for strategic but not the value.
      On the Enterprise Insights > Theme Table, there is only the column "Strategic Initiative" which is the value already resolved from the master table DBO.tblAgileMultiDD that contains both the ID and the value but is not available on the enterprise Insights.
      The ASK: The customer needs a table to look up the Values and ID for Strategic Initiative.

      Example:

      • Theme ID 1
        Strategic Initiative: Grow / Protect Base
        UI: Strategic Initiative
        API JSON schema name: strategic

             

      • The Strategic Initiative dropdown values are defined on Platform Settings
      • The ID retrieved for strategic via API /rest/align/api/2/Themes/1 refers to the value from the table tblAgileMultiDD
        "id": 1,
        "title": "Platform Instrumentation",
        "isActive": 1,
        "strategic": 112,
        "isMajor": 0,
        "state": 1,
        "description": "Track product usage through instrumentation and optimize adoption.",
        "programIds": [
          1
        ],
       
      • table tblAgileMultiDD

                 

        1. screenshot-1.png
          screenshot-1.png
          349 kB
        2. screenshot-2.png
          screenshot-2.png
          166 kB
        3. screenshot-3.png
          screenshot-3.png
          353 kB

              Assignee:
              Nathan Jones (Inactive)
              Reporter:
              Allan Silva (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: