Hi,
I have a data model that combined daily data and trend data (the same data but collected over time as snapshot).
when im loading the data model it's showing the correct data.
but, when i add the security part, it's showing wrong numbers.
i dont find the reason for that (i thought its because the field "SITE_DESCRIPTION" in the key, so i pull him out of the key but still the data is wrong.
this is the code:
//----------------------Security----------------------//
[QlikSecurity]:
LOAD 'CODE1\'&GROUP_MEMBER_ID as USERID,
ACCESS_TYPE as ACCESS,
ACCESIBLE_SITE_CODE as SITE_CODE;
SELECT "GROUP_MEMBER_ID",
"ACCESS_TYPE",
"ACCESIBLE_SITE_CODE"
FROM ADM.scr."USER_PERMISSIONS";
Section Access;
load ACCESS,USERID
resident [QlikSecurity];
Section Application;
STAR IS *;
load USERID,SITE_CODE
resident [QlikSecurity];
drop table [QlikSecurity];
//----------------------End Security----------------------//
[DAILY_MANAGEMENT]:
LOAD BUSINESS_GROUP&BUSINESS_SECTION&BUSINESS_UNIT&PROCESS_OWNER&PRODUCT_FAMILY&ASSEMBLY_TYPE&ACTIVE_BOM_ITEM&Vendor_Full_Name&VENDOR_TYPE&RECORD_TYPE&SIMPLIFIED_PROCESS_STATUS_NAME&PROCESS_ON_TRACK&IMPLEMENTATION_INDICATOR&[KPI Rescheduling Status] as key,
RECORD_ID,
Item_Full_ID,
header_id,
item_id,
SAP_OBJECT_TYPE,
RECORD_TYPE,
SAP_Order_Type,
SITE_CODE,
If(IsNull(SITE_DESCRIPTION),'No Site',SITE_DESCRIPTION) as SITE_DESCRIPTION,
plant_code,
Plant_Full_Name,
Storage_Location_Code,
Storage_Location_Full_Name;
SELECT "RECORD_ID",
"Item_Full_ID",
"header_id",
"item_id",
"SAP_OBJECT_TYPE",
"RECORD_TYPE",
"SAP_Order_Type",
"SITE_CODE",
"SITE_DESCRIPTION",
"plant_code",
"Plant_Full_Name",
"Storage_Location_Code",
"Storage_Location_Full_Name"
FROM VWS."prc_bsc_pkg"."DAILY_MANAGEMENT";
LOAD
BUSINESS_GROUP&BUSINESS_SECTION&BUSINESS_UNIT&PROCESS_OWNER&PRODUCT_FAMILY&ASSEMBLY_TYPE&ACTIVE_BOM_ITEM&Vendor_Full_Name&VENDOR_TYPE&RECORD_TYPE&SIMPLIFIED_PROCESS_STATUS_NAME&PROCESS_ON_TRACK&IMPLEMENTATION_INDICATOR&[KPI Rescheduling Status] as key,
PO_Value AS Trend_PO_Value,
Material_Value AS Trend_Material_Value,
Line_Count AS Trend_Line_Count,
KPI_STATUS as Trend_KPI_STATUS,
SITE_DESCRIPTION as Trend_Site_Description,
YEAR_WEEK
FROM [lib://daily_management_trend.qvd]
(qvd);
do you have any clue what could be the problem?
