Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

siddharth_kulka
Contributor II

Section access to unlinked fact tables

Hi Folks.

Data model consists of 2 unlinked fact tables (Call Reports and Financials) which are not meant to be linked as Call reports has nothing to do with financials and vice versa. Also - there is no key field that can be used to link both these tables. We have 2 separate tabs in the UI qvw. Thats that.

Call Reports:

ROLE  Calls

A          10

B          50

C          40

Financials:

Fund AUM NNA Rev

A        200   10     10

B        150    20     30

Requirement:

1. Row level reduction (Call Reports)

Call Reports fact table has a field ROLE'''based on which data reduction needs to be applied using section access for 100+ users. So far so good

2. Column level reduction (Financials)

Financials fact table has 3 fields (Aum, NNA, Revenue) that should be visible to only 10 out of the 100 users of the app. For the other 90 users, the field should either blank out, show an error or a dash or whatever is possible. In normal circumstances, this can be achieved using the keyword "OMIT" in section access. Row level data reduction is out of scope and not required for this fact table and on the UI.

3. The solution needs to be back end (script) driven, I don't want to handle Requirement 2 using show hide or conditional formatting on the UI considering scalibility, as there is a chance of more users requesting access + need to apply the restriction on more fields in the future (currently 3).

Can section access be used considering the 2 tables are unlinked?

Cheers!

Regards,

Sid

2 Replies
Highlighted
siddharth_kulka
Contributor II

Re: Section access to unlinked fact tables

Wanted to add:

The app is currently live with req 1 already implemented using section access (NTNAME used for authorization).We receive a spreadsheet from the business with fields - NTNAME, ROLE.

Would it be possible to accommodate Requirement 2 ideally by extending the existing section access set up?

MVP
MVP

Re: Section access to unlinked fact tables



Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, ROLE, FUND, OMIT

USER, DUMMY, 0, A, ,

USER, DUMMY, 0, B, ,   

USER, DUMMY, 0, , AA,

USER, DUMMY, 0, , BB,

USER, U1, 1, A,

USER, U1, 1, B,

USER, U1, 1, ,*

USER, U2, 2, B,

USER, U2, 2, , *, AUM

USER, U2, 2, , *, NNA

USER, U2, 2, , *, REV 

];

Section Application;

CallReports:

load * inline [

ROLE,  Calls

A    ,      10

B     ,     50

C      ,    40

];

Financials:

load * inline [

FUND, AUM, NNA, REV

AA    ,    200,   10,     10

BB     ,   150 ,   20,     30

];

User U1 reduced on ROLE, all fields visible in Financials table

1 U1.png

User U2 reduced on ROLE, only FUND field visble in Financials table

U2.png