Focal Point
[CLOSED] Drill Down Graph

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

June 24, 2013, 02:16 PM
ebalboa
[CLOSED] Drill Down Graph
I'm trying to create a graph with drill down capabilities in WF8. I am not having any luck. Is there any place where I can look for a starting point?

This message has been edited. Last edited by: <Kathryn Henning>,


WebFOCUS 8.0.02
Windows, All Outputs
June 24, 2013, 02:26 PM
Prarie
Welcome to the forum.

Were you able to do this in 7.6 - but not in 8?
June 24, 2013, 02:27 PM
ebalboa
I am new to WF and starting on 8.


WebFOCUS 8.0.02
Windows, All Outputs
June 24, 2013, 05:46 PM
Waz
What a place to start.

Not everyone is on 8, you may have to talk to Techsupport if you don't get an answer here.

Can you post the code ? or a repro with the CAR file or something.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

June 24, 2013, 05:50 PM
Doug
New to WebFOCUS also?
June 25, 2013, 11:45 AM
ebalboa
Yes, also new to WebFOCUS.

My drill down is now working using this code.

TYPE=DATA,
ACROSSCOLUMN=N1,
TARGET='_BLANK',
FOCEXEC=/Manager_Projects_Bar.fex ( \
PROJECT_MANAGER=N1 \
),$

However, now my graph tool is crashing on this graph only. I believe editing the code is the cause. Any suggestions?


WebFOCUS 8.0.02
Windows, All Outputs
June 25, 2013, 12:17 PM
J
correct syntax:
 
TYPE=ACROSSVALUE,
     ACROSS=1,
     TARGET='_blank',
     FOCEXEC=Manager_Projects_Bar( \
     PROJECT_MANAGER=A1 \
     ),
$
 


If that doesn't work, something else is causing it to crash.

This message has been edited. Last edited by: J,


WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs
June 25, 2013, 12:31 PM
ebalboa
quote:
ACROSSVALUE

It isn't liking the ACROSSVALUE. The drilldown is not working now. I am not able to click on any segment of the chart.


WebFOCUS 8.0.02
Windows, All Outputs
June 25, 2013, 12:37 PM
J
Remove your drilldown and try to create it through the GUI.

I am not sure exactly what you are trying to do but there is ACROSSTITLE as well.


WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs
June 25, 2013, 12:40 PM
ebalboa
Where do I look to find the drill down option in the GUI? The reason I had changed the code was because I could not find a place to do it in the GUI.


WebFOCUS 8.0.02
Windows, All Outputs
June 25, 2013, 12:48 PM
J
When you add a field, look in the box at the bottom of the window. The display tab is selected. There is a button there labeled "Drill down..."

I guess the question is whether you are using graph assist or advanced graph assist.


WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs
June 25, 2013, 12:55 PM
J
I guess your graph syntax was correct. Are you doing advanced graph assist or graph assist? MRE or data servers?
-Try to reproduce with the CAR masterfile and see if you are getting the same error.
-If you are, post your code (between [ CODE ] [ /CODE ] Tags by clicking on the
 </> 
button


WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs
June 25, 2013, 02:41 PM
ebalboa
Neither, WF8 uses InfoAssist and I can't seem to find a drill down function anywhere on here.


WebFOCUS 8.0.02
Windows, All Outputs
June 25, 2013, 02:48 PM
Prarie
Looks like we are going to have a Version 8 learning curve here... Music
June 25, 2013, 02:48 PM
J
Oh... can you update your signature to include WF8? I can't help you then.
If that doesn't work in 8... Sweating


WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs
June 25, 2013, 03:03 PM
ebalboa
Just noticed it was set wrong. Thanks for your help. I'll keep looking


WebFOCUS 8.0.02
Windows, All Outputs
June 26, 2013, 09:02 AM
Alex
To create a drill down click on any measure field in your graph, then on the ribbon menu click on Hyperlink. You can define your drill down there.


WF 7.7.04, WF 8.0.7, Win7, Win8, Linux, UNIX, Excel, PDF
June 26, 2013, 03:47 PM
ebalboa
Thanks. I got it working using the Hyperlink tool. Do you know where I can look to add a function to drill back up to the parent.


WebFOCUS 8.0.02
Windows, All Outputs
June 26, 2013, 03:57 PM
Alex
You should be able to just use the back button on the browser to get back to the parent or target a new page and keep the parent up in the original window.


WF 7.7.04, WF 8.0.7, Win7, Win8, Linux, UNIX, Excel, PDF
June 26, 2013, 04:09 PM
J
Of course if its IE (at least IE 9), there is a twist. The user may need to hold the back button down and select the third option from the top (two "histories" ago).


WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs