Release History

Added support for LDAP and MSAD as authentication servers for Drillbridge users/admins

Support for Oracle OAuth 2.0 provider as an authentication provider

Ability to designate user accounts as admin, federated (external), or both

Ability to configure each report to require or not require authentication

Updated version of Java Service Wrapper from 3.2.3 to 3.5.54

Drillbridge now ships with binaries to run on macOS in addition to existing support for Windows/Linux

Default attribute dimension value behavior has been updated to use the attribute dimension name itself instead of an empty string

JDBC-based drill reports now support "default" attributes so that you can build a query that may use attribute dimension members that may or may not be part of the drill request

Enhanced Forwarding Link report type to allow additional parameters for POST request type

Added "always use form submission" and "form window handling" options to Forwarding Link Report. These options help drill-through use cases when using the Redwood Experience theme in EPM Cloud. To drill, turn on the "Always Use Form Submission" option and set Form window handling to Blank, which will open a new browser window/tab

Added line removal expression capability for dynamic/enhanced control of line removal

The resolve_shared flag is now honored for PBCS connections

Updated Oracle JDBC drivers that are compatible with ATP/mTLS

Added support for interpreting drill-through requests from EPM Cloud Reports that have been defined using Drill to Content on grid definitions

Update jQuery version (security update)

Can now opt specific columns out of smart formatting

Excel download will honor scale/precision of numeric column types

Fix issue with auto-sum rows with null value when using drillable columns

Documented a technique for updating the top of a report with completion status

New option to force + in member to become a space (workaround for issues with Firefox/Chrome)

Sort drillable column names alphabetically when using dropdown type

Better description for Smart Formatting option

Add HTTP headers to debug mode

Remove session pinning/force check options from settings UI

Remove topology codes from UI

Improvements to Excel caching option to make consistent with session timeouts

Disable viewing drill definitions for PBCS types

Fix issue with drillable columns not working when using session security

Fix issue with deleting a cube mapping

Essbase REST API support

Show report logical IDs in reports page

Whitespace is automatically trimmed off of JDBC URLs (DRB 154, DRB 142)

Disable X-Frame-Options, which prevents Drillbridge from rendering in a frame (Oracle Redwood theme)

Additional fixes to URL-decoding on the dimension names

Special/enhanced handling for members with +, special characters, and more

Drill-through Definition Sorter

OBIEE Report Type

JDBC Fetch Size option

View drill definition details from Drillbridge

Copy Drillbridge report

JavaScript report type

Caching Policies, Caching (Excel)

Advanced Security Options

Use Variables in Templates

Logical Aliases

Advanced Member Resolver / Custom Mapping Handling

Progress Indicator Option

User Parameter Changes

Max Rows to Show in HTML

Servers & Connections now in one place

Session Handling Security Changes

Turn CSV headers on/off as needed

New model variables: ${drb.totalRows}, ${htmlRowLimit}

Cleanups/fixes/additional info on token editor page

Issue uploading/saving custom mapping

New flag to alphabetize all entries from custom mapping or cube outline

New JavaScript-based drill report

Fix issue with drill report name when using manual code to deploy to EAS/Calc Designer

Can now sort tables of connections/servers/reports

Can edit description of report

Support for APS servers

Use given protocol for Drillbridge server URL or default to http:// if none given

You can sort connections/servers/reports by various columns, such as name, connection, and description

Enhanced descriptions on various text fields in UI

Fixes when deleting a server entry

Query row limit and query timeout options have moved to the general options page.

You can now edit the internal description of a report

You may now specify http:// or https:// as part of the server name when deploying a report. Previously, https:// was assumed and organizations using Drillbridge over HTTPS had to manually edit the drill-through definition

Enhancements to drillable columns. There is a new rendering type for drillable columns that renders with an arrow instead of a link. This is useful for reports with drillable columns where there are multiple drillable column definitions in the same column

