Star Schema

[yusra]

Hi, I am new to QlikSense. I have been assigned a task to create a star Schema. I have created tables with data in them and tables are loaded in Qlik Sense. I have generated their QVD too.

Now I have to create their Star Schema. Fact Table include:

ProductID

RegionID

TimeID

SupplierID

Quantity

DefectPercentage

Other Tables are Product, Time Dimension, Supplier Dimension, Region Dimension. These are dimension tables.

Kindly tell me how to create star schema using the QVD.

[AdiPai]

Hey Y ! 

I suggest to go through the basic video as below -

https://www.youtube.com/watch?v=YZnTxAHT3ok

Should be straight forward . 

Cheers ! 

[yusra]

I have seen this before. But I want the Script that saves the Star Schema.

[Vegar · Accepted solution]

If you need to store your star data model into qvd then I suggest that you store the fact table in one qvd and each of the attached dimension tables into their own qvd file.  

To store a data table into qvd use the store command

STORE YourTable INTO YourDestinationPath (qvd)