Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Section Access - How to prevent data been reduced/deleted from a hierarchy table

Hi everybody,

my situation is the following:

I have several reference/dimension tables with texts in my datamodel. These texts are often a part of a hierarchy and have no connection to the data table itself, just some of the values.

When I now use section access within the document, the mechanism also reduces the reference table with the texts and my hierarchy does not fully exists anymore.

How can I prevent the data reduction on the dimension/hierarchy tables?

star is *;

section access;

LOAD * Inline [

ACCESS,USERID,PASSWORD,COLUMN1

admin,admin,admin,1

];

section Application;

H1:

Hierarchy(Code,ParentCode, Text,,Text,Tree)

load * inline [

Code, ParentCode, Text

ALL,,ALLE TEXTE

A,ALL,TEXT_A

B,ALL,TEXT_B

C,ALL,TEXT_C

D,ALL,TEXT_D

Aa,A,TEXT_Aa];

Data:

load * inline [

COLUMN1,COLUMN2,Code

1,1,Aa

1,2,B

1,3,C];

4 Replies
stantrolav
Not applicable

Re: Section Access - How to prevent data been reduced/deleted from a hierarchy table

How this thing (in your sample) connected with section access? In your example 1 user ADMIN can see all the data from tables. I don't see any reducing.

IAMDV
Not applicable

Re: Section Access - How to prevent data been reduced/deleted from a hierarchy table

Hi Susann,

Is this issue resolved?

Cheers,

DV

www.QlikShare.com

Not applicable

Re: Section Access - How to prevent data been reduced/deleted from a hierarchy table

Hi Deepak,

no it's not. It's still an issue.

Best regards

Susann

tresesco
Not applicable

Re: Section Access - How to prevent data been reduced/deleted from a hierarchy table

Have a look at this post: hierarchy-authorization