We need to add one custom attribute based on lookup with dynamic query to data warehouse, but I still got following message:
The below attributes could not be included in the Data Warehouse. If the attribute is lookup, query is not DWH compatible.
I found here this thread CA PPM Tech Tip: Including Dynamic Query Lookup Attributes in the Data Warehouse
So I added column LAST_UPDATED_DATE, but still the same problem.
Here is my query:
select@SELECT:l.lookup_code:lookup_code@,@SELECT:nls.name:lookup_value@,@SELECT:l.LOOKUP_ENUM:LOOKUP_ENUM@,@SELECT:SYSDATE:LAST_UPDATED_DATE@from cmn_lookups lleft join cmn_captions_nls nls on l.id=nls.pk_idleft join odf_ca_c_proces_map map on map.c_proces_map_pr=l.lookup_codewhere l.lookup_type='C_L_PROCES' and nls.language_code='en'and nls.table_name='CMN_LOOKUPS'and (case when @WHERE:PARAM:USER_DEF:STRING:inv_type@ is null then '***' else upper(@WHERE:PARAM:USER_DEF:STRING:inv_type@) end = nvl(c_pp_proc_inv_typ,'***')andcase when @WHERE:PARAM:USER_DEF:STRING:projekt_type@ is null then 'aaaaa' else @WHERE:PARAM:USER_DEF:STRING:projekt_type@ end = nvl(c_proces_map_pt,'aaaaa'))and map.c_pp_proc=1and @FILTER@order by l.LOOKUP_ENUM
Any ideas how to solve this?
Thank you all in advance,
Hi msnizek ,
You need to add language code and language id as well. After adding these two in you select cloumn it should work fine.
thank you, it works now.