April 2017
Version: R10M26
The following Enhancements are included in this version:
- When a user is restricted from an object or folder, they will no longer see the object or folder in the list.
- Unwanted folders can now be removed from the Repository tree provided user is authorized.
The following Updates are included in this version:
- A dashboard containing a view with subtotals and the tool bar is hidden did not complete running.
- Negative values in a client table do not graph in using a SWS connection.
- Using a SWS connection, file locks and license locks are not released with buffered results (greater than 100 records returned).
- Using both a SWI and SWS connection, the DB List box of a variable will not be entry capable.
- Views using Database *LOCAL or *LOCALSYS with a variable with DB Lists that display a field value, and pass that same value to the view did not display the list of values.
- Using a SWI connection, Dynamic Regrouping and including derived field generates a syntax error.
- Running a host table with either a SWI or SWS connection, and with Sequel Auditing turned on, scrolling down past 100 records, would cause the buffering to freeze.
- Saving results to .xlsx from a view that returns results containing a null value, Excel will not open the resulting file, instead issuing the message: ‘File format or file extension is not valid’ when running a repository object from SWS.
- When emailing host report results from SWI, either after results are displayed, or directly from the SWI explorer screen, the user is prompted for variables and email, but then fails with error: Value '...' for TITLE exceeds 50 characters.
- Digital Gauges do not refresh on a dashboard in SWI/SWS when the Reprompt option is chosen.
- When defining an IBM host in SWS, the connection URL is now created to include ‘naming=system’.
- Rare circumstances result in the following error when running a client table on a SWS server in Host mode: ‘PreparedStatementCallback; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException’.
- Digital gauges on dashboard run in SWI or SWS only display for a single data window. Second data source gauges remain a value of zero.
- In Chrome with a SWI connection, a blank page was rendered until F5 (to refresh) was pressed.
October 2016
Version: R10M24
The following Updates are included in this version:
- From Repository a .vptreport shortcut doing Save Results> Repo File>RTF creates corrupt file.
- The presence of a slash ( \ ) at the end of any object description text prevents a list of objects including that view from being displayed.
- Client Reports (SQLRPTC) and Client Tables (SQLTBLC) with a variable using a DBLIST with check(multi) did not properly quote the string.
- Script View with a DBLIST, multi-select prompt variable not passing variable string correctly.
- When the Dynamic Drill Down List file (SEQUEL/VPTDYNFLTR) contains a list of fields, only those fields are available for dynamic drilldown. If the file contains fields, but no fields that exist in the files that a grouping view references, then the option to view the complete list should appear in SWI, as it does in ViewPoint and SWS.
- Reprompt of variable with DBLIST gave error.
April 2016
Version: R10M23
The following updates are included in this version:
- I/O Error. Broken Pipe when using remote database connection from SWI in some instances.
- From a SWI connection, Email sent to a Distribution list is only sent to the first 2 recipients in the list.
- Using SWI, Right click a CRO report or Display and then Click Download > RTF will now work.
- When running Dynamic Drill Down ( Regroup / Show Details) on a view with SERVER(*LOCALSYS) SYNTAX(*SEQUEL) in SWI you get CPD4306 ‘field is not unique’ if picking a field name that is found in multiple files.
- When using Regroup with a SWI connection, the HAVING clause should be removed but should remain when using Show Details.
- Running a prompted view/report/table in SWI fails if prompt value has an apostrophe in it.
- Within the repository additional shortcut types were created to distinguish between a Host Report (.vptreporth) and a Client Report (.vptreport), and Host Tables (.vpttableh) and Client Tables (.vpttablec), and Script (.vptscript) and Script Views (.vptscriptv).
- Using a SWS connection to run a Client Table built over a ViewPoint Universal Driver connection (JDE or *ADS) is now supported.
- In a SWS and SWI connection, download and email of a Client Report (CRO) now supported.
- JD Edwards World A9.2 users unable to log in to SEQUEL Web Server, received error ‘Your connection has been expired. Please retry your action.’
- JD Edwards World A9.3 users unable to log in to SEQUEL Web Server if only 1 Environment assigned to user.
- SWS will now require ADMIN credentials to change host configurations.
- Basic users cannot connect with SWI due to authorization to running the CHGCURLIB command
- Prompt Variables with default values that include decimal amounts are rounded, and do not display the actual value saved with the view.
- Drill Down Application with a hash symbol (#) in title of object, did not run.
- From the SWI Explorer displaying of all results, including unbuffered like script views, will honor date sorting when the date style is MDY or DMY or USA or EUR.
- From a dashboard, Reprompt All button does not display if the last variable has prompt text of *NOPROMPT.
- When a variable is used for a multi-select DBLIST, the length of the variable will be honored so an unlimited number of values cannot be entered.
Charting:
- On a bar chart, x-axis labels are now supported to show values under the bar.
- On a chart with many points, x axis lables can be set to show every nth value. When saved on a dashboard, this attribute is not retained.
- Charts built over views with sub-totals in the results should not graph subtotals.
- Bar Chart exported from display to PC file did not render correctly.
- Right titles are now supported.
The following enhancements are included in this version:
- Using a SWS connection, a variable with a Database List will now be supported for remote database views.
- The repository now supports dashboard objects as .vptdash objects.
November 2015
Version: R10M22
The following updates are included in this version:
- View Subtotals are missing in SWS when Save to Repository is used.
- SEQUEL Application from SWI or SWS, drill down causes a prompt screen to appear instead of automatically passing the required data to the "drill to" view with NAME or EXPR type variables.
- When running an Application from SWI or SWS, the text above the Drill down results was coming from the description text defined in the View Definition.
- Now the title uses the text defined on the Option File entry on the Drill down results.
- Views with DB list prompt variables that display a value from one field, but pass a value from a different field to the view intermittently pass the description field instead of the value field to the view only on re-prompt.
- When a dashboard is run from SWI or SWS, the order of the prompt variables appear in no particular order. This is most noticeable when the there are several sequential variables.
- Using SWS, when a dashboard that has a DBList(s) is launched, the DBList(s) will only show the default value.
- From SWS, running a Host Table (SQLTBLV) to Save Results/Download/PC file when no records were selected did not send message.
- Variable with Values List with double quoted values does not pass integrity check when run in SWI.
- For SWI and SWS, using Right click/Save Results/Download to a PC file on a Host Table that returned no records did not produce a PDF file with the No Records Returned message.
- Emailing results from a SQLRPTC (CRO) file in SWS sends file with temporary name.
- Running a view in SWI/SWS, and highlighting some values in a column to see the Total at the bottom right, if there are any negative values highlighted, they are not included in the Total, and they are treated as zero.
- In a Client Table, a calculation that is based on other calculated columns could show incorrect results in SWS.
- SWS shows no implied drill option based on options in file with like variable names.
- When a Client Table with column totals suppressed via Format>Layout> Then Click each of the 'Row' fields and uncheck show footer, is displayed in SWS, the column totals were still visible and in fact are the only level to show initially.
- From SWS, a Client Table that was designed to have fields with the " visible " box unchecked in Format>Layout>Fields tab so that the field isn't displayed in the results, but the field is available to be used in other calculated fields, was displayed.
- Client Report should have option for xls when downloading to a pc file.
- From SWS running a .vptview from the repository and using Dynamic Drill Down options of Regroup or Drill Down gives error ‘object in QRECOVERY not found’.
Dashboards
- Single quotes in Action Button Text display as 2 single quotes.
- A chart with an apostrophe in the Title will not display in SWI/SWS.
- Embedded Excel spreadsheet did not open if using Excel 2013.
- Made chart titles consistent between SWS and ViewPoint. For instance, in SWS the chart title is {‘Total A/R’ by ‘Sales Region’} but ViewPoint used {Total A/R by Sales Region}.
- Added support to keep legend on the left side is that’s how it was created in ViewPoint.
- Bottom legend customized to show every other or every third in VP does not translate to SWI/SWS - all legend info is shown.
- Trends "Limit lines" and "mean/avg lines" are missing in Line charts
- Edited – customer legend (labels) not visible.
- Chart colors changed to match ViewPoint more closely.
- Line graphs improved to:
- Show line and not small circles
- The range defined in the graph is not used - instead it uses a default range (0 - 100) and, depending on the data, can render the graph useless.
- When a line is displayed, it is too pale, and should be more prominent as in ViewPoint.
- The graph window title bar is missing in SWS
- Gauges are showing different value ranges between VP and SWI; range steps are no longer in specified increments.
The following enhancements are included in this version:
- Properties of a view can be restricted by user.
- Support for prompting of JDE Environment and Role when using the ViewPoint Universal Driver (JDE Driver) and running views and reports from SEQUEL Web Server.
- SWIOPEN COLSET parameter length increased from 315 to 512 positons to accommodate longer URL strings being passed.
- Apache version upgraded to 2.2.29.
- Implement local variables for Skybot to avoid collision errors when we have several jobs that want to use a variable named &CUSTID for example. With private Skybot variables we could set the CUSTID variable for every job and avoid these collisions. This would also simplify our current prompting scheme, and allow for cleaner web service URLs and variable names.
- In SWS, limitation of 800 for variables using a DBLIST was removed.
- SWI/SWS increased email address book drop-down to more than 1500 entries.
- A Drill Down application that uses an option file where some runtime variables are set to hard coded values fails to pass any values when run in SWI and SWS.
- SWI/SWS fails to process command in Drill Down options when the command is qualified with a library name.
May 2015
Version: R10M21
The following updates are included in this version:
- User defined title in graph from dashboard not used.
- Dashboards run with zero values for the speedometer or thermometer values were not displayed.
- From a dashboard, line graphs were rendered with the wrong series order.
- Dynamic Drill Down (drill from a GROUP BY view) does not honor 'Dynamic Drill Down List' defined in the ViewPoint Administrator.
- Dashboard overlaps when using Zooming in or out from Internet Explorer and Firefox.
- From SWS a value with an apostrophe passed to a prompted view would cause the request to fail.
- Action buttons from a dashboard did not work when DSPNETA had a different name than the system defined in in SWS.
- Digital graph not rendering number represent time (HH:MM or HH:MM:SS) with an edit mask correctly.
- SWI/SWS hangs when rending a gauge created with a blank custom mask.
- On a dashboard, a text box that contains a single quotes displayed as two single quotes.
- From a host tables the Download to a PC file in PDF option, both save and open, rendered message that the file could not be opened.
- From SWS, a SQLIVEWM (with SERVER other than SEQUEL) did not show sub-totals if they were saved with the view.
- In a dashboard, a radial gauge had the maximum value ignored and the actual gauged cell value became the maximum and the gauge displays maxed out.
- In a dashboard, and Action Button running a command string for a prompted view with SETVAR should not prompt.
- Client Tables from SWS with calculated fields without a specific derived field name will not longer end in a ‘Mondrian Error:Internal error’.
- User based license was not released when view is reprompted and run again from Auto-Prompt window.
- Multiple fixes for passing prompted values with quotes.
- Dashboard bar chart not using column/series order the same way as ViewPoint when user changed graph defaults.
- Skybot Integration:
- When creating a Skybot job around a Client Report object, the drop down menu for the extension of the output file needs to allow for XLS files.
- The output location of Skybot jobs in SWS should allow writing to UNC paths outside of the REPOSITORY.
- Skybot settings button no longer visible when using unsecured URL.
- Repository:
- Expanding the repository and drilling into multiple levels of folders, then creating a job, returns you to the high level repository folder.
The following enhancements are included in this version:
- File type xlsx add to the Save Results\Download to PC\Export to Excel option.
- Creating a job from a view or a vptview the Output File parameter now has a type of HTML in the drop down.
- Improved Navigation Pane that is completely collapsible.
- Additional options added to ViewPoint Administrator for SWI Functions List control.