Use this thread to post your product tips and tricks from th...

[Manoj Chaurasia]

Use this thread to post your product tips and tricks from the Share your Product Tips and Tricks! challenge!

[Rob Fosnaugh]

This is kind of generic, but many business users and developers rely on HOLD files to aggregate and get data in line for the final reporting but I always encourage them to get more creative with COMPUTES, Aggregate Within, and WHERE TOTAL to keep the report as self contained as possible and use the power of the platform. To me HOLD files are more like brute force vs. the finesse and sleekness of computes.

[Pawan Vuppala]

There are many shortcuts we love for eg.,

WHen youre in text editor mode

cntrl+M for comment

cntrl+R for uncomment

Drag and Drop is my favorite in 8207 homepage to move objects around

[Ashley Leggore]

I have to say I use the ctrl+M and ctrl+R a lot for commenting and uncommenting in text editor.

[VisuaLizeFOCUS .]

The new function bookmark controls is very awesome feature without much effort we can have that feature.

[Casey Green]

Might not be immediately intuitive, but when populating a visualization page immediately setting the column number to as high as possible (80 columns in my case using WebFocus Designer). This gives you more freedom and detail for content placement and I havent encountered any downside so far!

[john cullen]

Hello Im just joining myibi, and thought Id share one of my sucess stories.

Sometimes, I want to use code instead of GUI tools, so I use the GUI tools to generate the code I dont know, and then use the code it generates as an example how to do something.

As an example of that, we have the spreadsheet upload tool loads table to Hyperstage (or whereever), we know all the GUI clicks you can make, but dont know the code behind the gui tools. What I do is use the GUI tools, get one click away from where the server will do some work, turn on server traces, run the GUI tool, turn off server traces, then review the traces for the code generated.

Here is some code I gleamed on how to bulk load to hyperstage. Notice the syntax might be a little different than what you usually see, but its the exact code the tool makes.

ENGINE SQLHYPG SET BULKLOAD ON

TABLE FILE life_of_loan

PRINT JACKET_NUM

WHERE RECORDLIMIT EQ 1000000

ON TABLE SET PAGE NOPAGE

ON TABLE SET HOLDATTRS CUBE

ON TABLE SET HOLDLIST NOFOCLIST

ON TABLE HOLD

NOKEYS

AS baseapp/hold_load

TABLENAME hold_load

CONNECTION CON01

FORMAT SQLHYPG

END

[David Briars]

Excellent story jnc.

Thanks for sharing.

Welcome to myibi.

[Uro Malnari]

I very often use Change Management Export and Import to perform some global search and replace in all files from the Repository. Make sure you use the option to replace the existing files when inporting the changed files back.

[Les Johnson 3]

ctrl+M and ctrl+R for commenting and uncommenting in text editor.

[somya jain]

ctrl+M and ctrl+R for commenting and uncommenting in text editor.

[Warren Hinchliffe]

When you are editing text in 8.2 (ibi_apps/TED) you can use shortcuts to do things.

Apart from the usual CTRL-C/X/A/V/Z/Y

CTRL-/ = comment / uncomment

CTRL-U = Text to upper case

CTRL-SHIFT-U = Text to lower case

CTRL-F = Find / Replace Dialog

CTRL-H = Find / Replace Dialog

CTRL-D = Delete selected lines

And the really good one.

ALT-drag select = multi-line typing

e.g. If you wanted to type many -SET &, alt-drag the first column and type away.

[Rina jain]

Ctrl+M and ctrl+R for commenting and uncommenting in text editor

[Joseph Vina]

TABLE FILE NAME

PRINT *

END

-EXIT

Allows me to work through fex holds to see where data is breaking or filtering.

[Cory Vendrely]

We found that using the Table of Contents option (WebFOCUS 8.2.03) can be helpful when creating reports for Excel. If you want to break up your report into multiple Excel sheets, whichever field you group by first will be the field that is split up into multiple sheets. The Table of Contents option is in the Format tab.

[Heidi Karasiewicz]

When searching fields, use the * before or after a short phrase to quickly find all relatable measures or characteristics within the data.

[Dinesh Goundai Jothivelu]

WHENCE [masterfilename] MASTER

Easy way to identify the master file path.

[Brian Baird]

I often find myself using this quite often to debug my code

-TYPE &parametername

-EXIT

[Manoj Chaurasia]

This line of code at the beginning of your fex

-SET &ECHO=ALL;

is the best debugging tool you will ever use. Your output format has to be HTML and when the output is displayed if you view the source of the output it will show you all the WebFOCUS code that was run. All the values for parameters are displayed in the code and if you have complex logic for dialog manager you will see how the IF-THEN-ELSE of the logic is applied.

Dont forget to remove this code before you release it for everyone to use it can cause some overhead. Use it strictly for debugging issues.

[Dawn Thurber]

I was going to talk about the table of contents feature in InfoAssist but Cory mentioned that one. I will share about the comma instead. If you edit/change a title in InfoAssist, you can use a comma in the name to insert a multi-line header.

[Amy Rainwater]

Definitely the ctrl+M and ctrl+R for commenting and uncommenting in text editor as well as the comma for line change.

[Azhar M A 2]

Below are the most common used by me

-SET &ECHO=ALL;

SET ASNAME=ON

-TYPE &parameter_name

-EXIT

FF holfilename

ctrl+M and ctrl+R for commenting and uncommenting

[Robert Brown]

rina.jain:

 

Ctrl+M and ctrl+R for commenting and uncommenting in text editor

 

 

Ctrl+M and ctrl+R for commenting and uncommenting in text editor

[Ian Dalton]

SET TEMPERASE=OFF

This is good for debugging and keeps all your temp hold files (and masters) in ibisrv81wfsedatemp

[LK .]

General:

WHENCE to find the location or path of webfocus resources

-SET &ECHO=ALL; for debugging

SQL Trace for checking the sql translation

ON TABLE SAVE- can be used to check the formats of fields in the master file

App studio:

Ctrl+M and Ctrl+R for comment/uncomment

Ctrl+U and Ctrl_Shift+U for UPPER CASE /lower case