Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

justcotto
New Contributor II

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

 

 

1 Reply
MVP & Luminary
MVP & Luminary

Re: Multiple keys for one dimension

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

- Marcus