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

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

Tue, 26 Feb 2013 13:29:57 GMT

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];

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

stantrolav — Tue, 22 Apr 2014 08:38:56 GMT

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.

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

IAMDV — Wed, 30 Apr 2014 10:11:57 GMT

Hi Susann,

Is this issue resolved?

Cheers,

www.QlikShare.com

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

Fri, 04 Jul 2014 07:54:34 GMT

Hi Deepak,

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

Best regards

Susann

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

tresB — Fri, 04 Jul 2014 07:58:52 GMT

Have a look at this post: hierarchy-authorization