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.
Join the TIBCO Community TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.
From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
Request access to the private WebFOCUS User Group (login required) to network with fellow members.
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.
Not sure why I'm having this problem. I have a hold file that I would like to graph to merely calculate the percent of total orders that are web based, with the 2 series' being current year and previous year. It won't even let me open in Advanced Graph. Is there something in this code that you see is causing a problem?
-SET &ECHO = ALL;
SET NODATA = 0
SET HOLDLIST=PRINTONLY
SET ASNAMES=ON
SET SHOWBLANKS = ON
SET TRACEOFF = ALL
SET TRACEON = SQLAGGR//CLIENT
SET TRACEON = SQLAGGR//CLIENT
SET TRACEUSER = ON
-RUN
DEFINE FILE SALES_CURR_PREV_FY_US
TODAY/YYMD=&YYMD;
END_DAY/YYMD=DATEADD(TODAY, 'D', -1);
PREV_TODAY/YYMD=DATEADD(END_DAY, 'Y', -1);
END_YEAR/YY=END_DAY;
END_MONTH/M=END_DAY;
BEGIN_CURR_FISC_DATE/YYMD=IF END_MONTH = 11 OR 12 THEN DATEADD(END_DAY, 'Y', 1) ELSE END_DAY;
BEGIN_CURR_CLDR_DATE/YYMD=DATEMOV(BEGIN_CURR_FISC_DATE, 'BOY');
BEGIN_CURR_FY/YYMD=DATEADD(BEGIN_CURR_CLDR_DATE, 'M', -2);
CURR_FY/YY=IF END_MONTH = 11 OR 12 THEN DATEADD(END_DAY, 'Y', 1) ELSE END_YEAR;
PREV_FY/YY=DATEADD(END_DAY, 'Y', -1);
BEGIN_PREV_FY/YYMD=DATEADD(BEGIN_CURR_FY, 'Y', -1);
ONE/I1=1;
WOE/A10=IF SALES_CURR_PREV_FY_US.SALES_CURR_PREV_FY_US.REMOTE_DATA EQ 'IX' THEN 'WOE' ELSE 'NON-WOE';
END
TABLE FILE SALES_CURR_PREV_FY_US
SUM
'CNT.DST.SALES_CURR_PREV_FY_US.SALES_CURR_PREV_FY_US.ORDER_NUM' AS 'CNT_ORDERS'
BY 'SALES_CURR_PREV_FY_US.SALES_CURR_PREV_FY_US.PRICING_BRANCH' AS 'BRANCH'
BY 'SALES_CURR_PREV_FY_US.SALES_CURR_PREV_FY_US.GL_DT_FISCAL_YEAR' AS 'FY'
BY 'SALES_CURR_PREV_FY_US.SALES_CURR_PREV_FY_US.WOE'
HEADING
""
FOOTING
""
WHERE PRICING_BRANCH NE '31' OR 'CR' OR '1' OR '36';
WHERE (( SALES_CURR_PREV_FY_US.SALES_CURR_PREV_FY_US.GL_DATE GE BEGIN_CURR_FY ) AND ( SALES_CURR_PREV_FY_US.SALES_CURR_PREV_FY_US.GL_DATE LE END_DAY )) OR (( SALES_CURR_PREV_FY_US.SALES_CURR_PREV_FY_US.GL_DATE GE BEGIN_PREV_FY ) AND ( SALES_CURR_PREV_FY_US.SALES_CURR_PREV_FY_US.GL_DATE LE PREV_TODAY));
ON TABLE SET PAGE-NUM OFF
ON TABLE SET BYDISPLAY ON
ON TABLE NOTOTAL
-*ON TABLE PCHOLD FORMAT HTML
ON TABLE HOLD AS WOEHOLD FORMAT ALPHA
ON TABLE SET HTMLCSS ON
END
DEFINE FILE WOEHOLD
ORDERS/D10.2=CNT_ORDERS;
END
TABLE FILE WOEHOLD
SUM
'RPCT.WOEHOLD.WOEHOLD.ORDERS'
BY 'WOEHOLD.WOEHOLD.BRANCH'
BY 'WOEHOLD.WOEHOLD.FY'
ACROSS 'WOEHOLD.WOEHOLD.WOE'
ON TABLE SET PAGE-NUM OFF
ON TABLE SET BYDISPLAY ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
-*ON TABLE HOLD AS WOEHOLD2 FORMAT ALPHA
ON TABLE SET HTMLCSS ON
END
Thank you!This message has been edited. Last edited by: jseaburn,
WebFOCUS 7.7.03 Linux / Universe Db HTML/PDF/EXCEL/HTML Active
How bout that..it does open in Graph assist! But, it doesn't show me my SUM or ACROSS fields to use as values.
Tom,
I did do a search in the Technical Doc on APP HOLD but it's not very clear to me. I've also read through the "Creating Reports using Graphical Tools...." book to see if there is something I am consistently missing. If you can guide me a little more on what I should be looking for, I'm more than happy to go find it.
Thank you!
WebFOCUS 7.7.03 Linux / Universe Db HTML/PDF/EXCEL/HTML Active
1. You are using the GUI tool 2. the fille you want to Graph is WOEHOLD 3. The graph will be added above/next to/under the HTML report. 4. This will be for multiple users
1. After you have completed the GUI part, EDIT the fex in text, and, at the top of the fex, add:
APP HOLD BASEAPP -RUN
APP HOLD saves the file to the Reporting Server, with the Master.
after this code:
ON TABLE HOLD AS WOEHOLD FORMAT ALPHA ON TABLE SET HTMLCSS ON END -EXIT
put a -EXIT, as above and hit the RUN button.
Now WOEHOLD wiil be availble to the Advance Graph Engine with the Master in Baseapp.
Start Graphing with a new fex. When done, save and add the Graph code under your HTML report and remove APP HOLD and -EXIT.
1 - Yes 2 - I'm actually trying to graph WOEHOLD2 because it contains the percent of total calculation that I need to graph. 3 - The graph will replace the HTML report - I was using the HTML format for testing the output, then trying to graph that. 4 - Yes
I inserted the code per your suggestion and ran it. So I'm trying to create the graph off of the WOEHOLD file and it does open for me now, but I get "no data to plot", plot points = 0 when I try to run this.
DEFINE FILE WOEHOLD
ORDERS/D10.2=CNT_ORDERS;
END
GRAPH FILE WOEHOLD
-* Created by Advanced Graph Assistant
SUM 'RPCT.WOEHOLD.WOEHOLD.ORDERS'
BY WOEHOLD.WOEHOLD.BRANCH
BY WOEHOLD.WOEHOLD.FY
WHERE WOEHOLD.WOEHOLD.WOE EQ 'WOE';
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 3
ON GRAPH SET GRAPHSTYLE *
.
.
.
WebFOCUS 7.7.03 Linux / Universe Db HTML/PDF/EXCEL/HTML Active
See changes below. Use the Graph tool to display as a % of orders instead of the Count.
Look at the Master for WOEHOLD, or, do ?FF WOHOLD -EXIT
This gives you the Fields and Formats...
quote:
DEFINE FILE WOEHOLD ORDERS/D10.2=CNT_ORDERS; END GRAPH FILE WOEHOLD -* Created by Advanced Graph Assistant SUM ORDERS BY BRANCH BY FY WHERE WOE EQ 'WOE'; ON GRAPH PCHOLD FORMAT PNG ON GRAPH SET GRAPHDEFAULT OFF ON GRAPH SET VZERO OFF ON GRAPH SET HTMLENCODE ON ON GRAPH SET HAXIS 770 ON GRAPH SET VAXIS 405 ON GRAPH SET UNITS PIXELS ON GRAPH SET LOOKGRAPH VBAR ON GRAPH SET GRMERGE ADVANCED ON GRAPH SET GRMULTIGRAPH 0 ON GRAPH SET GRLEGEND 0 ON GRAPH SET GRXAXIS 3 ON GRAPH SET GRAPHSTYLE *
Hmm - same results. So I just created a small fex to look at the data that is in WOEHOLD and it gives me zilch - 0 lines. Even though when I ran the APP HOLD and -EXIT, it told me it created about 450000+ rows. So, it seems I'm missing something else.
I appreciate your patience with me.
WebFOCUS 7.7.03 Linux / Universe Db HTML/PDF/EXCEL/HTML Active
I was able to get it working by creating a 2nd hold file and following your suggestion to create a new fex and format my graph in there. When I run it all in 1 .fex, I get results, but not when I create the graph off the WOEHOLD or WOEHOLD2 hold files from baseapp. Both give me the 0 data points error.
Thank you!
WebFOCUS 7.7.03 Linux / Universe Db HTML/PDF/EXCEL/HTML Active
Just some FYI, I learned recently that if you are using amper variables in your report that you want to build a graph off of, you have to have DM -DEFAULT(s) for each variable for Advance Graph to work. Works like a charm then. And if you want PDF output then you have to have the graph in a separate fex then the report. I think this sucks! Unless, someone has a solution to this. I would be very interested in it.
WebFOCUS Server 8.1.05 Windows 2008 Server WebFOCUS AppStudio 8.1.05 Windows 7 Professional IE 11 and Chrome Version 43.0.2357.124 m. Mostly HTML, PDF, Excel, and AHTML