Member search now works with the default alias for Essbase, HFM, PBCS, FCCS, and Oracle Financial Cloud (OFC).
Enabled login configuration for different PBCS, FCCS, and OFC versions.
Enhanced POV String parsing for Essbase and OFC to allow more flexible user formatting options.
Added row limit configuration for HFM environments.
Common library upgrades
Version 9.5.3
Enhancements
Final release of SmartView to POV String Converter for Oracle Financials Cloud
Enhanced the responsiveness when drilling through the Essbase outline when using an APS connection
Enhanced the responsiveness when drilling through an OFC outline
Bug Fixes
Corrected an issue where an Essbase outline would not appear in the Query Builder screen when a cube had a member with the same name as the cube.
Properly display all HFM applications in the Query Builder screen, not just the first one.
Version 9.5.2
Bug Fixes
Corrected a bug when looping on various segments for OFC.
Version 9.5.1
Bug Fixes
Corrected a licensing issue for Oracle Financials Cloud
Version 9.5.0
Enhancements
First release of Oracle Financials Cloud connectivity. Includes the ability to pull general ledger balances and balances for all major modules.
Version 9.4.0
Enhancements
PBCS write-back and job initiation from Alteryx. Jobs, rules, and rulesets can be kicked off before and after writing data back to the PBCS application
Enhanced daily log roll check
Enhanced the license expiration message and user instructions to resolve
Enhanced log file with additional details and usernames for loops and metadata completion
Updated PBCS login page to show appropriate error message when login is successful but no apps and/or plan types are available.
Bug Fixes
Corrected a bug that caused validations of Essbase environments to fail.
Security Enhancements
Various OWASP best-practices implemented to address low-risk security vulnerabilities.
Version 9.3.0
Enhancements
Added the ability to write-back to PBCS from Alteryx
Streamlined installation process for Task Scheduler
Version 9.2.0
Enhancements
HFM write-back/consolidation ability from Alteryx
Header size configuration options added
Version 9.1.0
Enhancements
Added HFM SmartView to POV String converter functionality
Enabled ExoInsight compatibility for Oracle Cloud Gen2 environments
Version 9.0.6
Bug Fixes
Corrected a bug that caused validations of Essbase environments to fail.
Version 9.0.5
Enhancements
Added Calc Status display to HFM data result sets.
Version 9.0.4
Enhancements
<Entity Currency> is replaced with entity's base currency value in the results.
ExoVars now display in the HFM outline tree.
Bug Fixes
Corrected an issue with shared hierarchies displaying incorrectly in the HFM outline tree.
Version 9.0.3
Bug Fixes
Corrected a bug that resulted in an error when more than on ExoInsight admin was added to an environment.
Version 9.0.2
Bug Fixes
Corrected a bug that resulted in an error when more than on ExoInsight admin was added to an environment.
Version 9.0.1
Enhancements
Removed drop-down requirement on Admin Users screen to accommodate different browsers
Version 9.0.0
Enhancements
HFM integration with Alteryx
HFM integration with Tableau
HFM integration with KNIME
HFM integration with relational databases
HFM integration with flat files
Enhanced password security handling - passwords are no longer displayed or editable to ExoInsight admins
PBCS/FCCS connections can now utilize an admin-only environment, enabling easy updating of credentials
The ability to configure PBCS dimension metadata output columns
Bug Fixes
Error when selecting the environment when adding Saved POVs or ExoInsight Variables has been resolved
Inability to enter application after selecting environment when adding Saved POVs or ExoInsight Variables has been resolved
PBCS dimensions do not expand after Oracle update (incorporates 8.7.1 hotfix)
Version 8.7.1
Bug Fixes
SmartView to POV String converter page for Essbase did not display any ExoInsight environments.
Version 8.7.0
Enhancements
ExoInsight Variables - ExoInsight created and maintained substitution variables that can be used in POV Strings, enabling easy control of query updates within Alteryx, Tableau, KNIME, Qlik, or any other target that ExoInsight supports.
Saved POV references - Now Saved POV names can be referenced as the query, enabling easy updating and maintenance of any ExoInsight processes that use Saved POV queries.
Granular control of Saved POVs and ExoVars by ExoInsight environment, Application, and/or Database.
Sparse BSO cube query optimization
WITH ExoPowerPOV syntax, enabling the creation of on-the-fly members and rollups.
Improved SSO user interface when logging in
Version 8.6.2.5
Bug Fixes
An error occurred while refreshing a PBCS connection in Tableau after the initial creation was complete.
Version 8.6.2.4
Bug Fixes
Older versions of Tableau (2020.3 and lower) displayed an error message when connecting to PBCS data sources.
Version 8.6.2.3
Enhancements
PBCS now allowed as a PBCS environment name.
Bug Fixes
Member names with parenthesis ( and ) are now allowed in the PBCS/FCCS POV String syntax.
Enhanced encryption of all usernames and passwords in the configuration file after frontend operation.
Automation Builder no longer creates unnecessary zip files.
Fixed an issue with "leaveHyperFileOnServer" not working as expected.
Version 8.6.2.2
Bug Fixes
Fixed issue with Essbase or PBCS/FCCS environments not showing up properly in the Automation Builder.
Version 8.6.2.1
Enhancements
Enhanced logging for PBCS operations.
Version 8.6.2
Enhancements
SmartView to POV String conversion tool for PBCS and FCCS
Member Combinations functionality for PBCS and FCCS. Allows granular control over associating members from one dimension to another.
Version 8.6.1
Enhancements
Admin-only environments. Enables ExoInsight admins to use environments specifically for them that may have different query limits.
Substitution variables are displayed for PBCS.
Version 8.6.0
Enhancements
POV String looping for PBCS: now base members can be used in loops if security is restrictive to top level members.
PBCS missing/blank records are no longer returned to the result set.
Essbase Query Limits: Cube-level row limits can be set to control the size of queries executed through ExoInsight.
Speed enhancements made when navigating the outline tree.
Version 8.5.1
Bug Fixes
A bug has been resolved that was causing performance issues when loading to a relational database.
Version 8.5.0
Enhancements
New flags for relational database integration: dimensionNamePrepend and dimensionNameColumnPrefix
Automation Builder screen available to all
File download available from Automation Builder screen
Columns have been added to the dimension extracts that include aliases for each generation.
An option was added to the relational database integration that allows the user to specify the table name prefix for dimension tables.
The ability to output dimensions to delimited flat files was added.
SSL certificates that include multiple DNS entries is now supported.
Bug Fixes
Under some circumstances, the Tableau Web Data Connector (WDC) can hang upon loading from the WDC screen to Tableau, even though the data loaded fine in the WDC.
An error occurred when running a POV String with a member name that included a parenthesis in the level0 function.
Version 8.4.2
Bug Fixes
When utilizing the loops feature of the POV String, if the first query did not return any results then the result set would have incorrect column names.
When using the Google Sheets Add-in for Essbase, submitting data while using the Member Name and Alias preference would revert the retrieve to using member names only.
Version 8.4.1
Bug Fixes
The data-load portion of the relational database push would not create the data table for certain relational database destinations under certain circumstances.
Version 8.4.0
Enhancements
Improved Essbase Report script handling
Bug Fixes
After a post-load calculation was run, the pre-load calculation script was being written to the log file even though the correct post-load calculation was executed.
Version 8.3.12
Enhancements
Aggregation operator column added to metadata output when UDA_MF is true
The ability to call a calculation script before and after an Essbase load
Bug Fixes
CSV output when using MDX requires a POV parameter as well
Version 8.3.11
Enhancements
Row limit option for Google Sheets Add-in/ExoInsight Excel Add-in
Bug Fixes
PBCS Query Builder leaves option does not pull only bottom-level
Version 8.3.10
Bug Fixes
Essbase Load Alteryx plug-in was only running in Dry Run mode
Version 8.3.9
Bug Fixes
TruncateDataTable:false was causing an error when running the relational database integration for PBCS/FCCS
Version 8.3.8
Bug Fixes
GetSelectStatement in CLR was not performing correctly with new POV String syntax
TruncateDataTable:false was causing an error when running the relational database integration for Essbase
Version 8.3.7
Enhancements
KNIME support for PBCS
OpenJDK 14 support
Version 8.3.6
Enhancements
Support for CLR
Version 8.3.5
Enhancements
The ability to modify the default port for ExoInsight
Enhanced functionality for KNIME integrations
Version 8.3.4
Enhancements
KNIME support
Version 8.3.3
Enhancements
Loops functionality available for file export (Essbase/PBCS/FCCS)
POV String loop syntax
CSV file export option
Version 8.3.2
Enhancements
All #Missing records will be removed when using the NONEMPTY operator in POV String syntax
Version 8.3.1
Enhancements
The ability to add custom SQL prior to and after the relational database export runs
Enhanced metadata available - member formulas, UDAs, attribute values, etc
The username and password is now encrypted in the configuration file
Automation Builder for Essbase/PBCS/FCCS
FCCS support
Version 8.0.0
Enhancements
Load data to Essbase from Alteryx
Relational-to-relational REST API
In-place upgrades available
Version 7.7.2
Enhancements
Support for the Oracle PBCS source system
Alteryx
Relational database integration
Tableau (direct connection and hyper file creation)
SSL support
ASO export parser
Outline parser
Essbase report script syntax support
DateAdded field added to data and dimension exports
