2 Replies Latest reply: Jun 11, 2013 12:57 PM by Isaac Oliva RSS

Section Access/Distribution Issue

Amit Deshpande

Hello,

Now, this is something that I have never encountered before. It just started occurring over the weekend

I have a Section Access Script that looks like this:

 

Section Access;

LOAD
text(USERID) as USERID,
     TEXT(PASSWORD) as PASSWORD,
     'MSWBH\' & text(NTNAME) as NTNAME,
     LASTNAME,
     FIRSTNAME,
        IF(LEN(TRIM(ACCESS)) > 0,'ADMIN','USER') AS ACCESS,
    TEXT(GROUP) as  GROUP,
    text(OMIT) AS OMIT
FROM
[..\..\..\Security.xlsx]
(ooxml, embedded labels, table is Sheet1);


Section Application;


Directory;
LOAD TEXT(GROUP) AS GROUP,
     ACCESS
FROM
[..\..\..\Security.xlsx]
(ooxml, embedded labels, table is Sheet2);

 

The Group Info is as follows:

GROUPACCESS
GROUP10
GROUP21

 

I use the group setup to hide certain fields from users from Group 1 that are included in the OMIT field.

In the app, I also hide certain charts by adding the condition "sum(ACCESS) >= 1" which means that only those users that belong to GROUP2 can view those charts. We use Publisher to distribute the documents. So, after I reload the publish the document, the app in the Source document looks accurate. It assigns the correct group to the correct user. ( I tested that by giving myself restricted access and I observed that I could see one row in the group table that had GROUP 1 AND 0).

However, when I look at it from Accesspoint, I see that everything that should be hidden is still visible. I also see in the table viewer that the group info has been reversed, i.e. GROUP 2 AND 1. That is the reason why the objects are not hidden, even though data reduction takes place successfully

I am clueless as to why the Publisher would change this on the fly.

Any thoughts?