Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Cannot find table WRKTMS_SNPSHT_WC_STRNG_XT_FRM in the data warehouse

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.

0 votes

Comments

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.

1 vote


Be the first one to answer this question!

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,019

Question asked: Aug 07 '13, 9:25 a.m.

Question was seen: 3,933 times

Last updated: Aug 08 '13, 11:49 a.m.

Confirmation Cancel Confirm