Hey Buddy Dont worry Here is some useful stuff from ramkumarn.
com on Webfoucs basics This is the very first tutorial You defenitely can expect much more very sooooon.. Is It !!!!!!!!! Thats definitely a Great news Am Eager to go through. Happieeee Happieeeee
Webfocus Basics
http://www.ramkumarn.com
Hey Techies !!! Webfocus So what's that?
To say simply - Webfocus is a BI tool. Oh Oh Oh !!! Whats BI ? Business Intelligence Move on to Next Page
Before Which
In the words of Grzegorz Swietlik
Webfocus is the reporting engine that turns corporate data into meaningful information, complemented with Web components for presenting information and interacting with end users. http://www.ramkumarn.com
Hmmm So What is BI ?
BI is an art of making your customers to do better, than they do themselves. - Activities include decision making support, query and reporting, online analytical processing, statistical analysis, forecasting, and data mining. Need of BI Database Compatibility Scalability Adhoc Reporting Presentation Format OLAP Support Integration with existing Web-applications Security
http://www.ramkumarn.com
Samigoooo.. Here is the WF Architecture
http://www.ramkumarn.com
Webfocus Anatomy
Nothing Nothing Jus to say following are the organs of Webfocus The Webfocus server and Client are like heart and Lungs of Webfocus architecture
Internet Explorer Web Server WebFocus Client WebFocus Reporting Server Report Caster Distribution Server Scheduler Component Managed Reporting Environment Business Intelligence Dashboard Resource Analyzer & Governor
http://www.ramkumarn.com
Webconsole Most Imp Thing on WF So whatz that ?
Webfocus Utility that helps in Editing/Executing Code Files Setting Server/Client Configurations Overall monitoring of all the process that run in the serverside WebConsole is used to Manage : Data Adapter` Procedure(Fex Codes) WorkSpace
http://www.ramkumarn.com
Fex Oops !!! What is that ?
The code that is created using Webfocus Tool is called Fex File extension is (*.fex) The Fex code can be created and executed via Webfocus Developer Studio (Report painter and other GUIs) Webfocus Console
Fex>>FOCEXEC >>Webfocus Executable
http://www.ramkumarn.com
Hey Buddy What will Happen If a Fex file is executed ?
Usually, The purpose of the FEX code is to query/fetch the data from some database, format it, manipulate it and present some useful stuff to the User The Following Two Files will be created in the Webfocus server whenever a Fex file is executed MASTER File(*.mas) A Master File describes a data source using a series of declarations (almost kind of Metadata) FIELDNAME = EMP_ID, ALIAS = EID, ACTUAL=A4,$ FIELDNAME = EMP_NAME, ALIAS = ENAME,ACTUAL=A50,$ FOCUS File(*.ftm) (Raw data File) The actual data (i.e the Resultset of the query).
http://www.ramkumarn.com
A heads up Do I need to know the Syntax of all FEX stuff? The answer is definitely NOT Then ??? Practice with Developer Studio on various reporting options and GUIs You will be given with the FEX code, generated as code behind. Yipeeee So Just the Drag and Drop stuff.. Aha ? Am HappppieeeeThanks Buddy Hellaoo Wait Wait But understanding the FOCUS reporting language helps to realize what is going on behind the scenes.
OkieeeOkieee So what is that I have to learn as my First FEX lesson??
Nothing but the Table File and SQL Query
Thatz ok Man I can definitely do that Come !!! Let us Go
http://www.ramkumarn.com
For you my PalA much Simple Report
TABLE FILE CAR PRINT COUNTRY CAR END
This is the simplest Fex code that anyone can write as a Hello world in webfocus. This Fex uses the CAR hold file (already available in webfocus) and print the country and car columns in Tabular Format. http://www.ramkumarn.com
Overall Structure of a TABLE Request Anyways many of them are optional But are needed often
TABLE FILE data_source [ print_phrase ] [ sort_phrase ] [ filter_phrase ] [ output_section ] [ styling_section ] END http://www.ramkumarn.com
data_source
Phrase By Phrase Jus a quick View Through
Specifies the name of the configured synonym, which will be used as the data source for the report.
Example
TABLE FILE CAR (use CAR synonym as the data source) print_phrase
Specifies the fields from the data source to be printed within the report. Similar to the SQL SELECT statement.
PRINT
TABLE FILE CAR PRINT * END
http://www.ramkumarn.com
SUM, AVE, MAX, MIN
TABLE FILE CAR SUM SALES AS Total AVE RETAIL_COST MAX DEALER_COST END
sort_phrase
Similar to the SQL Group By.
BY
TABLE FILE CAR SUM SALES BY COUNTRY BY CAR BY MODEL END
http://www.ramkumarn.com
ACROSS
TABLE FILE CAR SUM SALES ACROSS CAR AS '' ACROSS MODEL AS '' BY COUNTRY END
SUBHEAD
TABLE FILE CAR SUM SALES ACROSS CAR AS '' ACROSS MODEL AS '' BY COUNTRY NOPRINT SUBHEAD "<COUNTRY" END
http://www.ramkumarn.com
filter_phrase
Similar to the SQL WHERE clause.
Example 1 TABLE FILE CAR SUM SALES BY COUNTRY WHERE COUNTRY EQ 'ENGLAND' END Example 2 TABLE FILE CAR SUM SALES BY COUNTRY WHERE COUNTRY LIKE '%G%' END
http://www.ramkumarn.com
output_section
Specifies the format of the report to be generated.
ON TABLE PCHOLD FORMAT output_format
where output_format is one of the following: HTML, PDF, EXL2K,AHTML etc
Example TABLE FILE CAR SUM SALES BY COUNTRY ON TABLE PCHOLD FORMAT EXL2K END
http://www.ramkumarn.com
styling_section
Specifies the formatting options (fonts, colors, etc.) for the report elements.
Syntax ON TABLE SET STYLESHEET * TYPE=type, [COLUMN=column_name], property=value,[property=value,]...$ [TYPE=type, [COLUMN=column_name], property=value, [property=value,]...$] ENDSTYLE
where type may be REPORT, DATA, TITLE, TABHEADING, etc. The most common format properties include COLOR, SIZE, FONT, BACKCOLOR, JUSTIFY, etc.
http://www.ramkumarn.com
A Much Simple Example
TABLE FILE CAR PRINT * ON TABLE PCHOLD FORMAT HTML ON TABLE SET STYLESHEET * TYPE=REPORT, GRID = ON, SIZE=8, FONT='ARIAL, VERDANA, HELVETICA, SAN-SERIF', $ TYPE=TITLE, BACKCOLOR=RGB(0 51 153), COLOR=WHITE, STYLE=BOLD, SIZE=9, JUSTIFY=CENTER, $ TYPE=DATA, COLOR=BLACK, SIZE=8, $ ENDSTYLE END
http://www.ramkumarn.com
Heads Up Well What Next ? HTML Coding is an inseparable part of any Reporting Language Do you accept that? Yes.. So How to get that done ? Just Move on.
A BASIC HTML Example
To create a HTML page in Webfocus you must edit the source of the document. There is a GUI tool called the resource layout painter that does much of this work for you if you wish but this technique works well. In .fex file, try the following code
-HTMLFORM BEGIN <html> <body> Hello world!! </body> </html> -HTMLFORM END
Produces the output: Hello World!!
Snippet It is possible for you to do all the stuff in Webfocus, that you can do in HTML and JavaScript. Starting from including <input> elements to create a dynamically embedded <div> tag, everything can be done. Using this you can create user friendly and Parameterized reports and rich user front ends
Hey Thats enough with the Fex stuff Ok But Try to text view the code for any report that you develop with Dev Studio So that you will get to know the Syntax.. Sure Sure Will do that Then, What are the different Types of Reports that can be developed with Webfocus?
Here It Goes
Parameter-driven Reports Graphical Reports Compound Reports Financial Reports Excel Reports Free-Form Reports Drill-down Reports
A lot more to follow on WF basics Expect soon
http://www.ramkumarn.com
