[CLOSED]Is it possible? Drill down to report in CONTENT from EDASERVE?
We have a report under EDASERVE that has a drill down and we want to move the drill down report to Content section of BI Portal, to leverage the BI Portal security (only BI Portal users should see the drill down). Is this possible? My current call looks like this: FOCEXEC=folder1/tracking_report_drill( \ Policy_State=Policy_State \ )
Thanks!This message has been edited. Last edited by: DWaybright,
WebFOCUS 8.2.03 (production), 8.2.06 (testing) AppStudio, InfoAssist Windows, All Outputs
January 16, 2018, 02:19 AM
Chaudhary
There are several ways of taking care of this, here's one: using with JAVASCRIPT function,
-* File: IBFS:/localhost/EDA/EDASERVE/APPPATH/demo/Procedure1.fex Created by WebFOCUS AppStudio
TABLE FILE CAR
SUM
SALES
BY COUNTRY
BY MODEL
ON TABLE NOTOTAL
ON TABLE HOLD FORMAT HTMTABLE AS SOURCE
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
TYPE=DATA,
COLUMN=N1,
JAVASCRIPT=contentRun('IBFS:/WFC/Repository/Public&|BIP_item=Chart1.fex' 'COUNTRY' N1 'MODEL' MODEL 'SALES' SALES),
$
ENDSTYLE
END
-RUN
-HTMLFORM BEGIN
<html>
<head>
<script language="JavaScript">
function contentRun()
{
urlSelf = '/ibi_apps/run.bip?BIP_REQUEST_TYPE=BIP_RUN&|BIP_folder=' + arguments[0]+'&|IBI_random='+Math.random();
for (var i=1; i < arguments.length; i=i+2)
{
urlSelf += '&' + arguments[i] + '=' + arguments[i+1];
}
window.location = urlSelf;
}
</script>
</head>
<body>
!IBI.FIL.SOURCE;
</body>
</html>
-HTMLFORM END
This message has been edited. Last edited by: Chaudhary,
Chaudhary, Thank you! Now I get an Access to Item Denied error. I'm not sure why that would be since I created and published the fex I'm trying to run unless it has to do with security surrounding running javascripts.
Thanks!
WebFOCUS 8.2.03 (production), 8.2.06 (testing) AppStudio, InfoAssist Windows, All Outputs
January 17, 2018, 10:47 AM
Frans
copy the hyperlink, check if it matches the path and of your .fex.
TABLE FILE ibisamp/ggsales
SUM UNITS
BY REGION
ON TABLE SET STYLE *
TYPE=DATA, URL=/ibi_apps/WFServlet?( \
IBIF_webapp='/ibi_apps' \
IBIC_server='EDASERVE' \
IBIMR_drill='IBFS,RUNFEX,IBIF_ex,true' \
IBIF_ex='IBFS:/WFC/Repository/Public/Chart1.fex' \
REGION=REGION \
),$
ENDSTYLE
END