Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello
i am a beginner.
i have some fact tables and some dimensions that are shared between these facts.for example i have an inventory fact and a sales fact that they have date,product and ... dimensions in common.
as i load one of them with all of its dimension there is no problem, but when i try just one of the measures of two fact table with just one dimension in common, the speed decreases to zero and makes me to restart the computer. i know ram capacity is important but how much? i want to know if there is any point about construction of tables or their shared dimensions that should be applied?
thanks
mana
This document will give you a good starting point for how you should be structuring your data model to optimise performance with Qlik View or Sense.
Please Go through this post Re: Performace of Qlikview on a new server
Vikas
Also try to install this QlikView Application: System Monitor v5.1.20
This document will give you a good starting point for how you should be structuring your data model to optimise performance with Qlik View or Sense.
sorry that i was absent here. i am going to study the file you have sent me.
thanks