topic Re: Some Dimension not display by different users in QlikView

Some Dimension not display by different users

Anonymous — Wed, 08 Oct 2014 06:45:10 GMT

I have met a inexplicable problem.I creat a pivot table with dimension Rigion、Province、Hospital_Class、Hospital_Type and Hospital_Name,but when I access the BI system by A user(A is a name cal user),the dimension Hospital_Class and Hospital_Type are not display,Then I change another user B(B is also a name cal user) to access,it becomes OK,all dimensions are displayed normally,

I don't know why,who can do me a favour,thanks!

Re: Some Dimension not display by different users

tresB — Wed, 08 Oct 2014 06:47:13 GMT

Is section access there? Because, the similar behavior can be produced using section access.

Re: Some Dimension not display by different users

maleksafa — Wed, 08 Oct 2014 06:48:44 GMT

have you checked if you have any conditional expression on the dimension filtering on OSUser() which is the User logging into the system? do you have section access applied on the document? maybe user A have a clone and is not working on the original chart?

Re: Some Dimension not display by different users

Anonymous — Wed, 08 Oct 2014 07:02:14 GMT

no user A and B have the same authority,and not several values of field Hospital_Class can't display but the field Hospital_Class can't display

Maxxie.Shi

13764026073

Re: Some Dimension not display by different users

Anonymous — Wed, 08 Oct 2014 07:06:26 GMT

Sorry, what do you mean 'user A have a clone' and how to deal with it?Thanks

Maxxie.Shi

13764026073

Re: Some Dimension not display by different users

tresB — Wed, 08 Oct 2014 07:08:06 GMT

There is a section access system field called OMIT used to hide entire field (not its values) from a specific user.

Re: Some Dimension not display by different users

Anonymous — Wed, 08 Oct 2014 07:16:02 GMT

Oh Sorry forgive me,I understand you,But I have not use the OMIT for any User.

Maxxie.Shi

13764026073

Re: Some Dimension not display by different users

tresB — Wed, 08 Oct 2014 07:19:21 GMT

Are you using publisher? Is any reduction being done?

Re: Some Dimension not display by different users

maleksafa — Wed, 08 Oct 2014 07:21:48 GMT

from the access point the user can select any chart right click on it and clone, then he will be able to modify this chart and remove the dimensions.

Re: Some Dimension not display by different users

Anonymous — Wed, 08 Oct 2014 07:36:44 GMT

No,I have not used publisher,When I change the QVW name,This problem will be solved,so this problem is relate to the RAM?(In production environment,I can't change the QVW name,so it is not a doable method)

Re: Some Dimension not display by different users

Anonymous — Wed, 08 Oct 2014 07:42:24 GMT

well thanks for your explaination and I understand what you means,but it is just original chart have this problem and no user to clone it,When I change the QVW name,This problem will be solved,so this problem is relate to the RAM?(In production environment,I can't change the QVW name,so it is not a doable method)

Re: Some Dimension not display by different users

tresB — Wed, 08 Oct 2014 08:37:17 GMT

I would try few things like:

Ask the user to clear cache
Remove the user from user list and dealloacte CAL; reallocate CAL and add back to user list
Restart the qv services

If anything works.

Re: Some Dimension not display by different users

Anonymous — Wed, 08 Oct 2014 09:00:26 GMT

Thanks,I will have a try,But you said 'clear cache',do you mean deleting the Server Objects in QMC as below：

Re: Some Dimension not display by different users

vinay_hg — Wed, 08 Oct 2014 09:04:00 GMT

please restart web services & qlikview server services. this will resolve the issue if it is not a section access issue.

Re: Some Dimension not display by different users

Anonymous — Thu, 09 Oct 2014 01:43:21 GMT

Thanks,I have tried to restart web services & qlikview server services,but no useful