Hi there.
We have a problem when we execute a query ad hoc from BEx designer 7.
The url has not the template value.
The URL generated is:
http://server:50000/irj/servlet/prt/portal/prtroot/pcd!3aportal_content!2fcom.sap.pct!2fplatform_add_ons!2fcom.sap.ip.bi!2fiViews!2fcom.sap.ip.bi.bex?QUERY=0BBP_SC_Q001&VARIABLE_SCREEN=X&DUMMY=1
The correct url must be:
http://server:50000/irj/servlet/prt/portal/prtroot/pcd!3aportal_content!2fcom.sap.pct!2fplatform_add_ons!2fcom.sap.ip.bi!2fiViews!2fcom.sap.ip.bi.bex?QUERY=0BBP_SC_Q001&VARIABLE_SCREEN=X&TEMPLATE=0ANALYSIS_PATTERN&DUMMY=1
As you can see the system can not solve the patter of template.
We assigned the template in transaction RSCUSTV27 (SPRO/SAP NETweaver/BI/Setting for reporting and analysis/BEx Web/Set standar web template) as Ad Hoc Analysis.
Any suggest?
Thanks and regards.