Release Notes: Reporting

See All Release Notes

Share:

January 2022

Reporting Stability Work

We improved report generation speed, improved usability of Report Preview, addressed some bugs, and focused on delivering a more stable platform to our users.

How to get there: Orion Connect > Reporting > Report Builder
Query Builder Data Points

We have added additional data points to Query Builder. The new data points available are as follows:

  • Household Created Date
  • Is Active Household (True/False)
  • Qualified Investor (True/False)
  • Statement Transmission Method
  • US Resident (True/False)
  • Managed Account (True/False)
  • Transaction ID 

 

How to get there: Orion Connect > Query > Query Builder > New Query/ Edit existing > Next > Click column to add
Query Builder Search Enhancements

Keywords have been added to common data tags to make finding your perfect data point easier.

How to get there: Orion Connect > Query > Query Builder > New Query/ Edit existing > Next > Search columns

December 2021

New Tags: Number of Assets / Number of Products / Estimated Tracking Error

Orion is constantly adding new data tags that you can pull into Orion reports and queries.  With this release we have three new tags that will further expand your reporting capabilities.

Number of Assets – will display the number of assets for a given level (Household, Registration, Account, etc)

Number of Products – will display the number of products for a given level (Household, Registration, Account, etc)

Estimated Tracking Error – pulls tracking error data into reports – can also be used in our gauge chart.

How to get there: Orion Connect > Sub-report builder > grouping table > Type in @ Number of assets
Stacked Bar Charts

Stacked bar charts come in handy if you want to show asset category allocation over multiple time periods in a single column versus the old experience of a cluster of closely stacked columns.  This development will allow for cleaner and easier to read reports.

How to get there: Orion Connect > Sub-report builder > Bar Chart > Click on bar chart and click “appearance” in the right hand menu > Bar chart stacking
Astro: Account Level Tags

Astro users now have the ability to pull in the following data tags:


Account Capital Gain Budget

Account Short-Term Tax Rate

Account Long-Term Tax Rate

Account Tax Transitioning

Account Tax Transition Year

How to get there: Orion Connect > Grouping table > click in a cell > add tag
Rename Columns in Query Builder

Thanks to your feedback, users now have the ability to rename columns within custom built queries.

How to get there: Orion Connect > Query > Query Builder > New Query/ Edit existing > Pencil icon by column name
Add Multiple Columns Using Same Data Tag in Query Builder

With our December release, users will now have the ability to add multiple columns using the same data tag.

How to get there: Orion Connect > Query > Query Builder > New Query/ Edit existing > Next > Click column name > to add again click column name again
Ignore Prompt in Query Builder

This development will allow you to add multiple columns using the same data tag in Query Builder.

How to get there: Orion Connect > Query > Query Builder > Run > Select ‘Ignore’ next to prompt
Error Message - View No Longer Matches for Query/Query Builder

This development will display an error message if a user runs a query ‘to screen’ and their saved view no longer matches due to a change in the query. 

How to get there: Orion Connect > Query > Query Builder/ Orion Queries > Run query to screen

November 2021

Sub-Report Preview

Orion is committed to constantly improving our tools – and this month we’re releasing some development that will greatly improve users’ ability to build and review sub-reports.  With Sub-Report Preview a user can now generate sub-reports using client data without having to save the sub-report, update it in the report, resave, and rerun.  Users can now simply click the preview button and the system will show you on screen what your report output will look like. 

How to get there: Orion Connect > Reporting > Sub-Report Builder > Actions > Preview
Column Grouping: Other %

We’ve streamlined functionality between our Grouping Tables and Column Grouping Tables by introducing the ability to use the other % functionality in Column Grouping.

This function works with our limit method to allow users to bucket things like asset classes that have small residual holdings into another % category.  This helps reports look a bit cleaner for the end client and ensures that you aren’t wasting valuable report space by showing the client holdings where they hold a handful of residual value assets.

How to get there: Orion Connect > Reporting > Sub-Report Builder > Column Grouping Table > Right Hand Menu > Under Column Grouping > Change Limit Method to Count or Threshold > Check “Show Other Group”
Allocation Tag Improvement

