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     About Table / Record question?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
About Table / Record question?
 Login/Join
 
Gold member
posted
There are only those records in the table like this:

Year Month Value
-------------------------
2003 Jan 12345
2003 Feb 34534
2003 Mar 32324
2003 Apr 34522
2003 May 34554


My question is: How can I show the others Month in the report (eg. Jun, Jul, Aug, Sep, Oct, Nov & Dec)
 
Posts: 55 | Registered: May 15, 2004Report This Post
<pranasH>
posted
1. Create file with all mounths listed e.g. small FOCUS file
2. Use MERGE ... MATCH ... OLD-OR-NEW (check doc. for MERGE OLD-OR-NEW)

Pranas
 
Report This Post
Platinum Member
posted Hide Post
Or using FML (Financial Modeling Language):

TABLE FILE CAR
SUM SALES
FOR COUNTRY
'ENGLAND' OVER
'POLAND' OVER
'PORTUGAL' OVER
'SPAIN' OVER
'USA' OVER
'W GERMANY'
END

TABLE FILE
SUM VALUE
FOR MONTH
'Jan' OVER
'Feb' OVER
...
'Dec'
END

Regards,
Mikel

This message has been edited. Last edited by: <Mabel>,
 
Posts: 173 | Location: Madrid, Spain | Registered: May 09, 2003Report This Post
Expert
posted Hide Post
Ringo, this is a classic use of the McGyver (or MacGyver) technique. its documented and written about. Do a search on the word in Knowledge Base (use both spellings Wink ) and then look up the article on it in TABLE FILE CAR. Its too long to explain here, but you'll figure it out, and its very famous part of focus lore, ibi should give out tshirts!
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Gold member
posted Hide Post
Thanks, Mikel, it works, But can I put the Month at the ACROSS field.




TABLE FILE
SUM VALUE OVER
DISCOUNT
BY YEAR
ACROSS MONTH
FOR MONTH
'Jan' OVER
'Feb' OVER
...
'Dec'END

Please help me!

This message has been edited. Last edited by: <Mabel>,
 
Posts: 55 | Registered: May 15, 2004Report This Post
Platinum Member
posted Hide Post
Yes. Yesterday I forgot to mention the use of ROWS and COLUMNS in order to define your own sort sequence:


-* Columns sort sequence.
TABLE FILE CAR
SUM SALES
BY CAR
ACROSS COUNTRY
COLUMNS
'ENGLAND' AND
'POLAND' AND
'PORTUGAL' AND
'SPAIN' AND
'USA' AND
'W GERMANY'
END
-RUN

-* Rows sort sequence.
TABLE FILE CAR
SUM SALES
BY CAR
BY COUNTRY
ROWS
'ENGLAND' OVER
'POLAND' OVER
'PORTUGAL' OVER
'SPAIN' OVER
'USA' OVER
'W GERMANY'
END
-RUN

egards,
Mikel

This message has been edited. Last edited by: <Mabel>,
 
Posts: 173 | Location: Madrid, Spain | Registered: May 09, 2003Report This Post
Gold member
posted Hide Post
Thank you very much, Mikel, it works fine now!
 
Posts: 55 | Registered: May 15, 2004Report 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     About Table / Record question?

Copyright © 1996-2020 Information Builders