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     Generating dynamic Pie charts and Simple reports

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Generating dynamic Pie charts and Simple reports
 Login/Join
 
<Sengott>
posted
I am new to the Web focus tool. I need to generate a report with the following format. A main pie chart drawn for all the severity found for all the platforms in my database. (I have used the severity name in the x and y axis to plot the graph). Then sub graphs showing the severities for each particular platform. The count of the sub graphs depends on the count of the platforms available. Similar to the main pie, I have plotted the sub graphs with severity in the x and y axis and plotting the platform name in the across axis. This part of the report is done. Now I want simple reports (tabular) below the pie charts to be generated with the few selected field corresponding to each platform. As of now I have created three separate procedures for each platform (say Oracle, SQL, UDB by filtering it through the where clause for each procedure) and have imported all the procedures in one html layout. All I want to know is is their any means by which I can pass the platform name dynamic to the procedure. That is like say, I have 'n' platforms I get 'n' no of sub pie graphs by just giving the platform name in the across axis. Similarly will I get tabular reports corresponding to these 'n' platform? Can this be done through a procedure in a simple report? I have just shown a fragment of the code that is taken from one of the tabular Report Procedure. Here ASGN_GRP_I corresponds to the Platform ID

WHERE ( NEWDATE GE '&STRT_TIME.START DATE.' ) AND ( NEWDATE LE '&END_TIME.END DATE.' ) AND ( ASGN_GRP_I EQ 12238 );
 
Report This Post
Member
posted Hide Post
quote:
All I want to know is is their any means by which I can pass the platform name dynamic to the procedure. That is like say, I have 'n' platforms I get 'n' no of sub pie graphs by just giving the platform name in the across axis. Similarly will I get tabular reports corresponding to these 'n' platform? Can this be done through a procedure in a simple report? I have just shown a fragment of the code that is taken from one of the tabular Report Procedure. Here ASGN_GRP_I corresponds to the Platform ID

WHERE ( NEWDATE GE '&STRT_TIME.START DATE.' ) AND ( NEWDATE LE '&END_TIME.END DATE.' ) AND ( ASGN_GRP_I EQ 12238 );


You're asking for two things, and I'm not sure which you want. You say you "get 'n' no of sub pie graphs by just giving the platform name in the across axis. Can this be done through a procedure in a simple report?". But you start off by saying "All I want to know is is their any means by which I can pass the platform name dynamic to the procedure".

Both options are available.

To get several TABLES, with a 'separate' TABLE for each of a set of values (in your case Platform ID), you should add a sort for the field (BY ASGN_GRP_I), and specify the PAGE-BREAK option.

Or, if you want to pass that value to your request, code it as you do for start and end time. Your selection would look like:

ASGN_GRP_I EQ &PLATFORM_ID.ASGN_GRP_I.

The variable asked for is &PLATFORM_ID; the prompt (in this example) is ASGN_GRP_I.
 
Posts: 25 | Location: 2 Penn Plaza 28 fl | Registered: March 27, 2003Report 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     Generating dynamic Pie charts and Simple reports

Copyright © 1996-2020 Information Builders