Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

DD & section access problem

I use DD and section access. I find one problem .

the DD script:

DIRECT QUERY

   dimension

    KEY_IOD

//    key_gof,

//    key_stock

   measure

    ActualQty

   detach

    SizeName

//    NATIVE('cast(SizeName  as varchar(20))') as SizeName 

   detail

    UpdateDate

FROM TestData.dbo."Inv_Material";

My section access is related to KEY_IOD and no relation with SizeName.  

    I open the file in IE client like accesspont . It is ok.

    I open directly in computer . The SizeName disappear as the pic1. If I reload it ,it is ok .

I know the section access cause this problem . How to solve it  ?

3 Replies
Not applicable
Author

pic2 is the right result on accesspoint .  After reload ,the result is the same  as pic2. 

Not applicable
Author

Did you manage to solve this issue?

Anonymous
Not applicable
Author

DD works with SectionAccess on AccessPoint only. You have to develope without SectionAccess and test with SectionAccess on AccessPoint.

Direct Discovery Technical Addendum_11.2_SR11_and_Sense.pdf

3.7 Unsupported QlikView and Qlik Sense Functionality

Set Analysis

More than one calculated dimension in a direct discovery chart

Direct Discovery Measure and Detail fields are not supported on Global Search

Client side section access and data reduction

Loop and Reduce

Synthetic keys on the direct discovery table