It's all about the answers!

Ask a question

Cannot find table WRKTMS_SNPSHT_WC_STRNG_XT_FRM in the data warehouse

Sabrina Hippert (158) | asked Aug 07 '13, 9:25 a.m.

In BIRT reporting, we’re using a logical table name called WC_STRING_EXT_FROM. The corresponding table in dw should be WRKTMS_SNPSHT_WC_STRNG_XT_FRM but we can’t find it.

This is basically what we’re doing: 

-          For a given Workitem ID (EXTERNAL_KEY1) we retrieve all the FACT_ID (REQUEST_HISTORY_ID) from the REQUEST_HISTORY table.
-          Then for each FACT_ID we want to get the value of a custom attribute (KEY) for a given TIMESTAMP from the table

Stephanie Bagot commented Aug 08 '13, 11:49 a.m.

Is this occurring because you created this report on a previous version, and now upgraded? If so, what version are you on? Some of our DW tables have changed between versions, so this could account for the difference.

Be the first one to answer this question!

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.