Release Notes: Reporting

May 2021

Edit Static Sub-Reports In Report Editor

We have restored your ability to make edits to static sub-reports within the report editor. Please note, users can still create sub-reports in the sub-report builder but we’ve re-enabled your ability to make in-report edits.

How to get there: Orion Connect > Reporting > Custom Reports > Edit
Bar Charts: Hide Empty Date Ranges

Users can now hide empty date ranges on bar charts.  Prior to this development, if you were running a report for a client who had no activity for a displayed date, it would show as blank on your report. With the “Hide Empty Date Range” option checked the system will remove those empty data points from the report. This adjustment allows for more dynamic, cleaner looking reports.

How to get there: Orion Connect > Reporting > Sub-Reports > Bar Chart > Right Hand Menu > Hide Empty Date Range

April 2021

Multiple Activity Options On Bar Charts

This is a Report Builder enhancement that allows users to pull in multiple activity options within Bar Charts. This allows users more flexibility when it comes to presenting their clients data.

How to get there: Orion Connect > Report Builder > Sub-Report Builder > Select Bar Chart from the Charts menu at the top of the page > Set the grouping to “Activity Options” > Choose and add multiple activities.
Default Report Access

We’ve updated the logic behind which users get access to Orion reports.  Previously all new reports created in Report Builder were automatically made available for all advisor and admin level users at a firm.  Now, when a new report is created, database-wide access has been removed and the report only enabled for the user who created the report as well as the other users with the same role assignment as the report creator.  This change affords users the ability to be more intentional with who they are granting report access to.  

How to get there: Orion Connect > Reports > Actions Menu > Report Access
Query Builder: As of Date in Run Prompt

Previously, if a query was built in Query Builder it would require you to have a start date and end date associated with the query to produce an output. With this update, if a query doesn’t contain any columns that return values (ex: performance or activity) the run screen will now just show a single date picker.  

How to get there: Orion Connect >Query > Query Builder> Run
Query Builder: Context Filtering

With the addition of Context Filtering, Orion’s Query Builder app becomes even more powerful. Previously, when creating a Query to run for every account in the database, the filter could only look for data that existed at the same level you ran the query for. For example, if running the query for Accounts in the database, you could filter out any accounts that have a specific management style assigned.

Now with context filtering, you can create more complex queries that:

  • – Only show the value of a specific asset category within all your accounts
  • – Return every household in your database that holds a specific product, along with the total value of that product in the household.
  • – Show how much each household has invested in a particular asset class on a specific day.
How to get there: Orion Connect >Query > Query Builder
Transaction Options: Include Cash Exchanges Option

We’ve added an additional control to transaction reporting settings within Orion. In Report Settings, a user can now adjust the Transaction setting to Include Cash Exchanges.  If left unchecked, reports will exclude any buy/sell exchanges into or from a cash asset. When turned on it will show this activity. This enhancement provides users more flexibility when it comes to building reports.Note: This new control only impacts Orion Reports. The buy/sell exchange activity will still exist in the system. 

How to get there: Orion Connect >Reports> Report Settings> Transaction Option
Cost Basis Option - New Report Control

Prior to our April release, if a user was to add the Long Term Gain Loss or the Short Term Gain Loss data tag to a Sub-Report, both of those tags would display the net of gains or losses. We’ve now added a control that allows users to utilize those existing tags and specify whether they want to display gains, losses, or both. Users can access this new control by editing the Cost Basis Options in Report Defaults and is adjusted by using the “Display Gains or Losses” control at the bottom of the options pane.

How to get there: Orion Connect >Reports> Report Settings> Cost Basis Options> Edit or Clone

March 2021

Tag Specific Filtering

Our users are always looking for ways to have more control within their reports and one of the more commonly requested items in recent months was the ability to apply filters to individual @ tags in Report Builder.  We’ve added this new functionality with our March release.  If a user has access to edit sub-reports they can now filter data on a specific tag without having to filter the entire sub-report.

How to get there: Orion Connect > Reporting > Sub-Reports> Click on any @ tag > click the filter icon> select and apply filter criteria > Click Ok > Save
Estimated Income in Charts

