Section Access

[#1]

Team

    I am having one inline table called

Category

load *

[

  Human

  Animal

  insect

];

I am having set of users who can view animal and Insect  data, another set of user who can view only Human and Insect and another set of user who can view human, animal and insect.

I am showing the category in the list box at the top of the report

my section access table is

user id, password,viewuser

admin,admin,*

H,H,Human    (This particular user restricted to view Animal and Insect related date)

A,A,Animal   ( this particular user restricted to view Human and Insect related data)

Can any only help me how to do this

Kindly help me at the implementation part.

[ziadm]

Hi Section Access; LOAD * INLINE [     ACCESS, USERID, PASSWORD, NTNAME,ANIMAL     ADMIN, ADMIN, *, *,*     USER, USER1, *, *,Animal     USER, USER2, *, *,Insect     USER, USER2,*,*,Animal ]; USER1 will only access Animal data USER2 will access Animal & Insect ADMIN will access all Data Make sure that security section all in upper case ANIMAL is your dimension also has to be upper case ANIMAL field has to be in Upper case in your Fact Table Hope this help Thanks Ziad

[ziadm]

Sorry I had to post again because of the editor format problem

Hi

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, NTNAME,ANIMAL

    ADMIN, ADMIN, *, *,*

    USER, USER1, *, *,Animals

    USER, USER2, *, *,Insects

    USER, USER2, *, *,Animals

];

Application Section;

// This is where your fact table goes

USER1 will only access Animal data USER2 will access Animal & Insect ADMIN will access all Data Make sure that security section all in upper case ANIMAL is your dimension also has to be upper case ANIMAL field has to be in Upper case in your Fact Table Hope this help

Thanks Ziad

[PrashantSangle]

Hi,

Try below Session Access

Section Access;

LOAD * INLINE [

    ACCESS,NTNAME,CATEGORY

    ADMIN,ADMIN,

    USER,H,HUMAN

    USER,A,ANIMAL  

];

Section Application;

Category

load *

[

  CATEGORY

  HUMAN

  ANIMAL

  INSECT

];

Regards

[#5]

I am sorry, on thing I forgotten

I want the data in the same  list box  ie Category

if the H User log in Category list box should have only  animal and Insect

if the A user log in the Category  list box should have only  Insect and Human...

list box name is category

[#6]

and the values are not as inline this is coming from the database

[PrashantSangle]

Hi,

Remove that Inline table.

It will work.

For session acces you have to do several setting also

Like in Document Property -> Opening -> Select Initial Data Reduction Based on Section Access.

Regards

[jagan]

Hi,

Check this sample script

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, REDUCTION

    ADMIN, Admin, *

    USER, Sales, 1

    USER, Market,2

];

Section Application;

star is *;

Departments:

LOAD * INLINE [

   REDUCTION, Dept,

    1, Sales

    2, Marketing];

Sales:

LOAD * INLINE [

   Dept, Sales

   Sales, 100

   Sales, 200

   Sales, 4646

   Sales, 755

   Sales, 422

   Sales, 42

   Marketing, 2

   Marketing, 453

   Marketing, 54

   Marketing, 45

];

When you login as Admin, you can see all data in the dashboard, when you login as Sales then you can see only Sales data and when you login as Market you can see only Marketing data.

Note: You need to select Document Properties -> Opening tab -> and select Initial Data Reduction based on Section Access option

Hope this helps you.

Regards,

Jagan.

[#9]

i tried all the way around with your ideas but not working.

[#10]

Jagan

   I got the idea from the same example what you posted. but not working