Issue with reduction in section access

[#1]

binary load blah blah blah;

section access;

LOAD

* INLINE [

    ACCESS, NTNAME, "Sale Year"
    ADMIN, domain1\user1, 2008
    USER, domain1\user2, 2009
    USER, domain2\user1, 2010
    USER, domain2\user2,
];

Section Application;
LOAD * INLINE [
"Sale Year"
2009
2010
2011
2012
2013
];

I want to reduced based on a Sale Year which is the column in the data model. This doesn't work at all... Either from the desktop or from the access point. Can you kindly help? domain2\user2 should have access to all years, but the other users need to be set up as seen here.

[tresesco]

all the year values have to be there in the section access. try like this:

Section Access;

LOAD

* INLINE [

    ACCESS, NTNAME, "Sale Year"
    ADMIN, domain1\user1, 2008
    USER, domain1\user2, 2009
    USER, domain2\user1, 2010
    USER, domain2\user2, 2008

    USER, domain2\user2, 2009

    USER, domain2\user2, 2010

    USER, domain2\user2, 2011

    USER, domain2\user2, 2012

    USER, domain2\user2, 2013

];

Section Application;
LOAD * INLINE [
"Sale Year"
2009
2010
2011
2012
2013
];

[#3]

Hi,

Make sure, the field "Sales Year" is exists in your data model ( which is in your binary load). Also, Put the check mark for the option Document Properties -> Opening -> "Initial Data Reduciton Based on Section Access".

[#4]

Yes, it exists and i have done the set up in the Opening tab as well. Still no luck.

[#5]

Hi,

I have a small doubt from your Section Access: How come user1 have both ADMIN and USER as ACCESS types?

Ok, when you have logged in to your application by USER1 then how the applicaiton can treat you, whether you are ADMIN or USER?

[tresesco]

we are missing one basic:

Everything under section access has to be in CAPITAL letters.

[#7]

actually it is a typo, different users in different domains. apologies.

[#8]

why? my osuser() returns domain name in caps and user name in lowercase.

[#9]

Hi,

Is it possible to attach your application?

[tresesco]

Though, this does not apply to INLINE data, but if you are loading via an external data source, must be loaded in upper case.