topic Re: Star Schema Model in QlikView

Star Schema Model

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hey Community,

i have 2 table User & User Permission.

My goal is to create data model that based on Star Schema. i would like your help what is he best way to do so.

Concatenate, Join, Left, Right.

P.s You can see that not all user have Permission But i want them to be in my model.

Re: Star Schema Model

agni_gold — Mon, 11 Apr 2016 17:18:22 GMT

I think you should go from join here ,

tbUser

Left Join

tbuserpermission

Re: Star Schema Model

Anonymous — Mon, 11 Apr 2016 18:56:55 GMT

Hi Ben,

An star schema consist of a fact table and dimensions. Basically, a fact table contains values measured and the keys that connect to the dimensions to give meaning to that measures. On the other hand, a dimension is something like a catalog that contains attributes that describe and provide meaning to the fact.

There is another type of fact table called Factless fact table that doesn't contain any measure and are used to keep a track of relations between dimensions. For instance, if you need to track student attendance, you create a record every time a student attends a class.

Your star schema design, depends more on the business process that you're trying to model. In this case, what type of analysis do you want to perform? what data do you have available?, what is the level of granularity in your data?...the answer to this type of questions will help you to determine the design of your data model (star schema)...y recommend you to visit Kimballgroup.com for more information about techniques that you can use in your dimensional modeling design.

Regards,

-- Karla

Re: Star Schema Model

engishfaque — Tue, 12 Apr 2016 03:50:47 GMT

Dear David,

Star schema can be combination of all the functions such as you mentioned.

Please look into listed below threads,

Re: Star & snowflake schema

Kind regards,

Ishfaque Ahmed

Re: Star Schema Model

ajsjoshua — Tue, 12 Apr 2016 04:42:04 GMT

Hi,

I think this itself enough the datamodel is fine if you want you can left join the tables and make it single table.

Starschema is achieved if you hav 2 or more dimension tables,

Regards,

Joshua.

Re: Star Schema Model

Anonymous — Tue, 12 Apr 2016 05:51:52 GMT

Thank you, i do have more then 2 Dim, I just "Zoom In" in this 2 tables

Re: Star Schema Model

Anonymous — Tue, 12 Apr 2016 05:53:02 GMT

Thank you this was very helpful.

Re: Star Schema Model

Chanty4u — Tue, 12 Apr 2016 05:56:59 GMT

chk dis

Re: Qlikview on star schema

Dicas Qlik - Tonial, Fernando: Modelo de Dados no QlikView