Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

About Qlikview Licenses - Difference between Named user CAL and document CAL

Hi Support,

I have not bought the software yet but need deeper understanding on some topics.Say I have 3 documents in the access point . Say ,I have implemented security so that a particular user can see only 2 documents that he is supposed to see from the access point. Now if the user can at a time open both documents from the access point, can he do this only if he has named user CAL ? If he can open only one document from the access point at a time then he will be holding only document CAL right ?He can open the other document only after closing the first one right? So can I conclude that a named user CAL provides more flexibility for the user ? On the other hand from the memory utilization point of view , if the user has named user CAL the probability of memory consumption will be higher right since he can open multiple documents at the same time and hence more memory consumed?

So my conclusion based on the above interpretation would be that

1) To control memory utilization , I should go for document CAL license.

2) To provide flexibility to user, I should go for named user CAL license.

Please connect me if I am wrong.

Regards

Manoj

13 Replies
Not applicable
Author

Thank you Big Smile

Mónica

Anonymous
Not applicable
Author

Never read this before. It seems absurd for a few reasons.

1) What if you use metadata to drive out measures? We have hundreds of measures in our document and we use a unrelated table to store the names of these measures, thresholds (for turning them green, yellow and red) and formulas for their calciulation. We also use meta data for security and these two sets of metadata are "isolated" islands i guess.

2) Another huge problem with this limitation is many to many relationships. By proper design you need to have a junction or bridge table between such dimensions. THis will break their cardinatlity descreases as you move away from fact table rule.

3) Finally, QV does not work well with proper "enterprise" DW with conformed dimensions. Take a simple example where you have two fact tables each joined to a conformed time dimension -> FactA, FactB and Time. Lets also say that only Facta is linked to a product dimension. If you choose a product it will filter out data from FactA. It will also filter out Time dimension members that have no data associated with the product you chose. Now here's the key. This will also filter out Time members associated with "real" fact that you will have in FactB. This is really a tough one for me. QV uses an inner join type of filter for this and unfortunately the really cool 'associative' model breaks down with enterprise conformed dimensional model. The solution is data island. Isolate your fact tables. THis is going back to a data mart silo approach but at least you data will be correct.

Not applicable
Author

I found this document online, which explains the difference between the 4 type of CAL (Named, Document, Session and Usage). You can even find few scenario.

http://community.qlik.com/groups/nhs_user_group/media/p/103189.aspx

fashid
Specialist
Specialist

Thanks a LOTT!!