New Inline CSV file download. New option to turn on "inline" CSV downloads such that CSV output is shown directly in browser instead of being a download

Auto sum rows: new option to automatically sum all or some of the columns in the drill-through report

Throw a nice error if wrong Java version detected

Throw a nice error if Drillbridge cannot contact JDBC BLOB server on startup

Show message if trying to deploy to PBCS

Add new Server Type to servers functionality and allow to choose between Essbase and PBCS

Result caching feature

Better performance on result set pages

Custom options system for plugin reports

Enhancements for Forwarding Link report

Download directly to Excel option

Cache configuration settings

Enhancements to GUI

Works with PBCS

Prompt for credentials and database authentication options

Ships with PostgreSQL driver

Auto hyperlinking enhancements

Auto number columns option

Remove pageResults from report table

Remove resultsPerPage

Remove row count query column from reports table

Create a new DrillReport representation that exists in drillbridge-plugins and make it the intermediate representation of a report definition. This will be the object that gets passed to factories. It will also be the object that gets validated by the report validator.

New POV object as an ADT to provide some richer functionality and help with caching

Move custom CSS to a separate page

New MDX drillthrough report plugin

Working/temp folder will now default to inside the Drillbridge install folder

Removed row count query and paging options from report (will now be separate plugin type)

Text cells starting with http:// will be turned into hyperlink cells in Excel output

Smart formatting will cause an HtmlLinkColumnPrinter to be used instead of DefaultColumnPrinter

Clean up tabs on Settings

Fix issue with Drillbridge admin password containing a dollar sign

Fix text on deploy page (was copied from test page)

Remove Code tab from reports — now available from Deploy tab if needed

Option to breakup table printing into groups to improve rendering performance

Option to auto-number columns

General options infrastructure allows custom reports to have a UI for their options

Bump Spring Boot from 1.2.4 to 1.2.6

Smart Formatting option has now been moved to a custom option on JdbcDrillthroughReport

