Focal Point
Create a 3rd report from 2 InfoAssist Reports - Help Please

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6557062926

March 06, 2013, 11:34 AM
Christy
Create a 3rd report from 2 InfoAssist Reports - Help Please
I would like to take 2 InfoAssist reports that I have created and make a 3rd report by joining the first 2 reports. I am not sure if this is possible? Any ideas?

Also I think this may be possible if I can save the first 2 reports to access them thru the metadata but I do not have this option is this possible?


Webfocus release: 8.0.0.1
Windows, All Outputs
March 06, 2013, 03:13 PM
VLozovsky
Hi Christy and thank you for posting first message on our new InfoAssist board!

On your question, it sounds to me like you want to use the HOLD capability to do multi-step reporting. Unfortunately, that option is not available in release 8.0.0.1, but will be in 8.0.0.2.

Vicky Lozovsky
March 06, 2013, 04:53 PM
Christy
Thank you for the quick response!


Webfocus release: 8.0.0.1
Windows, All Outputs
April 03, 2013, 08:52 PM
Moogle
Hi Vicky,

Is the hold feature the same as the subquery feature? I just watched a video on subquerying in 8.0.2, and it sounds very powerful. I especially like how you can set the format to SQL, and have the entire request execute on the RDBMS.

Cheers,

Joey


-WebFOCUS 8.2.01 on Windows
April 19, 2013, 10:02 AM
noelmcavoy
I wonder, is it possible to create the HOLD file manually in WF8.0.0.1 like it is in WF7.x ?


WebFOCUS 8.1.0.5
Windows 10, all output
April 20, 2013, 10:37 PM
<MLerner>
Moogle,
Subqueries is just one usage of hold files in InfoAssist. Others include but are not limited to building a cache to create all of the components in a compound document so you hit the data source just once and reporting with different aggregation levels via hold and join.