Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I kindly need your help on this issue. I am new to QlikSense and BI in general but I am willing to learn. I have modeled a Star Schema DWH for a case study. I have created several Dimensions tables connected to a Fact table using the Kimball methodology of Surrogate keys in Dimension tables associated to Foreign key in the fact table.
All looks good within SQL Management Studio where a couple of sql queries are giving the expected result. I have loaded all my tables into QlikSense and generated the script. I selected the associations between tables fields according to my star schema model (in this Qlik advise with a red status when checking if data matches).
The result is a schema with dotted red lines for each association between Dimension Tables and the Fact Table. Why is that? Most important how can I fix this?
I need really to pass through this bottleneck as the case study deadline is for this Sunday :-(. I spent a lot of time and energy in modeling the schema, creating tables and going through a lot of SSIS manipulation. I am sure this is not a big deal but just my poor knowledge of QlikSense.
Many thanks in advance and stay safe home 🙂
Rick