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] WITHIN on different levels

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] WITHIN on different levels
 Login/Join
 
Peter
Gold member
posted
Hello all,

I'm trying to wrap my head around a WITHIN conundrum:
Below report on CAR simply depicts:
- the count of the distinct cars per country, bodytype, car
- the count of the distinct cards per country, bodytype
- the count of the distinct cards per country

How can I make my second count unrelated to the third count? i.e. how can I get:
- the count of the distinct cars per country, bodytype, car
- the count of the distinct cards per bodytype (for all countries)
- the count of the distinct cards per country

I'd assume it'd be something like WITHIN BODYTYPE,COUNTRY
but so far I've only gotten it to work via intermediary hold files for each level of WITHIN...

TABLE FILE CAR
SUM CNT.DST.CAR
CNT.DST.CAR WITHIN BODYTYPE
CNT.DST.CAR WITHIN COUNTRY
BY COUNTRY
BY BODYTYPE
BY CAR
ON TABLE PCHOLD FORMAT HTML

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


Prod: WebFOCUS 8.0.06 on Win2008/Tomcat7/LDAP Mode
Test: WebFOCUS 8.0.06 on Win2008/Tomcat7/LDAP Mode
 
Posts: 59 | Registered: April 23, 2012Report This Post
Danny-SRL
Virtuoso
posted Hide Post
Peter,
I suggest you use McGuyver:
  
JOIN BLANK WITH BODYTYPE IN CAR TO BLANK IN FSEQ AS MCG
DEFINE FILE CAR
BLANK/A1 WITH BODYTYPE = ' ';
SORT/A20=IF COUNTER EQ 1 THEN COUNTRY ELSE IF COUNTER EQ 2 THEN BODYTYPE ELSE CAR;
END 
TABLE FILE CAR
IF COUNTER LE 3
SUM CNT.DST.CAR
BY COUNTER
BY SORT
END

If you do not have a McGuyver file, here is what it looks like:
Master:
  
FILE=FSEQ, SUFFIX=FIX, DATASET=FOCALPOINT/FSEQ.DAT, $
  SEGNAME=SEG1
   FIELD=CONTROL, BLANK , A1, A1, $
  SEGNAME=SEG2, PARENT=SEG1, OCCURS=VARIABLE
   FIELD=WHATEVER, , A1, A1, $
   FIELD=COUNTER, ORDER, I4,  I4,$

Note: FOCALPOINT is the name of the application where I do my checking. You can use any other that suits.

Data:
  
 SOMECHARACTERSFORTHEFSEQFILENOTICETHEFIRSTCHARACTERISASPACE


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Peter
Gold member
posted Hide Post
Hi Daniel,

I had a bunch of other work demanding priority, hence my late reply.
Your solution fits my needs even better then expected:
- it's compatible with InfoAssist
- it can resolve some outstanding issues with UNION requests as well

Many thanks for the tip!

Regards,
Peter


Prod: WebFOCUS 8.0.06 on Win2008/Tomcat7/LDAP Mode
Test: WebFOCUS 8.0.06 on Win2008/Tomcat7/LDAP Mode
 
Posts: 59 | Registered: April 23, 2012Report This Post
Danny-SRL
Virtuoso
posted Hide Post
Peter,

Great!
Glad to have been of help.

Do you use mostly InfoAssist of do you also develop structured applications with many parameters?


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Peter
Gold member
posted Hide Post
Pretty much all our reports are generated with InfoAssist today. whenever we encounter a situation where IA doesn't fit the bill (example: merge two hold files via MORE), we just copy the IA-report and add the necessary code manually.

As far as applications with many parameters are concerned, the goal is to start using these to replace 'resembling' IA-reports with the idea to diminish the amount of reports that are generated by our business.

Long road though :-)


Prod: WebFOCUS 8.0.06 on Win2008/Tomcat7/LDAP Mode
Test: WebFOCUS 8.0.06 on Win2008/Tomcat7/LDAP Mode
 
Posts: 59 | Registered: April 23, 2012Report This Post
Danny-SRL
Virtuoso
posted Hide Post
Fine.
If and when you have the need to build some structured "ad hoc" applications, contact me again. We have a very good framework for this which almost all our customers use.


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report 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] WITHIN on different levels

Copyright © 1996-2020 Information Builders