As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
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_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;
TABLE FILE SALES_POS_LN_NONPII_BV
SALES_POS_LN_NONPII_BV.SALES_POS_LN_VW.UNITS_SOLD AS 'Units Sold'
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'
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
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 *
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
-IF &LINES NE 0 THEN GOTO :SKIPERROR;
This message has been edited. Last edited by: tomatosauce,
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.
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
Posts: 2128 | Location: Customer Support | Registered: April 12, 2005
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?
WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010 : Member of User Group Benelux :