Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
pic2 is the right result on accesspoint . After reload ,the result is the same as pic2.
Did you manage to solve this issue?
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