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     [SOLVED] Creating a row based on multiple row values

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Creating a row based on multiple row values
 Login/Join
 
<AM>
posted
I am very new to WF and I have a sql report that I have created using all SQL- meaning Sum, Open PPms, Weekly Average and Total columns were created within the SQL statement.

Example:
PPM Data - Weekly

Date Ending AIX Linux SecurityOps Dev Solaris File and Print VMWare Windows Grand Total
03/28/2009 286 113 133 801 29 157 330 1849
04/04/2009 258 207 112 857 130 95 447 2106
04/11/2009 247 224 68 679 126 83 305 1732
04/18/2009 189 342 181 652 83 95 257 1799
04/25/2009 275 308 178 628 111 133 316 1949
05/02/2009 336 234 133 730 75 159 283 1950
05/09/2009 312 186 32 564 102 139 170 1505
05/16/2009 149 307 159 896 59 196 470 2236
05/23/2009 323 198 140 832 94 185 195 1967
05/30/2009 222 140 98 669 82 162 503 1876
Sum 2597 2259 1234 7308 891 1404 3276 18969
Open PPMs 1570 1188 422 1653 79 348 1914 7174
Weekly Average 260 226 123 731 89 140 328 1897
---NEW ROW INSERTED HERE

I need to calculate a row for Backlog which needs to be the 'Open PPMs' row / 'Weekly Average' row and I am not familiar enough with the syntax yet, I am not sure what I need to do to accomplish this tasks. Any and all help is greatly appreciated.

This message has been edited. Last edited by: Kerry,
 
Report This Post
Virtuoso
posted Hide Post
Are you wanting help with SQL or with FOCUS?


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
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Expert
posted Hide Post
That's a good point Darin. The "NEW ROW INSERTED HERE" is SQL... Of course WebFOCUS (Maintain or MODIFY) can do that. So, knamc, where is your WebFOCUS Question?
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
<JG>
posted
In WebFOCUS terms RECAP and SUBFOOT
 
Report This Post
<AM>
posted
I need help in WebFocus, can you send me a sample of the RECAP, SUBFOOT code that I use as a guide? Thank you
 
Report This Post
<AM>
posted
quote:
Originally posted by Doug:
That's a good point Darin. The "NEW ROW INSERTED HERE" is SQL... Of course WebFOCUS (Maintain or MODIFY) can do that. So, knamc, where is your WebFOCUS Question?


THe "NEW ROW HERE...." is what I want to achieve in WebFOCUS
 
Report This Post
<JG>
posted
RECAP SUBFOOT

It's all in the online help for dev studio.

Consultancy rates available on request.

It's a help forum not a do the work for you forum,
At least until you have made some sort of attempt.
 
Report This Post
<AM>
posted
I have created a statement:

RECAP BACKLOGVAL/D6.1= R12 / R13;
AS 'Backlog'

But I an getting error message that it can not parse it, should the rows be explicitly defined, instead of the defaults?

There will always be 10 rows of detail, sum, openppm, average which will be fixed number of rows (13), I want to create a 14th row for Backlog.
 
Report This Post
Virtuoso
posted Hide Post
You don't help yourself by biting the hand that feeds you.

JG gave you what you need to know. If you go into the help in Dev Studio (not the forum) and look up the RECAP or SUBFOOT statements in the index, there are examples of the code. No need for others to re-invent. This information is also in the "Creating Reports" manual.

Once you look through the sample ocde, try a few things, and let us know what you've tried and what your additional questions are, we go from there.


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
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Expert
posted Hide Post
JG and Darin: You make very good points... "HELP NE DO"

As far as the "THe 'NEW ROW HERE....' is what I want to achieve in WebFOCUS"... a "NEW ROW" normally implies a new row in a DB which is avaiable via MAINTAIN or, do I dare say, MODIFY. However, if it's just a new row in a report, check out the RECAP as JG stated.
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
<AM>
posted
Now that you have made each other all warm & fuzzy.

I am happy to report that I found what I needed from the online documentation, Thank you, JG.

My problem was that I was not exposed to the FML portion of the developer, now that I am familiarized with it I can see where this will make my development much easier. I have only been working in WebFOCUS for a month now and had training a year ago. So when I said I was a neebie I am very green in this product. This is all second nature to you "experts" so a little patience with us small guys goes a long way.
 
Report This Post
<AM>
posted
Here is the result:

TABLE FILE SQLOUT
SUM
AIX/I5
LINUX/I5 AS 'Linux'
SECURITYOPSDEV/I5 AS 'Security,Ops Dev'
SOLARIS/I5 AS 'Solaris'
FILEPRINT/I5 AS 'File and ,Print'
VMWARE/I5 AS 'VMWare'
WINDOWS/I5 AS 'Windows'
TOTALS/I5 AS 'Grand Total'
FOR
LOOKUP_VALUE
'03/28/2009' AS '03/28/2009' LABEL R1 OVER
'04/04/2009' AS '04/04/2009' LABEL R2 OVER
'04/11/2009' AS '04/11/2009' LABEL R3 OVER
'04/18/2009' AS '04/18/2009' LABEL R4 OVER
'04/25/2009' AS '04/25/2009' LABEL R5 OVER
'05/02/2009' AS '05/02/2009' LABEL R6 OVER
'05/09/2009' AS '05/09/2009' LABEL R7 OVER
'05/16/2009' AS '05/16/2009' LABEL R8 OVER
'05/23/2009' AS '05/23/2009' LABEL R9 OVER
'05/30/2009' AS '05/30/2009' LABEL R10 OVER
'Sum' AS 'Sum' LABEL R11 OVER
'Open PPMs' AS 'Open PPMs' LABEL R12 OVER
'Weekly Average' AS 'Weekly Average' LABEL R13 OVER
RECAP R14/D6.2=R12/R13;
AS 'Backlog in Weeks'
 
Report This Post
Expert
posted Hide Post
quote:
all warm & fuzzy

imho: I may be speaking for others in saying that while we're here to help others in their quest to achieve their desired results, we're really not here to do their work for them.

I am glad that we guided you to the documentation and in such you found the answer to you question. I hope that you have not only achieved your desired goal, but, that you have also gained a greater understanding of the subject and the capabilities of WebFOCUS.

W&F Music
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report 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     [SOLVED] Creating a row based on multiple row values

Copyright © 1996-2020 Information Builders