Here’s another project that we’ve introduced to make building reports easier.  We’ve gotten feedback from users that there is confusion when it comes to which allocation level tag to use when building reports.  Well – we’ve just made it so much easier.  

 

With the Allocation of Parent tag the system will automatically determine the allocation level based on the grouping you have the tag in.  No more wondering if you need to use allocation level 1 or allocation level 5 – We’ll do it for you. 

How to get there: Orion Connect > Reporting > Sub-Report Builder > Select an advanced grouping wrapper > drop in a grouping table > add in Allocation of Parent tag
Query & Query Builder Views

This update allows users to add/save custom views on queries run to screen in Query and Query Builder.

How to get there: Orion Connect > Queries > Query/Query Builder > Run (Run to Screen) > Pencil and Paper icon on the Right-hand menu
Query Builder Data Tags

This development allows users to add new data points (account status and business line) in Query Builder.

How to get there: Orion Connect > Queries > Query Builder > Create/Edit > Columns
Update UI for N/A filters in Query Builder

This feature allows users to use ‘N/A’, ‘null’ or leave the cell blank when filtering for N/A results.  Displays a visible N/A to users’ filters in Query Builder.

How to get there: Orion Connect > Queries > Query Builder > Create/Edit > Next > Next > Add Filter

October 2021

New Tag: Sub Advisor

Within Orion, you have the ability to assign subadvisors to accounts.  With this development we have given users the ability to now show this assignment on reports. 

How to get there: Orion Connect > Reporting > Sub-report builder > create new or edit existing sub-report > add new tag for Sub Advisor
New Grouping: Product Sub-Type

More users are taking advantage of the Product sub-type distinctions within Orion Connect, so we have created a new grouping that allows users to group tables and charts by this identifier.  This creates more options for users as they build out reports in Orion.

How to get there: Orion Connect > Reporting > Sub-report builder > create new or edit existing sub-report > right click and and hover over grouping options and set to Product Sub-Type
Sub-Report Preview: Choose Orientation

We are making the building and editing of sub-reports better by introducing some new functionality within the sub-report builder.  In this first phase of our sub-report preview development a user can now switch between portrait and landscape on the sub-report builder page.  In our next release we will add a Preview button to the actions dropdown that will allow users to run sub-reports at multiple levels (household, account, portfolio group, etc) choose a date, theme without having to save the sub-report and run it as part of a full report.  This will be a big efficiency when it comes to building out new sub-reports.

Note: Preview orientation is NOT saved.

How to get there: Orion Connect > Reporting > Sub-report builder > create new or edit existing > Right-hand menu > layout

September 2021

Currency In Custom Calculations

In recent months we added the ability for users to run reports in different currencies within Orion reports.  This is a continuation of that development – We are now bringing that currency adjustment into custom calculations that users have created.  It is important to note that this will only impact activity style custom calculations.

How to get there: Nothing to do here - this just now impacts custom calculations.
Default Report Access

A few months ago Orion made adjustments to which users got access to newly created reports in Orion.  This development led to some unintended roadblocks for some of our users, so we are rolling back this development and restoring it to what it was previously.  Report admins will again have access to all Representative level reports that are created in the system – making report management easier. 

How to get there: Orion Connect > Reporting > Custom Reports
Remove Unmanaged Journal Offsets from Activity

Over the last few years we’ve had a number of clients ask for a way to hide unmanaged journal offsets from our reports.  The feedback that we’ve gotten is often that “clients find this detail to be confusing.”  We’ve heard you and have added the ability for you to remove this detail from your reporting.  This option to hide unmanaged journals exists within the activity option control within your report settings.

How to get there: Orion Connect > Reporting > Report Settings > Include Unmanaged Journals

August 2021

Multi-Currency in Report Builder

You now have the ability to change what currency you run reports in.  We have had a number of firms ask for this development over the last several months and we have now made it available to you.  You can set this default currency at the household level or adjust it one off when running reports.  Our initial offering will allow you to run in 10 other currencies other than US Dollar.   

