Skip to main content

Scalability

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER 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
Employee
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
Employee
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
MVP
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