Focal Point Banner


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.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Drill Down Graph

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Drill Down Graph
 Login/Join
 
ebalboa
Member
posted
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
 
Posts: 10 | Registered: June 24, 2013Report This Post
Prarie
Virtuoso
posted Hide Post
Welcome to the forum.

Were you able to do this in 7.6 - but not in 8?
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
ebalboa
Member
posted Hide Post
I am new to WF and starting on 8.


WebFOCUS 8.0.02
Windows, All Outputs
 
Posts: 10 | Registered: June 24, 2013Report This Post
Waz
Expert
posted Hide Post
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!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Doug
Expert
posted Hide Post
New to WebFOCUS also?
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
ebalboa
Member
posted Hide Post
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
 
Posts: 10 | Registered: June 24, 2013Report This Post
J
Guru
posted Hide Post
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
 
Posts: 402 | Location: Upland, IN | Registered: June 08, 2012Report This Post
ebalboa
Member
posted Hide Post
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
 
Posts: 10 | Registered: June 24, 2013Report This Post
J
Guru
posted Hide Post
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
 
Posts: 402 | Location: Upland, IN | Registered: June 08, 2012Report This Post
ebalboa
Member
posted Hide Post
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
 
Posts: 10 | Registered: June 24, 2013Report This Post
J
Guru
posted Hide Post
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
 
Posts: 402 | Location: Upland, IN | Registered: June 08, 2012Report This Post
J
Guru
posted Hide Post
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
 
Posts: 402 | Location: Upland, IN | Registered: June 08, 2012Report This Post
ebalboa
Member
posted Hide Post
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
 
Posts: 10 | Registered: June 24, 2013Report This Post
Prarie
Virtuoso
posted Hide Post
Looks like we are going to have a Version 8 learning curve here... Music
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
J
Guru
posted Hide Post
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
 
Posts: 402 | Location: Upland, IN | Registered: June 08, 2012Report This Post
ebalboa
Member
posted Hide Post
Just noticed it was set wrong. Thanks for your help. I'll keep looking


WebFOCUS 8.0.02
Windows, All Outputs
 
Posts: 10 | Registered: June 24, 2013Report This Post
Alex
Platinum Member
posted Hide Post
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
 
Posts: 175 | Location: Pomona, NY | Registered: August 06, 2003Report This Post
ebalboa
Member
posted Hide Post
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
 
Posts: 10 | Registered: June 24, 2013Report This Post
Alex
Platinum Member
posted Hide Post
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
 
Posts: 175 | Location: Pomona, NY | Registered: August 06, 2003Report This Post
J
Guru
posted Hide Post
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
 
Posts: 402 | Location: Upland, IN | Registered: June 08, 2012Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Drill Down Graph

Copyright © 1996-2020 Information Builders