How to use Parcel Services for bulk reporting in OneStream

Do you have many users that you want to send information? And is this information based on data that is available in OneStream, for instance a periodic internal financial statement? Use Parcel Services to automatically distribute books and documents from OneStream. Parcel Services enables you to create packages (groups) that can be shipped to email lists or a file share. This can be done via a dashboard button, or fully automated using PowerShell scripting.

By Danielle Gruijs, April 2020

So, where do you start with Parcel Services? We’ll first describe the setup of the solution and after that the usage.

How to setup Parcel Services

Parcel Services requires Ancillary Table access like most other Market Place solutions. If you don’t have this set up yet, you can follow the steps described in the setup instructions document. Do you have other solutions running already? Then this is not required anymore.

After downloading the solution as a .zip file from the Market Place, you can import it into your application via Application -> Load/Extract. After that, the Parcel Services (OPS) will appear under OnePlace -> Dashboards, where you can create the tables and then launch the solution:

How to setup Parcel Services, OneStream

In addition to Dashboards and business rules, this solution also contains data management sequences to automate the distribution of your documents.

In the settings page, you can set the security roles for managing and distributing packages, the email connection and default message contents. The Parameter Discovery Nesting controls how many times the Parameter Discovery process loops. The Test Mode allows testing the solution without actually sending all email messages to your users.

Parcel Services security roles, OneStream

Configuring your reporting packages

Via the Packages button you can create the packages and Groups. A Package (Group) is a list of extensible documents/ books packaged together. You can choose different delivery types for a new package:

Configuring reporting packages, OneStream

The email can be zipped, and a custom Title and Message can be created.

After that, the content of the package is selected in the bottom part of the screen. You can add multiple documents:

Parcel Services, configuring reporting packages, OneStream

On the right, you can add required parameters both for the Package and for the selected document. Since Parcel Services doesn’t give you a pop-up when executed, literal values need to be added to the different packages. A great feature with parameters is that you can send the same report to dozens of users using different parameters, so everybody gets the same report with their own personalized data.

Parameters for a XFDocument can be manually entered or found dynamically via the Discover Parameters button:

Configuring reporting packages, discover parameters, OneStream

For easier distribution, created Packages can be grouped via the Package Groups tab.

Via the Manage Distributions button you can create the distribution lists that can be added to a package. After creating a Distribution list, OneStream Users (or Groups) can be added and if required an alternate Email address to be used can be added.

On the right, you’ll see the members in the list (based on the users and groups added) to validate your distribution list.

Parcel Services, distribution list, OneStream

Now the distribution list can be added to your package created earlier.

Sending your packages reports

To run the process, there is a clear 4-step process from the home page. In the first two steps, you select first the parcel type and then the package (group). In the following two steps, you review the contents and the distribution list before you ship the package:

Sending packages reports, OneStream

And the document is nicely distributed to your mailbox:

OneStream reporting package, parcel services

If you need to automate this process, the required (sample) PowerShell scripts are included in the solution as a starting point.

Conclusion

Parcel Services can be a great addition to your OneStream platform. If you distribute many reports or books to your users, this solution certainly is a must have. It reduces the manual work and is flexible with the use of parameters, making it feasible to send your users their ‘personal’ reports.

Pros of OneStream Parcel Services:
+ Easy configuration
+ Use parameters to personalize your reports/ books
+ Can be automated to run on a scheduled time

Cons of OneStream Parcel Services:
– Added value only in specific use cases

The setup is described in detail in the documentation and the configuration is easy. Therefore, I classify this solution as Admin Configurable. Please see my earlier post ‘The OneStream Market Place in real life’ about classifications.

Let’s discover the OneStream Market Place together

Want to know more about the OneStream Market Place? In a series of blogs, we’ll delve into the details of the Market Place and the solutions available. In the blog ‘The One Stream Market Place in real life’ you’ll find more details about the basics of the Market Place. And in the blog ‘New in OneStream: Predictive Analytics 123’, we discovered the new Predictive Analytics capabilities of OneStream.

Any questions or suggestions for a Market Place solution you would like to read about? Don’t hesitate to contact me!

Do you prefer to discuss the details live? Our Finext OneStream event has been postponed till after summer. Please let me know if you’d like to receive more information about this event, and we’ll keep you updated.

Cannot wait for our live event? Don’t hesitate to contact me with your questions so we can plan a (web) session to answer any questions you have about OneStream and the Market Place.

 

OneStream