Section Access- Not working in Server, works on Desktop

[#1]

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.

[#2]

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.

[kaushiknsolanki]

Dear Jayram,

     Have a look at the link below.

     This will solve your problem.

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

Regards,

Kaushik Solanki