Release Notes: Reporting

See All Release Notes

Share:

July 2022

Easily Run Multiple Reports at the Same Time with Report Packages (Beta)

You’ve gained more flexibility when creating client-specific report packages through the ability to run multiple reports for selected client(s) at the same time.  In addition, Report Builder now includes the ability to save, access, and delete report packages. 

How to get there: Orion Connect > Report Builder > Custom Reports > Create
Access All Your Client Data in One Centralized Report

Easily connect all your client data in one centralized platform through this Report Builder enhancement that enables Orion Planning users to include data from the Client Portal within reports. In addition, Orion Planning Action Steps and Orion Planning Goals Sub-Reports are now available. Be on the look out for Orion Planning Net Worth Table & Orion Planning Net Worth Charts that are coming soon!

How to get there: Orion Connect > Report Builder > Sub-Reports > Integrations > Search Orion Planning
Cater to More Clients with Alt Text On Images Within Reports

You can now cater to more clients with accessibility tools. This Report Builder enhancement enables you  to add an explicit alt text field to the image stored in the database; which will provide clients the ability to use the alternate text added to images while reading the PDF document.

How to get there: Orion Connect > Report Builder > Custom Reports > Create Report > Add Image > > Upload Image > Edit Alt text on image within configuration
Access Enhanced Date Range Report Settings

This enhancement simplifies the selection of a start date method by including the option to select inception, holding period, or AIP ledger within the start date/start expression drop down.

How to get there: Orion Connect > Report Builder > Report Settings > Edit Date Range Setting Type
Additional Security added to SFTP Queries

Gain additional security when scheduling a query using SFTP with the ability to test the validity of the credentials used.

How to get there: Orion Connect > Query > Orion Queries > Schedule > Load/Change Upload Target
Gain Efficiency with Report Batch Folders in the Client Portal

This enhancement provides you greater efficiency through  the ability to decide where report batch reports are saved and create new custom folders in the Client Portal. 

How to get there: Orion Connect > Reporting > Report Batches > New Report Batch (see Folder)

June 2022

(Beta) Report Packages

This is a Report Builder enhancement that allows users to run multiple reports for selected client(s) at the same time. This allows users more flexibility when it comes to creating client specific report packages. Beta testing includes the landing pages, overall layout, selecting reports, reviewing selections & generation of reports.

How to get there: Orion Connect > Report Builder > Custom Reports > Create Report Package (upper right hand corner)
Query/ Report Builder - Data Tags

We have added the following data tags: Wholesaler, Model Agg ID, Management Style, Abbreviation, Last Transaction, and Download Source.

How to get there: Orion Connect > Query > Query Builder > New/Edit Query > Next > Search Available Columns Orion Connect > Report Builder > Sub-Reports > New Sub-Report > Grouping Table
Query Builder Currency Enhancements

This enhancement will allow you to use a firm’s default currency selection based on the setting in firm profile.

How to get there: Firm Profile > Option Information > Reports > 'Default Currency' & Orion Connect > Query > Query Builder > New/Edit > Next until Filters/Prompts selection

May 2022

(Beta) Report Packages

This is a Report Builder enhancement that allows users to run multiple reports for selected client(s) at the same time. This allows users more flexibility when it comes to creating client specific report packages. Beta testing includes the landing pages, overall layout, selecting reports, reviewing selections & generation of reports.

How to get there: Orion Connect > Report Builder > Custom Reports > Create Report Package (upper right hand corner)
Cost Per Share (For Factored Bonds) Option

This is a Report Builder enhancement that allows users to adjust the way the Cost Per Share tag functions. Users now have the ability to identify the Cost Per Share Method that suits their firm (Valuation Price or Percentage of Par). 

How to get there: Orion Connect > Report Builder > Sub-Reports > add Cost Per Share tag to sub-report > Click on sub-report > select the cog wheel to adjust settings > Cost Per Share Method drop down
Alternative Cash Distribution Tag

