Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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];
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.
Hi Susann,
Is this issue resolved?
Cheers,
DV
www.QlikShare.com
Hi Deepak,
no it's not. It's still an issue.
Best regards
Susann
Have a look at this post: hierarchy-authorization