Recent Content
Register now for the March Live Edition of Tech Talks!
Explore the ultimate in dynamic dashboards as Jérôme Marcq and Sam Eburn join Tom Linton and Matt Kerslake to demonstrate how to convert embedded dynamic repeater dashboards into fully dynamic dashboards for lights out flexibility! Infinitely extensible! Register now! https://www.onestream.com/events/tech-talks-dynamic-dashboards-rules-assemblies/Sales Performance Management on The OneStream Podcast!
On this episode of The OneStream podcast, Bogdan Hancas and Scott Moore from InfinitySPM join Peter Fugere to talk about their Sales Operation Management solution. The trio discuss how the Sales Operation Management solution is helping sales operations and finance teams maximize efficiency, set realistic sales targets, and enhance performance tracking.Community Highlights: February
1 MIN READ February 2025: Finally it's about to be spring! For those that participate in daylight savings... did you spring forward yesterday? It's an exciting month with St. Patrick's day right around the corner for all you sassy lassies and lads. All of our metrics have been on the rise! We're seeing more visits and views across the board as well as more new discussions. Here's what we saw in February 2025: The Community had 28,559 visits in February 2025 and 91, 072 page views We had 119 new discussions begin Reporting was our most active forum (again), with 39 new discussions Top Engaged Threads: Most Replies: Transformation Rules for Time dimension Most Views: Primary and secondary axis align 0 point (Again!) Most Active Members: We have a triple crown this month and a new face to grace the highlights! Congrats victortei and welcome to the Community Highlights 😀 Most Forum Replies: victortei Most Likes Received: victortei Most Authored Solutions: victorteiTech Talks: ESG Reporting and Planning Available Now!
On this episode of Tech Talks, Andrea Tout joins Tom Linton and Matt Kerslake as they explore this NEW solution showcasing the power of the OneStream Platform and extending the support of evolving ESG requirements! This episode of Tech Talks is free to all and also available on Navigator at https://onestream.thoughtindustries.com/learn/video/tech-talks-esg-reporting-and-planningMenu Component in Practice
4 MIN READ If you create the new Menu Component in your Maintenance Unit, you will quickly notice that it has very few properties. That's because its configuration will actually come from an attached Data Adapter, which must produce a set of tables containing all menu items and their configuration. The format of such tables has to be somewhat precise, matching what the component expects. For this reason, the best way to produce them (at least while you familiarize yourself with this mechanism) is to create a Dashboard DataSet using a couple of utility classes built for this specific task. The first thing we will do, in our rule, is to create an XFMenuItemCollection object. This represents our menu, which we will populate with items and eventually return (as a DataSet) at the end of the function. Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As DashboardDataSetArgs) As Object Try Select Case args.FunctionType Case Is = DashboardDataSetFunctionType.GetDataSet If args.DataSetName.XFEqualsIgnoreCase("MainMenu") Then ' create the menu object Dim menu As New XFMenuItemCollection() Menu items will be created by instantiating objects of type XFMenuItem. These objects will hold all the configuration properties for the item, including the font and colors that it will use. There are a few different constructors you can use, to specify all sorts of properties; the one used here is the shortest one! ' create top-level item ' XFMenuItem(string uniqueName, string headerText, string foreground, string background, bool isBold, bool isItalic, bool isEnabled, bool isSeparator, string parameterValue) Dim parentMenuItemOne As New XFMenuItem("1", "Parent", _ "White", "SlateGray", False, False, True, False, Nothing) ' create items for the second level Dim childMenuItemOne As New XFMenuItem("1.1", "Child 1", _ "Black", "White", True, True, True, False, Nothing) Dim childMenuItemTwo As New XFMenuItem("1.2", "Child 2", _ "Black", "White", True, True, True, False, Nothing) ' create item for the third level Dim grandChildMenuItemOne As New XFMenuItem("1.1.1", "Grandchild 1", _ "White", "SlateGray", True, True, True, False, Nothing) Most of the properties are self-explanatory, but you might wonder what "parameterValue" is. That's the value that will be pushed into the Bound Parameter specified on the actual component later on, so that Actions or other components can pick it up. We will come back to this later. Now we need to define the relationships between items. We do that by manipulating the .Children property of each parent item, which must be a list containing the children (duh!) items. ' create the hierarchy by adding children to direct parents as a List ' attach 1.1.1 as a child of 1.1 childMenuItemOne.Children = New List(Of XFMenuItem) From {grandChildMenuItemOne} ' attach 1.1 as a child of 1 parentMenuItemOne.Children = New List(Of XFMenuItem) From {childMenuItemOne} ' you can also manipulate the list once created. ' attach 1.2 as a child of 1 parentMenuItemOne.Children.Add(childMenuItemTwo) In a similar way, top-level items are added to the list contained in the .MenuItems property of our XFMenuItemCollection instance. ' add item 1 as a top-level members of the menu menu.MenuItems.Add(parentMenuItemOne) Before we return the resulting menu, if you are dealing with dynamically-generated structures with a lot of members, you might want to perform a safety check and purge extra members: While menu.IsAboveMaxMenuItemLimit(si) menu.MenuItems.RemoveAt(menu.MenuItems.Count - 1) End While Last, we use the .CreateDataSet method of our menu object to return the DataSet. ' generate the dataset and return it Return menu.CreateDataSet(si) Now that we have the rule, we can create a DataAdapter to execute it. Notice how, when testing it, it produces two tables: one with item properties, and one with their relationships. Now that we have an Adapter, we can create the Menu Component and attach the Adapter to it. You can then assign it to a Dashboard and preview it, after you save it. This is fun but a bit pointless! We want menus so that the user will actually choose something and we'll get the result of that choice. In order to do that, we need to specify the Bound Parameter. Whenever the user selects an item, the "parameterValue" associated with that item will be pushed into the specified Parameter; we can then reference that Parameter in an Action or extender rule, to trigger something like navigating to a website. Note that the Parameter doesn't need to exist! OneStream will just create one for you in the background. Then we place an Action on our Component, referring to the Parameter. The last step is to go back to our rule and specify a different parameterValue for "leaf" items, so that the Parameter will contain something. Dim childMenuItemTwo As New XFMenuItem("1.2", "Main Page", _ "Black", "White", True, True, True, False, "https://www.onestream.com") ' create item for the third level Dim grandChildMenuItemOne As New XFMenuItem("1.1.1", "OneCommunity", _ "White", "SlateGray", True, True, True, False, "https://community.onestreamsoftware.com") Et voilà! You can now execute the Dashboard and verify that it works!Question: Is there any security options to limit a user's ability to submit data using excel?
Answer Submitting data via excel will respect the security model set up in OneStream. So consider typical security setup. Also consider using constraints to manage "valid" data intersections. Inputting data via set cell will get tracked in the audit logs, however, clearing this data can be problematic if you wish to clear all out all submitted cells. Rather than using set cell, another option is to set up an excel import which would go through stage and allow for clearing of the data set. There is a pending enhancement request to have an option available to restrict some users from submitting via excel. Source: Office Hours 2020-7-2 - Partner EnablementTech Talks After Hours: Fun with FX - Currency Translation Adjustment (EMEA View)
The "Fun with FX" Tech Talks series continues with this After Hours episode "Currency Translation Adjustment - EMEA View" with Christian Wetterwald. Join Christian and Tom as they review and unpack an example of FX Rate Currency Translation Adjustment (CTA) Development analysis and why it's such an important part of typical EMEA implementations! This episode of Tech Talks After Hours is available exclusively as part of a Passport subscription. https://onestream.thoughtindustries.com/learn/video/tech-talks-after-hours-fun-with-fx-currency-translation-adjustment-emea-viewNew Episode of The OneStream Podcast Now Available!
On the latest edition of The OneStream Podcast, Cameron Lackpour and Calvin Kattookaran join Peter Fugere to discuss Black Diamond Advisory’s growing family of Partner Solutions for the OneStream Platform, including the new BDA Accordion Rolling Forecast. Listen now!Map Component Tutorial
5 MIN READ So you’ve bought the OneStream Advanced Reporting and Dashboards book - congratulations on being on your way to mastering these tools! The book is chocked full of examples and guidance on how to tailor your user experience, but here’s something extra – a tutorial on how to use Map Components in your application. We’ll walk through setting up a Dashboard with an interactive map to provide users with a visual display of locations, from collecting coordinates to displaying locations that are click-enabled to display relevant data.
