Roberto Trevino Posted August 3, 2022 Share Posted August 3, 2022 I know you can make a chart using the 'Home Page' InfoAssist tool. However, it does not let me use an App Studio made fex reportWhat steps do I need to follow to be able to use the fex report and generate a chart from it? Link to comment Share on other sites More sharing options...
David Beagan Posted August 4, 2022 Share Posted August 4, 2022 In general I don't think there is a way to do this, although your specific release of WebFOCUS and what you have in your fex are factors. App Studio's Report Canvas tool has more features than InfoAssist report creator. Testing this in version 9.0.0, Infoassist appears to keep track of what fexes were created in InfoAssist and only allows those to be edited in InfoAssist. It seems like it would be simplest just to recreate it in InfoAssist. Link to comment Share on other sites More sharing options...
Roberto Trevino Posted August 4, 2022 Author Share Posted August 4, 2022 Ok.That is what i thoughtI was able to sort of get it to work with an App Studio fex report.I opened the fex report in the text editor.I then changed the PCHOLD to a HOLD: (where the report normally sends the final table/hold)ON TABLE HOLD AS {HOLDNAME} FORMAT FOCUSand then I added a blank unconfigured graph after it.GRAPH FILE {HOLDNAME}END-EXITI saved it then closed it and opened it in the App Studio GUI.It opens and then it opens a new browser window with INFOASSIST and it lets me configure the graph.There are few issues though.You have to make sure all the master files exist in the repository the fex report was from. Also The more complex the app studio fex is (ie. multiple joins and holds used) the slower INFOASSIST runs in working with the graph.ex. each time you make a change it processes the fex again just like when it was first opened (you can speed this up a little bit by disabling the sample report display and only work in the query mode)I can still do the design of the graph thru the text editor and then run it to display it. Link to comment Share on other sites More sharing options...
Dirk Kuerbig Posted August 22, 2022 Share Posted August 22, 2022 Hello Roberto,here is an approach that may work for you, at least it is an alternative that may work in some situations:WebFOCUS has a session semi-permanent HOLD area called FOCCACHE . It is a logical application folder that is available for the current browser / development session.Idea and sample below:Step 1Use your report logic with Join, HOLD, ... Save the HOLD file not to the server temp directory (which gets deleted after the report is done) , but FOCCACHE insteadYou will still have your private session, so other users do not overwrite your fileE.g. HOLD AS FOCCACHE/ROBERTO1 FORMAT FOCUSStep 2Before you do anything in InfoAssist, run this main report onceThis will generate your temporary data file in the FOCCACHE directory Step 3Open InfoAssist to generate, use FOCCACHE/ROBERTO1 as source and design / change your chart any way you wantSave as standalone procedure, e.g. AM_Infoassist.fexStep 4(one time) add a -INCLUDE statement (or use App Studio to INCLUDE a referenced procedure) to link toAM_Infoassist.fex from step 3This way, whenever you design or make changes in InfoAssist, you will have consistent performance, since InfoAssist is only going against your HOLD filePlease note: This will also allow you to use the new WebFOCUS DESIGNER tool as well as the chart modification toolPlease keep in mind. Since this is semi-permanent per browser/ user session, you will need to consider unique HOLD file names if you have more than 1 visualization you want to display on a screenBelow you will find a working sampleGood luck, and let me know if you have questions.am_chart_main.fexTABLE FILE CARSUM SALES BY COUNTRY BY CAR BY MODELON TABLE HOLD AS FOCCACHE/ROBERTO1 FORMAT FOCUSEND-RUN-INCLUDE IBFS:/WFC/Repository/IBUG_Fall_2020/Community/amchart_infoassist.fexamchart_infoassist.fexENGINE INT CACHE SET ONSET PAGE-NUM=NOLEAD-DEFAULTH &WF_HTMLENCODE=ON;SET HTMLENCODE=&WF_HTMLENCODESET ARGRAPHENGINE=JSCHART-DEFAULTH &WF_EMPTYREPORT=ON;SET EMPTYREPORT=&WF_EMPTYREPORTSET EMBEDHEADING=ONSET GRAPHDEFAULT=OFF-DEFAULTH &WF_ARVERSION=2;SET ARVERSION=&WF_ARVERSION-DEFAULTH &WF_STYLE_UNITS='PIXELS';-DEFAULTH &WF_STYLE_HEIGHT='405.0';-DEFAULTH &WF_STYLE_WIDTH='770.0';-DEFAULTH &WF_TITLE='WebFOCUS Report';GRAPH FILE foccache/roberto1-* Created by Info Assist for GraphSUM ROBERTO1.SEG01.SALESBY ROBERTO1.SEG01.CARON GRAPH PCHOLD FORMAT JSCHARTON GRAPH SET VZERO OFFON GRAPH SET UNITS &WF_STYLE_UNITSON GRAPH SET HAXIS &WF_STYLE_WIDTHON GRAPH SET VAXIS &WF_STYLE_HEIGHTON GRAPH SET LOOKGRAPH BARON GRAPH SET AUTOFIT ONON GRAPH SET STYLE **GRAPH_SCRIPTsetPieDepth(0);setPieTilt(0);setDepthRadius(0); setCurveFitEquationDisplay(false); setPlace(true); *ENDINCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, ORIENTATION=LANDSCAPE, $TYPE=DATA, COLUMN=N1, BUCKET=x-axis, $TYPE=DATA, COLUMN=N2, BUCKET=y-axis, $*GRAPH_SCRIPTsetReportParsingErrors(false);setSelectionEnableMove(false);*ENDENDSTYLEEND-RUN Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now