Advisors are always looking for different ways to present data to their clients – and a number of firms were looking to show their clients their estimated annual income in a chart format instead of the usual table.  With this new release users will now see Estimated Income as a data source for Bar, Pie, and Line charts in Report Builder.

How to get there: Orion Connect > Reporting > Sub-Reports> Pie Chart > Left Click the Pie Chart> Set the Data Source to Estimated Annual Income> Save
Column Grouping Enhancement: Null Values

Our Column Grouping tables have been having new features added over the last few months – And this month is no exception – Column Grouping Tables will now allow users to update the text or values displayed for null values.  Don’t want to see 0% or $0.00 on your report?  You can now use the Format section of the report to override what appears in place of those values. 

How to get there: Orion Connect > Reporting > Custom Reports> Edit> Click Format on the Right Side Menu> Add in Desired Text Override> Save
Maturity Date: Options For Next Call or Pre-Refunded Date

Our users like variety and no two firms are exactly the same – One of the most requested items that our squad has worked on was introducing settings to allow users to choose between Maturity Date, Next Call Date, or Pre-Refunded Date to give extra clarity to when their clients will receive their bond payment. This new option can be set up in the Income Settings within the Reporting App.

How to get there: Orion Connect > Reporting > Report Settings> Income Settings> Click Pencil to adjust the Modified Duration Market Date > Save on Modal> Save Settings

February 2021

Report Default Settings

With the new Report Settings feature, advisors can increase their efficiency with default settings that are automatically applied to all new reports. This development will also work hand in hand with the default settings controls on Report Builder Data Tags. This feature is only available to those who have the Report Builder – Advanced Editor permission and can be enabled in the Manage Users app.

How to get there: Orion Connect > Reports App > Left Side Bar : Report Settings

January 2021

Sub-Report Builder

To improve our advisor’s user experience we split out Sub-Report editing from the current report editor. This initial offering relocates the editing of sub-reports to a standalone section within the Reporting app.  

Please Note: The ability to edit reports in the current editor will be removed in our February release – at which point edits can only be made in the Sub-Reports editor.

How to get there: Orion Connect > Reporting App > Sub-Reports
Dynamic Sub-Reports

To make report building easier and more efficient, we released Dynamic Sub-Reports, which allows users to build either a Dynamic or Static Sub-Report. Dynamic Sub-Reports allow a user to build a Sub-Report, add it to reports, while adding logic that allows you to dynamically update all reports that hold it.  This is a huge efficiency and a big step towards improving user experience. Don’t miss our webinar, Orion Reporting : What to Expect in 2021 (And What You May Have Missed in 2020), LIVE on January 26 and then available On-Demand.

How to get there: Orion Connect > Reporting App > Sub-Reports > Edit > Right Hand Menu

December 2020

Partial Ownership Part II

We have updated our UI and added functionality to the account level editor screen that allows you to add a Reporting Only Account to multiple households at once.  Bonus: we have also added a Custom Import to add these en masse.

How to get there: Orion Connect >Portfolio Audit > Edit Account> Reporting Only Households (on the left)
PDF Insert Part II

This new update corrects logic that created unnecessary blank pages when PDFs were placed at the beginning, end, or consecutively within the report. 

How to get there: Orion Connect >Report Builder > Media > PDF Insert
Subtotal Tag

Currently, when a value tag is added to a table footer or header it has the context of the grouping it’s in. The new subtotal tag feature adjusts that context so that it totals up the whole grouping rather than just the grouping for the value tag.

How to get there: Orion Connect >Report Builder > Grouping Table> click on value tag> calculator menu option
Column Grouping Enhancement

Table functionality has been improved through your ability to add in columns within the “Column Grouping” section of a “Column Grouping Table.”

How to get there: Orion Connect >Report Builder > Column Grouping Table

November 2020

PDF Inserts for One Off Reports

Up to this point the only way you could have a PDF attached to an Orion report was to run the report in the Report Batches App or append one manually using a third party program. Not anymore. We have added a new insert option to Report Builder that allows you to include a PDF within standalone reports. We have even more development planned to really round out this new functionality – so stay tuned.

