topic Re: Dimension Missing in Access Point in QlikView

Dimension Missing in Access Point

andyquirin — Mon, 26 Jan 2015 14:13:32 GMT

Hi All,

Thank you in advance for your help.

We're having an issue with a dashboard that has one Pivot Table Chart with three dimensions (Sales Mgr, Sales Rep, and Month) and several expressions. The pivot table has the first two dimensions on the y axis (as rows) and Month pivoted out on top (on the x-axis) as columns. Strangely, there are many users to the report, and a small minority of them do not see the Month dimension when they open the dashboard (and then see inflated / distorted expression results).

Other things to note:

Section Access is implemented, but is not restricting on the Month field
- We've testing people with the same section access where one person sees the issue and one doesn't
There are no conditions to enable the dimension (it always is enabled)
Locally, all the fields appear normal (even with users who saw the issue in the access point)
We have multiple access points (test, prod, etc). The same user was able to see the issue in one access point, but see it correctly in the other access points with the same version of the files and a reload time that was only 20 min difference

Any ideas what to troubleshoot on what may be causing this?

Thanks,

Andy

Re: Dimension Missing in Access Point

alexandros17 — Mon, 26 Jan 2015 14:15:19 GMT

Is there the last IE Plugin installed on the computer with the issue?

Re: Dimension Missing in Access Point

andyquirin — Mon, 26 Jan 2015 22:09:39 GMT

Hi Alessandro,

Good thought. I'll sync up with the end user to see if it's a browser or Plug-in issue and report back.

Andy

Re: Dimension Missing in Access Point

rwunderlich — Tue, 27 Jan 2015 00:05:03 GMT

There were a couple bugs like that fixed in SR7. What SR are you using?

-Rob

Re: Dimension Missing in Access Point

andyquirin — Tue, 03 Mar 2015 17:19:44 GMT

Hi Rob,

We just updated from SR9 to SR10. I ended up deleting the object and rebuilding it, and it seems to have solved the issue.

Thanks for your help.

Andy