How to add lookup to the datawarehouse

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

We created two statics lookups

TEST_INVEST_PROB
TEST_INVEST_PRIO

How could we add those lookups to the datawarehouse?

Environment

Release : 16.0.2

Component : Clarity Data Warehouse

Resolution

Normally, what you will do is to create attributes that are based on those lookups. 
The attributes can be marked/checked to be included in the datawarehouse. Then, when the export (load datawarehouse job) is done, those attributes are exported to the datawarehouse.

The lookup table created on the DWH is named as :
DWH_LKP_<LOOKUP_ID>

On this example, the tables would be:

DWH_LKP_TEST_INVEST_PROB
DWH_LKP_TEST_INVEST_PRIO