This is a Report Builder enhancement that allows users to include the Cash Distribution Amount for Alternative Assets within Reports. This allows users more flexibility when it comes to Alternative & Ultra High Net Worth Reporting capabilities. 

How to get there: Orion Connect > Report Builder > Sub-Reports > Add Alternative Cash Distribution tag to sub-report
Query Builder Schedule Editor

This will change the ‘Save’ button to ‘Close’ on the Scheduled Queries editor (Query Builder) and remove the Cancel button (bottom right). 

How to get there: Orion Connect > Query > Query Builder > More > Schedule Query
Query SFTP Password Limit

This update will allow for a password limit of up to 128 characters when setting up an SFTP upload target. 

How to get there: Orion Connect > Query > Orion Queries > Right Click > Schedule Query > Load/Change Upload Target
Query Scheduler Updates

This update will no longer allow users to schedule a query if the day/time is not selected. A new dynamic date filename name will now be available for selection: yyyyMMddHHmmss

How to get there: Orion Connect > Query > Orion Queries > Right Click > Schedule Query > Include Dynamic Date > Select Date Format

April 2022

Accessibility Improvements

Recently Orion has been taking steps to ensure that our system is more accessible for all users.  Behind the scenes last month we updated our PDF file type for reports to a format that works with assistive reader technologies like Voiceover for Mac, and TalkBack for Android users.

Another change that is coming out with our April build is a visual update to our Donut and Pie Charts.  In the April release we are implementing white divider lines to help users more easily distinguish between sections on these charts. 

How to get there: Orion Connect > Reporting
Household Member Grouping

We have added a new grouping for household members as well as a corresponding data tag.  

How to get there: Orion Connect > Reporting > New Report > Add Table > Right Click > Grouping: Household Member
Query Builder - Data Tags

We have added the following data tags:

  • Margin Value
  • Plan Name
  • Plan Number
How to get there: Orion Connect > Query > Query Builder > New/Edit Query > Next > Search Available Columns
Query Builder - Multiple Scheduling

We have added the ability to set up multiple schedules for a query within the Query Builder. 

How to get there: Orion Connect > Query > Query Builder > More > Schedule Query > New Schedule

March 2022

Speed and Stability Improvements

We improved report generation speeds, reduced the frequency of erroneous errors, and addressed some bugs within Report Builder.

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

We have added additional registration and fund family level data tags as follows: 

Registration level: Registration is Active, Registration Gender

Fund Family level: Is Annuity

How to get there: Orion Connect > Query > Query Builder > New/Edit Query > Next > Search Available Columns
Query Builder Scheduling

We have added the ability to schedule queries within the Query Builder. 

How to get there: Orion Connect > Query > Query Builder > More > Schedule Query

February 2022

Report Settings

Duplicate report settings can now be saved. They will be given a unique ID in the backend to differentiate them. To avoid confusion, report settings can not have the same name. This ensures that differently named report settings with the same selected options within them can be saved.

How to get there: Orion Connect > Reporting > Report Settings
Query Builder - Data Tags

We have added new account and representative level data tags. 

New additions to the account level:

  • cash value
  • cancel date
  • is discretionary
  • is account sleeved
  • exclude from household rebalance
  • wrap managed
  • wrap sponsored
  • exclude from firm assets
  • last rebalance date
  • is SMA

New additions to the representative level:

  • is qualified plan
  • rep number
How to get there: Orion Connect > Query > Query Builder > New/Edit Query > Next > Search Available Columns
Query Builder UI Enhancements: Null Date Filtering

We have added null date filtering to the Query Builder.

How to get there: Orion Connect > Query > Query Builder > New/Edit Query > Next > Next > Next > Add Filter using N/A
Query Builder UI Enhancements: Transaction Grouping

By default, all transaction types will be selected when transaction grouping is being used.

How to get there: Orion Connect > Query > Query Builder > New/Edit Query > Row Grouping = Transaction > Pencil Icon

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

2445-OAS-09/23/2020