Release Notes: Reporting

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. 

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!

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.

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.

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

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. 

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.

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

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

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.

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

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. 

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

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

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

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. 

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

We have added the following data tags:

• Margin Value
• Plan Name
• Plan Number

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

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

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

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

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.

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

We have added null date filtering to the Query Builder.

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

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

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 

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

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.

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.

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

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

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

This development will allow you to add multiple columns using the same data tag in 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. 

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. 

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.

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. 

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

This development allows users to add new data points (account status and business line) 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.

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. 

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.

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.

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.

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. 

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.

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.   

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. 

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. 

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