Release History

Version 3.4.16

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

Version 3.4.15

  • 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

Version 3.4.14

  • 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

Version 3.4.13

  • 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

Version 3.4.12

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

Version 3.4.11

  • 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)

Version 3.4.10

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

Version 3.4.9

  • Additional fixes to URL-decoding on the dimension names

Version 3.4.8

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

Version 3.4.4

  • 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

Version 3.4.0

  • Turn CSV headers on/off as needed

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

Version 3.3.1

  • 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

Version 3.3.0

  • 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

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

Version 3.1.1

  • 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

Version 3.1.0

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

Version 3.0.0

  • 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

Version 2.0.4

  • 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

Version 2.0.2

  • 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 the 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

Version 2.0.0

  • 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

Version 1.5.4

  • Excel download button suppressed on printing

  • Fixed issue in Excel generator where null values threw an exception

Version 1.5.3

  • 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

Version 1.5.1

  • Honors the alias=Table flag on an Essbase Member Resolver

  • Bring back aliases tab

  • Bring back Advanced menu

Version 1.5.0

So. Much. Good. Stuff.

  • 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

Version 1.3.4

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

Version 1.3.3

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

  • Server-side paging with DataTables is in!

Version 1.3.1

  • 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.

Version 1.3.0

This is a major release! There are tons of new and enhanced features in this release. Major features of this release:

  • 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:

    • Amount column should be right-aligned.

    • Space between 2 lines is too large

    • add a little bit more of contrast between the background colour of 2 lines in the report

  • Deployment Specs can now have a description

  • Should respect Locale for various column types:

    • Date

    • Timestamp/Time

    • Decimal/Double/Float

    • Integer/Numeric/BigInt

  • 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

Version 1.0.2

  • 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

Version 1.0.1

Some minor and not so minor updates:

  • 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

Version 1.0.0

This is the initial public release of Drillbridge. Certain features are disabled for now:

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

  • Automatically deploying reports to an Essbase cube