Formula to return the hyperlink address for BI drilldown query from VC.

[former_member182616]

Hello VC Experts,

I am new to BI & VC world.

"http://zonedsx.cone.bombardier.com:8046/sap/bw/BEx?sap-language=EN&CMD=LDOC&INFOCUBE=ZTMM50&QUERY=ZD_T01_ZTMM50_Q003&VARIABLE_SCREEN=&DUMMY=1sap-language=EN&VAR_NAME_1=0I_DAYIN&VAR_VALUE_LOW_EXT_1=DSTR(STORE@DateFrom,'MMDDYYYY') &VAR_VALUE_HIGH_EXT_1=DSTR(STORE@DateTo,'MMDDYYYY') &VAR_OPERATOR_2=BT&VAR_VALUE_LOW_EXT_2=STORE@PlantFromChart&VAR_VALUE_EXT_2=FR01&VAR_NAME_2=0S_PLANT&VAR_OPERATOR_2=EQ&"

When I try to add above mentioned URL into formula box, it doesn't compile. Please help me to know what is wrong & how can I achieve the solution?

Thanks,

MD

[Former Member · Accepted solution]

Hi,

here's the corrected version, you need to terminate the strings before using the functions (such as DSTR) or variables (such as STORE@PlantFromChart)

"http://zonedsx.cone.bombardier.com:8046/sap/bw/BEx?sap-language=EN&CMD=LDOC&INFOCUBE=ZTMM50&QUERY=ZD_T01_ZTMM50_Q003&VARIABLE_SCREEN=&DUMMY=1sap-language=EN&VAR_NAME_1=0I_DAYIN&VAR_VALUE_LOW_EXT_1=" & DSTR(STORE@DateFrom,'MMDDYYYY') &"&VAR_VALUE_HIGH_EXT_1=" & DSTR(STORE@DateTo,'MMDDYYYY') &" &VAR_OPERATOR_2=BT&VAR_VALUE_LOW_EXT_2= " & STORE@PlantFromChart&"&VAR_VALUE_EXT_2=FR01&VAR_NAME_2=0S_PLANT&VAR_OPERATOR_2=EQ"