Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
justcotto
Contributor III
Contributor III

Multiple keys for one dimension

I have a few fact tables that I have concatenated.  In these tables I have multiple WIDs that join to a single dimension.  I was wondering what would be the best way to handle this situation. 

Table_NameColumn_NameCondition
WC_PURCH_RCPT_FBUSINESS_UNIT_WID W_INT_ORG_D using SCD1_WID
WC_PURCH_RCPT_FBUSINESS_UNIT_PO_WID W_INT_ORG_D using SCD1_WID
WC_PURCH_RCPT_FBUSINESS_UNIT_GL_WID W_INT_ORG_D using SCD1_WID
WC_PURCH_RCPT_FBUSINESS_UNIT_PC_WID W_INT_ORG_D using SCD1_WID
WC_PURCH_RCPT_FOPERATING_UNIT_WID W_INT_ORG_D using SCD1_WID
WC_PURCH_RCPT_FPURCH_DEPT_WID W_INT_ORG_D using SCD1_WID
WC_PURCH_RCPT_FGL_ACCOUNT_WID W_GL_ACCOUNT_D using ROW_WID
WC_PURCH_RCPT_FPROJECT_WIDW_PROJECT_D using ROW_WID
WC_PURCH_RCPT_FPURCH_LEGDER_WIDW_LEDGER_D using ROW_WID
WC_PURCH_RCPT_FPURCH_SUPPLIER_WIDW_PARTY_D using ROW_WID
WC_PURCH_RCPT_FOPERATOR_WIDWC_OPERATOR_D using ROW_WID
WC_PURCH_RCPT_FRECEIVED_ON_DT_WIDAHS_DW.W_DAY_D  using ROW_WID
WC_PURCH_RCPT_FJOURNAL_DT_WIDAHS_DW.W_DAY_D  using ROW_WID
WC_PURCH_RCPT_FACCOUNTING_DT_WIDAHS_DW.W_DAY_D  using ROW_WID
WC_PURCH_RCPT_FPURCH_ACCOUNTING_PERIOD_WIDW_MCAL_PERIOD_D using ROW_WID
WC_PURCH_RCPT_FGL_SEGMENT1_WIDW_GL_SEGMENT_D using ROW_WID
WC_PURCH_RCPT_FGL_SEGMENT2_WIDW_GL_SEGMENT_D using ROW_WID
WC_PURCH_RCPT_FGL_SEGMENT3_WIDW_GL_SEGMENT_D using ROW_WID
WC_PURCH_RCPT_FGL_SEGMENT4_WIDW_GL_SEGMENT_D using ROW_WID
WC_PURCH_RCPT_FGL_SEGMENT5_WIDW_GL_SEGMENT_D using ROW_WID
WC_PURCH_RCPT_FGL_SEGMENT6_WIDW_GL_SEGMENT_D using ROW_WID
WC_PURCH_RCPT_FGL_SEGMENT7_WIDW_GL_SEGMENT_D using ROW_WID
WC_PURCH_RCPT_FGL_SEGMENT8_WIDW_GL_SEGMENT_D using ROW_WID
WC_PURCH_RCPT_FGL_SEGMENT9_WIDW_GL_SEGMENT_D using ROW_WID
WC_PURCH_RCPT_FGL_SEGMENT10_WIDW_GL_SEGMENT_D using ROW_WID

 

 

2 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

Maybe a transforming per The-Crosstable-Load would be useful.

- Marcus

Brett_Bleess
Support (Former)
Support (Former)

Justin, did Marcus' post help you with things, or are you still trying to figure things out?  If Marcus' idea worked, please be sure to give him credit by using the Accept as Solution button on his post.  If you are still trying to figure things out, please leave an update for us.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.