Hi All,

I am having a Dashboard which creates a bunch of Hold Files. When Tested in DEV 8105 i believe that they are being created in Foccahe. We recently upgraded our TEST from 8009 to 8105 and promoted the Dashboard package over there.

Now all the hold files are being created in baseapp in TEST. Now this might be a problem moving on for multiple users. Is there something we are missing over here? Like a Mapping to Foccahe in Admin Console ? or do i have to append the the path to FOCCACHE every time?

 

ENGINE INT CACHE SET ON


-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='405.0';
-DEFAULTH &WF_STYLE_WIDTH='770.0';

-DEFAULTH &WF_TITLE='WebFOCUS Report';

DEFINE FILE SALES_POS_LN_NONPII_BV
DEPT/A40V=SALES_POS_LN_NONPII_BV.MSTR_GL_DEPARTMENT_DIMENSION.GL_DEPT_ID || '-' || SALES_POS_LN_NONPII_BV.MSTR_GL_DEPARTMENT_DIMENSION.GL_DEPT_DESC;
ACTIVITY/A2=EDIT( SALES_POS_LN_NONPII_BV.SALES_POS_LN_VW.ACTIVITY_HOUR,'99$');
END

TABLE FILE SALES_POS_LN_NONPII_BV
SUM
     SALES_POS_LN_NONPII_BV.SALES_POS_LN_VW.UNITS_SOLD AS 'Units Sold'
     SALES_POS_LN_NONPII_BV.SALES_POS_LN_VW.EXTENDED_AMT
     SALES_POS_LN_NONPII_BV.SALES_POS_LN_VW.SELLING_UNIT
BY TOTAL HIGHEST 30 SALES_POS_LN_NONPII_BV.SALES_POS_LN_VW.EXTENDED_AMT NOPRINT
BY  SALES_POS_LN_NONPII_BV.MSTR_ITEM_DIMENSION.ITEM_SCAN_CD_ID AS 'UPC/PLU'
BY  SALES_POS_LN_NONPII_BV.MSTR_ITEM_DIMENSION.ITEM_DESC
WHERE ( SALES_POS_LN_NONPII_BV.MSTR_DATE_DIMENSION.CAL_DATE EQ '&CAL_DATE.(FIND SALES_POS_LN_NONPII_BV.MSTR_DATE_DIMENSION.CAL_DATE IN SALES_POS_LN_NONPII_BV).CAL_DATE:.' );
WHERE SALES_POS_LN_NONPII_BV.MSTR_LOCATION_DIMENSION.STORE_NUM EQ &STORE_NUM.(OR(FIND SALES_POS_LN_NONPII_BV.MSTR_LOCATION_DIMENSION.STORE_NUM,SALES_POS_LN_NONPII_BV.MSTR_LOCATION_DIMENSION.STORE_NUM IN SALES_POS_LN_NONPII_BV)).STORE_NUM:.;
WHERE SALES_POS_LN_NONPII_BV.MSTR_POS_DEPARTMENT_DIMENSION.POS_DEPT_SALES_DEPT_FL EQ 'Y';
WHERE SALES_POS_LN_NONPII_BV.MSTR_TRANSACTION_TYPE_DIMENSION.CUST_TX_FL EQ 'Y';
WHERE SALES_POS_LN_NONPII_BV.MSTR_GL_DEPARTMENT_DIMENSION.GL_BIZ_UNIT_ID EQ '011';
WHERE SALES_POS_LN_NONPII_BV.MSTR_GL_DEPARTMENT_DIMENSION.GL_ORG_UNIT_ID EQ '000';
WHERE SALES_POS_LN_NONPII_BV.MSTR_POS_ITEM_TYPE_DIMENSION.POS_ITEM_TYPE_NET_SALE_INC_FL EQ 'Y';
WHERE SALES_POS_LN_NONPII_BV.MSTR_GL_DEPARTMENT_DIMENSION.GL_DEPT_ID NE '09' OR '13';
WHERE SALES_POS_LN_NONPII_BV.SALES_POS_LN_VW.UNITS_SOLD GT 0.00;
ON TABLE HOLD AS HLD01
END

GRAPH FILE HLD01
-* Created by Info Assist for Graph
SUM HLD01.HLD01.EXTENDED_AMT AS 'Net Sales'
BY HIGHEST HLD01.HLD01.EXTENDED_AMT NOPRINT
BY HLD01.HLD01.ITEM_DESC AS 'UPC/PLU'
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET ARGRAPHENGIN JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET GRWIDTH 1
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET GRMERGE ON
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT

setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);

*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/combine_templates/ENWarm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
setLegendPosition(1);
setLegendPosition(1);
setTextString(getX1Title(),"Item Desc");
setDisplay(getX1Title(),true);
setTextString(getY1Title(),"Net Sales");
setDisplay(getY1Title(),true);
setDataTextPosition(1);
setDisplay(getDataText(),false);
setDataTextDisplay(false);
setTextRotation(getO1Label(),3);
setLabelStagger(getO1Label(),false);
setFillColor(getSeries(0),new Color(83,172,205));

*END
*GRAPH_JS
"introAnimation": {
    "enabled": true
}
,

*END
ENDSTYLE
END

-RUN

-IF &LINES NE 0 THEN GOTO :SKIPERROR;
-HTMLFORM IBFS:/WFC/Repository/Dashboard_Analytics/HTML/nodata.htm
-:SKIPERROR


 

This message has been edited. Last edited by: tomatosauce,

Hi Tharun

By default all hold files are created in the edatemp directory under the tsxxxxxx folder for the agent used during the request. The APP HOLD command overrides this behavior. You may have a profile fex that has the setting APP HOLD baseapp in it. There are several places this may be. On the WebFOCUS client under the administration console in the Client Settings / General area there is a _site_profile setting where a -INCLUDE is used. on the Reporting Server check the edasprof.prf (Server profile). The other place this may be coded is directly in the fex you are executing but I don't see that in your code.

I think you mean the HOLD-files were being created as temporary files in EDATEMP. FOCCACHE is different from that, it holds files belonging to the same session, which can span a bunch of procedures called by the same user from the same browser.

As for your issue, you probably have APP HOLD BASEAPP somewhere. Perhaps a line like that is in a server profile?

Thanks Chuck and Wep5622.

I found out APP HOLD BASEAPP in our server profile. Commenting it out made everything back to normal again.