New Features 8.2.01
1. Copy From the File/Folder Properties Panel –
You can now copy a property value from the File/Folder Properties panel. Right-click a property value and click Copy to copy it to the clipboard, as shown in the following image.
Show master files for “Show all Contents”
2. Execution of One Task From Another –
You can now run the contents of an existing task from another so that the actions of the selected task will be invoked. An Execute Task option has been added to the Requests selections drop-down menu in the Requests/Actions section of the Tasks & Animation panel, as shown in the following image.
3. Separate Tabs for JavaScript and Embedded CSS Options –
Previously, the App Studio HTML canvas had a combined Embedded JavaScript/CSS tab. Now, this tab has been divided in two: Embedded JavaScript and Embedded CSS tabs.
4. Directly create Procedure via Text Editor option included when you right click on any folder.
5. Multi Select List Control with Check box for selection –
A multi-select drop-down function has been added to App Studio. This multi-select control allows you to specify more than one value at a time. This functionality creates a drop-down list and uses a check box adjacent to each value for selection, as shown in the following image.
6. Multi-Select Folders to Publish, Hide, and Show –
App Studio has added the ability to duplicate, copy, and delete multiple folders at the same time. This functionality uses the standard methodology of pressing the Ctrl key while selecting the desired folders in the Environments Tree panel.
7. Sharing Multiple Folders At Once –
App Studio has added the ability to publish, unpublish, hide, or show multiple folders at the same time. This functionality uses the standard methodology of pressing the Ctrl key while selecting the desired folders in the Environments Tree.
8. Enhanced PDF Support for JPG Compression –
The compression algorithm used for JPG images embedded in PDF documents has been enhanced to generate considerably smaller PDF files, and to allow users to control elements of the JPEG compression method. The following new SET commands allow users to select the compression methodology (SET JPEGENCODE) and the image quality (SET JPEGQUALITY).
SET JPEGENCODE = [FLATE|DCT] SET JPEGQUALITY = n
9. Defining Hyperlink Colors –
You can use the HYPERLINK-COLOR attribute to designate a color for a hyperlink within a report. This applies to all hyperlinks generated in the report. You can define a single color for the entire report or different colors for each individual element. TYPE = type, HYPERLINK-COLOR = color
10. Currency display options –
fld/fmt:C(CURRENCY_DISPLAY=’pos’,CURRENCY_ISO_CODE=’iso’,CURRENCY_PRINT_ISO=’prt’)= expression;
11. New Date and Time Locale Parameters –
SET DATE_ORDER = {DEFAULT|DMY|MDY|YMD} SET DATE_SEPARATOR = separator SET TIME_SEPARATOR = {DOT|COLON}
SET DATE_SEPARATOR = DASH SET DATE_ORDER = DMY -TYPE NON-LOCALIZED: &DATE -TYPE LOCALIZED: &DATE.DATE_LOCALE The output is: NON-LOCALIZED: 04/07/17 LOCALIZED: 07-04-17
12. Applying Selection Criteria to the Internal Matrix Prior to COMPUTE Processing – WHERE_GROUPED expression
WHERE_GROUPED can be optimized for SQL data sources by creating a GROUP BY fieldname HAVING expression clause, where the expression is the WHERE_GROUPED selection criteria.
13. PARTITION_AGGR: Creating Rolling Calculations – Using the PARTITION_AGGR function, you can generate rolling calculations based on a block of rows from the internal matrix of a TABLE request.
PARTITION_AGGR([prefix.]measure,{sortfield|TABLE},from,to,operation)
14. PARTITION_REF: Using Prior Field Values in Calculations – Use of LAST in a calculation retrieves the LAST value of the specified field the last time this calculation was performed. The PARTITION_REF function enables you to specify both how many rows back to go in order to retrieve a prior value, and a sort break within which the prior value calculation will be contained.
PARTITION_REF([prefix.]field, {sortfield|TABLE}, -offset)
15. Limiting the Number of Stacked Commands and Loop Iterations – DMH_STACKLIM and DMH_LOOPLIM should be set high enough to run your existing reports and procedures without error for your entire session. It is recommended that if you set these parameters, you should set them in a profile.
16. New Report-Level Prefix Operators – Prefix operators have been added for headings, footings, subheadings, subfootings, verb objects, and calculated values (COMPUTEs) that calculate the average, maximum, minimum, and count for the entire report.
TOTAVE., TOTMAX., TOTMIN., TOTCNT.
17. Format Display Option for Percentage Calculation –
The lowercase p display option converts a number to a percent by multiplying it by 100. It then displays the number followed by a percent symbol (%). This is different from the % format option, which does not calculate a percent, it just displays a percent symbol after the number. Note: This option is not supported for output formats XLSX and EXL2K.
18. LAST_NONBLANK: Retrieving the Last Field Value That is Neither Blank nor Missing
19. REGEX: Matching a String to a Regular Expression
20. REPLACE: Replacing a String
21. Collaborative Portal
22. Report Caster Ability to Distribute Reports to the File System – You can send scheduled reports directly to a folder in the File System of your computer.
23. Report Caster – Packet Email override per Schedule
24. Report caster – Clone Tasks
25. Report Caster – Advanced Options per Schedule – FOC to warning
26. Report Caster – The global configuration option for No Report to Distribute can be set within individual schedules to convert the No Report to Distribute error message to a warning.
27. Report Caster – Enabling Global Updates for Schedule Notification Settings The schedule notification settings that can now be globally updated are Notification Type, Notification Reply Address, Notification Subject, Notification Brief Message To, and Notification Full Message To, as shown in the following image.
28. CM – Change Management Package Zip File Downloads
29. Adapter – The relational adapters now optimize reports that contain a BY field more efficiently, by no longer passing MAX(field) in the SELECT list to the RDBMS.
30. Adapter – Optimization of the PARTITION_REF Function Calls to the PARTITION_REF function in an aggregation request with a WHERE TOTAL phrase can be passed to SQL engines that have a LAG function, such as Db2, Oracle, Teradata, and Microsoft SQL Server.
New Features 8.2.02
1. App Studio – Save All and Close All
2. Using the WebFOCUS Schedule Task Type to Schedule Other Schedules –
The WebFOCUS Schedule task feature allows you to use a single schedule to initiate one or more schedules. You can set WebFOCUS Schedule tasks to run immediately before other schedules in the Distribution Server queue, or run independent of other schedules in the Distribution Server queue.
3. Email Distribution Using the Cc and Bcc Email Options –
4. Enabling and Disabling Schedules Using the Shortcut Menu Option –
5. Cloning Tasks in the Advanced Scheduling Tool –
You can now clone an existing task in the Advanced Scheduling tool. This feature allows you to make a copy of any task. When you clone a task, every option and setting from the existing task is present in the cloned task.
6. Applying Global Updates for Pre and Post-Processing Procedures
7. Restricting User Input of Email Addresses and Domains
New Features 8.2.03
1. EDAPRINT: Inserting a Custom Message in the EDAPRINT Log File
2. Displaying a Caret Symbol (<) in Heading Objects
In order to display the caret symbol in a heading object, use two consecutive caret symbols (<<).
3. STRING Data Type –
Certain relational data sources support a data type called STRING to store alphanumeric data that has an unlimited length. This type of data can be mapped to the TX data type. However, text fields have limitations on their use in WebFOCUS sort and selection phrases. The format specification for a STRING field has no length specification. The length is determined on retrieval. The STRING data type has all of the functionality of alphanumeric data types in WebFOCUS. The limit to a STRING field value length is 2 GB.