How to get there: Orion Connect > Reporting > Run Report> Choose household and date > click next > General > Household Currency Override> Run Now
New Tag: Account Active Status

One of our more requested new tags for queries and reports was a tag that showed whether an account is active or inactive.  The addition of this new tag will really improve the flexibility of tools like Query Builder. 

How to get there: Orion Connect > Query> Query Builder > Edit or create new query> Click columns > Select Account Active Status > Save
Account Change History Custom Import

We have added the ability to update Account Change History en masse.  Prior to this development adding in a large number of account change history was an account by account process.  This development will create efficiency and scale for your firm.  To review how Custom Imports can work for your firm, review the “How-To and Overview : Custom Imports” Orion Support article. 

How to get there: Orion Connect > Custom Imports > Import Templates > Account Change History
New Grouping: Sleeve Strategy Aggregates

We’ve added a new grouping that will allow users to create tables grouped by Sleeve Strategy Aggregates. 

How to get there: Orion Connect > Reporting > New Sub-Report> Table > Right Click> set grouping to Sleeve Strategy Aggregate

July 2021

New Tag: Group Close Date

This new tag will allow users to show when an entity has closed out within Orion. For instance if you held Apple until the first of the year and included this tag in a product level grouping table the Apple position would show a group close date of 1/1/2021.

How to get there: Orion Connect > Reporting > Sub-Reports > New > Actions > Data Library
New Tag: Contribution to Return

This new tag will help calculate the contribution an individual asset had to the overall return for an account within a given period. This is based on the assets daily performance value and weight within the account.

 More detail can be found in the “Contribution to Return Calculation” Support article.

How to get there: Orion Connect > Reporting > Sub-Reports > New > Actions > Data Library
New Tag: Alternative Recallable Distributions

This new tag will pull in recallable distribution amounts from our Account Composer app of Orion Connect. 

How to get there: Orion Connect > Reporting > Sub-Reports > New > Actions > Data Library
PDFs as Sub-Reports

We’ve added the ability for PDFs to exist in the system as a sub-report, creating increased efficiencies when it comes to managing supplemental communication within reports. 

How to get there: Orion Connect > Reporting > Sub-Reports > New > Media > PDF
Reporting UI/UX Improvements

As part of our continued improvements to system responsiveness, sub-reports will now load more quickly. 
We have also adjusted our default sub-report type to dynamic instead of static. Dynamic sub-reports can be pulled into multiple reports in the system and updated at a single point in the system – where static type sub-reports (if included in multiple reports) would have to be edited in each individual report.

How to get there: Orion Connect > Reporting

June 2021

New Tag: Time Based Custom Field

We have added a new custom field option for Time Based Custom fields. Unlike some of our other custom fields, this has a table that can store multiple entries. You can also display the field value based on the report end date.

How to get there: Products & Prices > My Current Products > Select Product > Right Click > Edit Product > Settings: Time Based Custom Fields
New Chart Type: Gauge

We have added a new visual option for users to show their clients data in a different format.  With the addition of the gauge chart you now have a different way of showing clients risk.  This chart also lays the foundation for other development we have planned in the coming months.

How to get there: Orion Connect > Reports > New Sub-report > Charts > Gauge
Eclipse Model Tolerance: Display Relative Difference

One of the most common requests we get is to include relative difference in our Eclipse Model Tolerance sub-report. This is one of the first improvements we are adding to this sub-report and we have more planned in the coming months.

How to get there: Orion Connect > Reports > New Report > Eclipse Model Tolerance > Settings on the right hand menu
Multi-Currency: Default Currency

We are working on adding the ability to run reports in other currencies. The initial development is a future use field that will allow you to run reports in a selected currency.  You can set it as a default for a household or in the future opt to run in a different currency the moment you run the report. 

How to get there: Orion Connect > Portfolio Audit > Edit> Options > Reports> Default Currency

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

2445-OAS-09/23/2020