topic Section Access- Not working in Server, works on Desktop in QlikView

Section Access- Not working in Server, works on Desktop

Wed, 06 Mar 2013 23:16:24 GMT

Hi All

I have an application, with 4 tabs. Users can get access to tabs1 through 4

determined by my section access script. The problem is, it works on my

desktop, but fails while loading in server(Failed to open document, file

not found error). I can see the application in the server thumbnails, but

when clicked, I dont see it. A few things I tried already:

1. Initial data Reduction based on SectionAccess - Checked

2. Strict Exclusion - Checked

This is the settings for which it works at my desktop.

If I tried unchecking Strict Exclusion, I see all tabs.

If I tried Initial Selection based on Section Access, I see my NTID in the

current selection, which I dont want to display.

I am not using '*' or "All" in my excel sheet. I am not loading Inline as

the list is long.

Here is my script.

Section Access;

LOAD upper(ROLE) as ACCESS,

upper(NTNAME) as NTNAME

from

(ooxml, embedded labels,table is section_access);

Section Application;

Load upper(NTNAME) as NTNAME,

SHEET1,

SHEET2,

SHEET3,

SHEET4

from

(ooxml, embedded labels,table is section_access);

Here is my excel file contents(I am typing since I dont have ms office

installed. This is not an inline load. Just my excel contents )

ROLE NTNAME SHEET1 SHEET2 SHEET3 SHEET4

ADMIN DOM\ABC1234 1 1 1 0

ADMIN DOM\DEF3424 0 1 1 0

So, User ABC1234 can see tabs 1,2,3. User DEF3424 can see tabs 2,3.

But, right now, nobody except the Admin person reloading the application on

the server can see the application.

Thanks in advance.

Re: Section Access- Not working in Server, works on Desktop

Thu, 07 Mar 2013 22:36:23 GMT

You do not have any data reduction fields defined in section access. There a couples ways to use the current fields and and create a data reduction fields.

Option 1: Use NTNAME as the reduction field

Section Access;

LOAD

upper(ROLE) as ACCESS,

upper(NTNAME) as NTNAME,

upper(NTNAME) as SHEET_USER,

from

file;

Section Application;

Load

upper(NTNAME) as SHEET_USER,

SHEET1,

SHEET2,

SHEET3,

SHEET4

from

file;

Option 2: use sheet fields as data reduction fields

Section Access;

LOAD

upper(ROLE) as ACCESS,

upper(NTNAME) as NTNAME,

SHEET1,

SHEET2,

SHEET3,

SHEET4

from

file;

Section Application;

Load

SHEET1,

SHEET2,

SHEET3,

SHEET4

from

file;

Personally, I would create group reduction field and assign both sheets and users to groups. That would make change any of the sheet access rules much easier.

Re: Section Access- Not working in Server, works on Desktop

kaushiknsolanki — Fri, 08 Mar 2013 07:33:06 GMT

Dear Jayram,

Have a look at the link below.

This will solve your problem.

http://community.qlik.com/thread/32321

Regards,

Kaushik Solanki