How to get there: Orion Connect > Report Builder > Edit Report > Media Dropdown > PDF
Model vs Actual on Charts

One of the most requested items we’ve heard from our advisors was enhancements to our Model Inclusion Grouping within Report Builder. Model Inclusion splits out what is in a respective model and what isn’t. After launching Model Inclusion we had a number of firms ask to see this information combined into a single element and that’s where our new Model vs Actual grouping comes in. This shows what is in model and what isn’t within a single table instead of breaking it out. Even better – you can now use this grouping within a number of our charts.

How to get there: Orion Connect > Report Builder > Edit Report > Chart>  Grouping : Model vs Actual

October 2020

Report Builder Lite

A number of firms have reached out to us with a request for a middle ground level of access for the Report Builder tool.  RB  Lite accomplishes this. It will allow users to access sub-reports without making changes to the actual sub report. They can build new reports with sub-reports they have been granted access to, change the sub-report placement and/or remove the sub-report entirely.

How to get there: Orion Connect > Manage Users > Roles > Privileges > Actions > Reporting > Report Builder - Advanced Editor
Report Builder - Hide Symbol On Charts

Charts within Report Builder now have the ability to hide $ and % signs on the X and Y Axis.  

How to get there: Orion Connect > Reporting> Chart > Appearance > Hide Symbol

September 2020

Improved Accounting for Partial Ownership 

Previously, all accounts defaulted to 100% ownership by the advisor in question. This month we have improved this functionality to provide a more accurate view into account ownership by giving you the ability to designate a percentage of ownership for individual accounts.

How to get there: Orion Connect > Portfolio Audit > Edit Household > Reporting Only Accounts > Add > Enter in % amount owned
SMA at the Transaction Level in RB3 and QB

To enable a more detailed and granular view into your separately managed accounts, we have allowed for SMAs to be viewed at the transaction level within Report Builder 3 and Query Builder.

How to get there: Orion Connect > Reporting

August 2020

Allocation as a Data Source

This month, we’ve added the ability to use allocation as a data source iIn report builder by simply clicking the bar chart and typing in “allocation” in the data source field of the editor. This update enables your firm to create more accurate visuals for allocation-focused bar charts while also providing more aesthetic diversity to the reports you build.

Orion Connect > Reports App > Custom Reports >Edit > Left click on an existing bar chart or add a new one > Under configuration enter in Allocation and select “Allocation Level 1

July 2020

Schedule Data Queries to Run Across Multiple Databases and Groups

Currently, users are only able to schedule data queries if they run for a single database. Users with access to multiple databases can now schedule a data query across those databases, so you only have to schedule one query and can review the data in one file. You can do this through the “Run For” section in the scheduler set up box, which allows you to select from: Current (will only run the query for the database you are scheduling the query in), Multiple (a pop up allows you to select all the databases you have access to), and Group (a pop up allows you to select the database group you want to run the query for).

Orion Connect > Query > Orion Queries > Right click on a query > Schedule Query

May 2020

Model vs. Actual Insight Tile

With this update, we created a new Insight tile to display the actual allocation of an entity compared to the model allocation. The data will be pulled from actual values in the Orion system and the allocations assigned using the model aggregates. You’ll be able to see the data in a bar graph or table format.

Orion Connect > Insight > Create a new dashboard or open an existing dashboard > Add Tile > Trading > Model Versus Actual
Report Builder Asset Class Abbreviation Tags

Currently, there is Asset Class Name as an available tag in Report Builder 3, which is great for grouping tables when asset class is used as the grouping. We used the same methodology, utilizing Asset Class Abbreviation, so you can also show a shortened name in charts.

Orion Connect > Reporting > Custom Reports > New Report > Charts > Bar Chart > Appearance > Label Format > @ Asset Class Abbreviation
Report Version Assignment Import

For those who have access to edit a report in Report Builder 3, you can now add client assignments to a version of a report in mass, so you don’t have to add them one at a time. The import will have columns for Broker Dealer, Rep, Client and Portfolio Group so you can import this information for reports quicker than ever.

Orion Connect > Custom Imports > Import Templates > RB3 Version Assignment Import or RB3 Version Assignment Update