-
-
Re: What are ERP data model in Qlikview and how many types of the data model can use in Qlikview?
Bob Mu Sep 15, 2016 8:29 PM (in response to Praveena Velagapudi )Well, Praveena.
Thanks for your respond.
Expect Star & Snow flake schema, have any other schema or other Data model available?
Can you explain what is ERP data model in Qlikview?
-
-
Re: What are ERP data model in Qlikview and how many types of the data model can use in Qlikview?
Jayaseelan K Sep 16, 2016 1:55 AM (in response to Bob Mu)Hi,
Please refer following link will gives you some ideas.
Thanks,
-
Re: What are ERP data model in Qlikview and how many types of the data model can use in Qlikview?
Bob Mu Sep 16, 2016 12:45 PM (in response to Jayaseelan K)Dear Jayaseelan,
Wonderful PDF about ERP, hope it helps for me to know more about ERP.
I appreciate your quick response.
-
-
Re: What are ERP data model in Qlikview and how many types of the data model can use in Qlikview?
Marcus Sommer Sep 16, 2016 2:37 AM (in response to Bob Mu)In my opinion there is no need to think about ERP datastructures within qlik which are mainly based on relational databases with normalized data. In qlik you will usually use only a very small part from the ERP system and datastructures are rather de-normalized and works best with a star-schema - whereby it's quite common to have some kind of mixed model-schema.
- Marcus
-
Re: What are ERP data model in Qlikview and how many types of the data model can use in Qlikview?
Bob Mu Sep 16, 2016 12:41 PM (in response to Marcus Sommer )Dear Marcus,
I agree but some projects start with only ERP data, for that scenario - which kind of data will be in ERP?
In an interview, I faced this question and I answered for that but the interviewer was expected more information about ERP data model and what kind of data will be available in ERP.
-
Re: What are ERP data model in Qlikview and how many types of the data model can use in Qlikview?
Marcus Sommer Sep 16, 2016 1:20 PM (in response to Bob Mu)I think this couldn't be answered in general. There are too many different ones. Maybe it's useful to start here: Enterprise resource planning - Wikipedia, the free encyclopedia.
- Marcus
-
-
-
Re: What are ERP data model in Qlikview and how many types of the data model can use in Qlikview?
Filip Duchateau Sep 16, 2016 5:09 AM (in response to Bob Mu)Hi,
My suggestion is to strive for the star schema, because it give best performance.
And, like Marcus wrote, do not think in terms of relational databases. Rather think in terms of associations.