Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Best Practices in designing Data Model?

Hi All,

My question is regarding Data Model .

1.What are the best practices in Designing and Optimizing the Data Model in Qlikview?

2. How multiple users can access the qvw files from server?

Thanks!

5 Replies
hic
Former Employee
Former Employee

About level of normalization of the data model, see

http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/12/to-join-or-not-to-join

The proper way to publish a qvw to several users is to publish it on a QlikView server. Then, the users can connect to the server and get a session that properly handles security for multiple users.

HIC

Not applicable
Author

Thanks Henric.

You mean that after connecting to the server, users can put in their Username and Password to acess the files.

hic
Former Employee
Former Employee

Correct. But a better solution from a security perspective is to use the Windows integrated security, e.g. by using NTNAME in Section Access.

HIC

Not applicable
Author

Yes. NTNAME will definately enhance the security.

Thanks for your reply.

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi there,

I put my thoughts on data model best practices in a blog post a while back:

http://www.quickintelligence.co.uk/perfect-your-qlikview-data-model/

Hope you find it useful.

Steve