Add short token support — such as {#Scenario} tokens

Reduced memory footprint by disabling sample DB

Overflow support

Drillbridge admin credentials no longer in file, now stored in DB and encrypted

Forwarding Link Reports by way of setting — class: in report text

SQL Member Resolvers

Dropped "max_members_on_drill" global setting property (new overflow feature provides better functionality)

Paging/pageable reports have been disabled for now

Bug introduced: saving custom mapping without uploading file wipes the entries

Excel download button suppressed on printing

Fixed issue in Excel generator where null values threw an exception

New modular function system

Better Excel downloads in Firefox web browser

Brought back classes for table rows and columns in HTML output

Small cleanup to error template

Lots of internal changes to accommodate custom modules

Fixed issue with drill-to-drill always pointing to itself

Fix SSO token issue on drill-to-drill

Add link to main page on DrB login page (convenience!)

Add GUID to Reports

Honors the alias=Table flag on an Essbase Member Resolver

Bring back aliases tab

Bring back Advanced menu

Can run on Linux, AIX, Solaris, Mac OS X, and Windows

Drillable columns

Better Excel output — now with XLSX instead of XLS, better date/time/timestamp/float/double/integer formatting

New custom mappings feature

A raft of bug fixes

Added a context path variable to make proxy/redirects work more easily

New streaming output strategy for MUCH better performance on large result sets!

Server-side paging with DataTables is in!

System now saves the current server as a variable (Peter N)

Can now see and edit a Description for Variables

Now must specify a server before deployment will work (Peter N)

Connection editing now shows JDBC URL examples (used to only show on New Connection)

Connection Edit/New Connection now use same template (under the hood change)

Updating a report now leaves you on the report edit page

Changing the name of a report now displays message that the report definition needs to be updated in EAS or redeployed (but does not auto redeploy...)

Servers has been promoted from the Admin menu to the main bar

Updating a report should keep you on that report

You can test unsaved changes to a connection or a yet-to-be-saved connection

New Connection setting is available that can run arbitrary commands to set up a SQL connection (useful to issue ALTER or SET commands on the database, if needed).

All variables from POV should be available, Drillbridge should not drop tokens it thinks are not required.

Saving the deployment spec no longer shows a blue "Warning! Saved Deployment Specification"

Duration is now logged for reports (Peter N)

Stats page shows duration, now sorted by time of execution, descending (i.e., newest executions on top)

Test report executions will now populate the drill execution history

New button to clear the report execution history

Query length now 8000 characters instead of 4000

Updated deployment XML — now includes id parameter! This should make Planning/FR drill-through [actually] work. Whoops.

Connection testing has been reworked and should now work on Oracle databases

Implement debug mode — can put reports into this mode to just show the generated query but not run it

Can now set a global stylesheet for all reports that are built (use to adjust spacing, etc)

Can now add/edit/delete variables (both user and system — be careful!)

New option to paginate results, provide PAGE, ROWS_PER_PAGE, and OFFSET variables to report

Ability to use variables in queries — global variables are prefixed with DR_. E.g., variable "server" can be accessed in query as #DR_server"

Rows and columns in drill report page now have CSS classes

Can add custom styles to individual reports — allows for some customization of how the report, table, rows, and columns will be displayed (might want text-align: right for numerics and such)

Database query now respects the row limit so the max rows can be capped

Reports now have a configurable query timeout value to limit the max number of seconds a query can run for. 0 is default.

Excel columns will now autosize (more improvements coming to Excel generation to fix text vs number problem)

Enhance logs to show queries that are constructed

Drills now quick-redirect to another page in order to improve Refresh, Previous, and Next page semantics (prevents resubmitting POSTed data, improves future features)

Include custom header and custom footer on report (supports HTML)

Drill-through definition XML is updated! Include fix for the SSO token

Formatting issues that are closed by way of custom stylesheets:

Deployment Specs can now have a description

Should respect Locale for various column types:

Localization: localize into French!

Implement statistics for tracking how much reports are being used

Excel download filename is now based on the name of the report

Drilling to descendants of a member is now limited to 1,000 members. This may be revised in the future but for now is meant to protect IN clauses for Oracle databases that don’t support more than 1000 items.

Removed Refresh button since it is now possible to use the browser refresh thanks to some under the hood improvements for pagination

Use the associated EssbaseCube (and therefore server) to validate SSO token

Move Connections/Reports to admin/ URL tree for cleaner security implementation

Now use connection name instead of description

Member drilling occurs under the credentials of the mapped user (typically admin) which means that the members pulled back are based on their credentials (in other words, members are not pulled with the credentials of the user performing the drill operation)

Allow new parameter on token, 'sampleValue' that allows to specify a default value to aid in testing (this value shows up on the test page, but doesn’t affect the execution of the report in any way)

In anticipation of some possibly long Oracle RAC and other verbose JDBC URLs, the JDBC connection string limit has been raised from 255 characters to 4000

Known issue: Essbase outline caching not enabled in this release

Include SQL Server file for integrated authentication

Can now edit server, cube, and deployment spec definitions

Include new expression language

Drill to children on Essbase cube works

Row limit on drill reports

Debug mode on drill reports

Update SQL Server JDBC driver to latest version

Fix for when query has no parameters in it

Notes about Java being required on the PATH

Added EULA

Query size can now be 4000 characters (was 255)

Parsing of payload from SmartView drill operation is now more robust

Cleaned up logging to try and reduce clutter a bit

Removed several unused/test dependencies, shaving 13MB off download

Now includes Oracle driver (thin client)

Show examples of JDBC URLs on connection creation screen

NOTE: Essbase Servers and Deployment Specs are still unused/unusable in this release. Reports need to be deployed manually

Upgraded several dependencies to newer versions

Support for drilling to level-0 members from an upper level member

Automatically deploying reports to an Essbase cube