It's all about the answers!

Ask a question

Cannot find table WRKTMS_SNPSHT_WC_STRNG_XT_FRM in the data warehouse


Sabrina Hippert (147) | 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
WRKTMS_SNPSHT_WC_STRNG_XT_FRM.


Comments
1
Stephanie Bagot commented Aug 08 '13, 11:49 a.m.
FORUM MODERATOR / JAZZ DEVELOPER

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.