Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
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
Partner
Partner

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.

Luminary
Luminary

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

MVP
MVP

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

Have a look at this post: hierarchy-authorization