Last year Ruben Cammeraat showed me this cool trick to really personalize your OneStream dashboards. We're going to create time-dependent dashboard components! A fun example is adding a warm Santa hat for the cold December month. Let's dive right in.
Let's start by creating two images. Download your favorite photo (in my case, the Finext company logo) and a stock image of a Santa hat. Combine these using excellent photo editing software such as Microsoft Paint to create the Finext+Santa image. Of course, this could be any other image or combination; use your imagination here.
Now let's shift our focus to OneStream. In your workspace, create two file components and upload the two versions of images you would like to see modified:
- File_Logo: Finext_Logo_RGB_Gradient uploaded
- File_Logo_Santa: Finext_Logo_RGB_Gradient_Santa uploaded
Next, we need some Business Rule logic. I created a Dashboard XFBR String named Finext_Img with the ReturnSantaIMG function. Don't worry, just a few lines will do!
The first line reads the current date and time of the computer running the code. For my computer in December, that's month 12. Now create a Dictionary for all months and a custom image for each month. In my example, I created a custom image only for December, but you can customize it for any quarter, week, hour, minute, and so on. The custom image is the name of the dashboard file component we uploaded earlier. Now create an image dashboard component that calls this Businessrule.
And finally, add the image component to the dashboard.
Let's see the result... Throughout December, this GolfStream Cashflow Modeling dashboard will feature a Finext Christmas hat! Let me know if you know of any other images or use cases. Or if you need help configuring a time-based dashboard component.