Dear All,
please help me out.
I have a problem at my dashboard(submitted business), a list box named Agent code at top left corner is not connecting with all sheet objects.
Please identify what am I doing wrong at script.
Attached is the screen shots.
Below is table script :
[connection string]
LAAG_AGENT:
LOAD
"AAG_AGCODE" as AgentCode,
"AAG_NAME" as AgentName,
"PCL_LOCATCODE" as Branch,
"AAG_AGCODE";
SQL SELECT AAG_AGCODE,
AAG_NAME,PCL_LOCATCODE,AAG_AGCODE
FROM "FQADRI"."LAAG_AGENT";
PCL_COMPLOCATION:
LOAD
"PCL_LOCATCODE" as Branch,
"PCL_LOCATDESC",
"PCL_BRANCHACTIVE";
SQL SELECT PCL_LOCATCODE,
PCL_LOCATDESC,
PCL_BRANCHACTIVE FROM
"ASIF_IQBAL"."PCL_COMPLOCATION";
LMMI_MIS_FINAL:
LOAD
ISSUED,
SUBMITTED,
"POLICYNO",
"MMI_TRANTYPE",
"PRODUCT",
"AAG_AGCODE" AS AgentCode,
"AGENT_NAME",
"SC_CODE",
"SC_NAME",
"EBDM_CODE",
"EBDM_NAME",
"UM_CODE",
"UM_NAME",
"ABM_CODE",
"ABM_NAME",
"BM_CODE",
"BM_NAME",
"SBM_CODE",
"SBM_NAME",
"GM_CODE",
"GM_NAME",
"RM_CODE",
"RM_NAME",
"SD_CODE",
"SD_NAME",
"TILL_DATE" as Date;
SQL SELECT *
FROM "ASIF_IQBAL"."LMMI_MIS_FINAL";
[ connection string ]
LAAG_AGENT:
LOAD "AAG_AGCODE" as AgentCode,
"CDG_DESIGCODE";
SQL SELECT "AAG_AGCODE",
"CDG_DESIGCODE"
FROM ILASSNAP."LAAG_AGENT";
LCDG_DESIGNATION:
LOAD "CDG_DESIGCODE",
"CDG_DESCRIPTION",
"CDG_SHORT";
SQL SELECT *
FROM ILASSNAP."LCDG_DESIGNATION";
