 |
|||||
|
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
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. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| Drill down to previous hold file | Login/Join |
| Platinum Member |
I have a complex report that in the end gets summarized, and I need to make the report drillable. The data that needs to be displayed when the report is drilled on is already compiled in an earlier hold file. Since it's an FML report, using the SET EXPANDABLE is not an option. Is there someway that I can save the hold file with all of the necessary detail, reference it if the user drills down in the report, and then delete that "hold" file at some later point so it isn't saved indefinitely? Another issue I see is that more than one user may be using this report at the same time with different parameters so when they drill they would have to be able to drill into the "hold" file that was created when they ran the report initially. Any suggestions, ideas? Bethany Server Environment: Win2K3 Server WebFOCUS 7.13 Apache Tomcat standalone application server | ||
|
| Virtuoso |
This looks a bit like a datawarehouse table to me. IE: create a procedure that runs, lets say, every night, which fills this 'hold' file for you and your users. Any drill down at any time will be directed to this hold file, and it will always be up to date, no need to delete it or something like that. You could use the windows scheduler (the tasks application of Win2k) to schedule the load of the intermediate file. Hope this helps. GamP
| |||||||||
| ||||||||||
| Virtuoso |
There are several different ways to accomplish this, the most common being a technique using specific naming conventions for hold files and application directories and, as you mention, cleaning up the directories. There are numerous threads relating to saving hold files on the forum that you can find using the search utility. Regards, Darin In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat | |||
|
| Virtuoso |
Bethany, darin is right that there are a number of disucussions about this already on the forum. However, I recently posted a technique which held a PDF file that was drilled to from an HTML output. Here's the thread. you can alter it to create a HOLD file instead of a PDF. This isn't a complete solution but it will get you started. Do a search to find other solutions. Possibly Helpful Technique Thanks! Mickey
| |||||
|
| Expert |
It won't help you right now, but 7.6.5 has a FOCCACHE feature which will allow you to save the drill-to data in a temp directory and then automatically clean up after a certain amount of time. The file is only valid during the same browser process. We currently use a technique that creates a temp directory based on the Unix process id or pid. Maybe this will give you some ideas. Ginny --------------------------------- Prod: WF 7.7.01 Dev: WF 7.6.9-11 Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google | |||
|
| Expert |
Don't forget the POST capabilities with FML (EMR, FRL, what the heck) T
| |||||||||
|
| Expert |
Tony, didn't it start as SML ? Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Virtuoso |
Bethany, This is not exactly what you wanted but maybe you can use the idea: -* File bethany3.fex -DEFAULT &DRILL=NO -IF &DRILL NE NO GOTO #YES; TABLE FILE CAR SUM SALES BY COUNTRY ON TABLE SET STYLE * TYPE=DATA, COLUMN=COUNTRY, FOCEXEC=BETHANY3(DRILL=YES COUNTRY=COUNTRY),$ ENDSTYLE END -GOTO #OUT -#YES TABLE FILE CAR SUM SALES BY CAR IF COUNTRY EQ '&COUNTRY' END -#OUT Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF | |||
|
| Expert |
Warren, Yes, It started life as Small Modelling Language, then Financial ML, then Extended Matrix Reporting before becoming Financial Reporting Language. Don't ask for dates as that just causes grey hair!! I don't think I've left any out but I'm sure Gerry will correct me if I have  .T
| |||||||||
|
| Expert |
Bethany, How about writing the output file to an Application folder, set aside for the sole purpose of holding temp files? If you use a combination of date and user id variables to construct the filename, prefixed with a report identifier(?) that should enable you to target the correct file. Then set up an overnight job to remove those temporary files. I've seen this idea used to great effect in my travels. T
| |||||||||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |