Cloud

OneStream Custom Color Quick Tip

Difference Between Team Site and Communication Site in SharePoint

Recently I was working on a project and as part of the implementation, Cube Views were created which were deployed as Forms for data input.  For most individuals who have implemented OneStream, creating a Cube View and deploying it as a Form is standard practice.  What was different about this implementation is that the Cube View used a Row Override; therefore, the presentation of the Form displayed as an invalid intersection cell instead of as a calculated and/or aggregated data cell displaying an inconsistent end-user experience.  As a result, the cells which had the override required a custom format which is the subject of this quick tip.

To level-set, the original form after the Row Override is displayed in the next image with the invalid intersection cells displayed in the last column starting with row, Acc Depn Software, and concluding with Net Land.  The goal will be to display the pink cells “invalid intersection cells” as green cells “aggregated/calculated data cells“.

Blog 2021 09 26 10 36 00 Window

In order to change the appearance of the pink cells to green cells, the color code of the green cells is needed.  To obtain the color code, capture an image of one of the green cells and then save the screen capture as a file which I used a program, Greenshot, to accomplish.  Once this is done, navigate to the website, HTML Color Codes.

Blog 2021 09 26 11 57 07 Window

Upload the file captured with Greenshot, then select the color displayed by the uploaded file which will display the Color code which is “#EAFFEA“.

Blog 2021 09 26 12 05 52 Window

With the Color code for green determined, the next step is to apply the Color code to the Cube View which begins by opening the Cube View and navigating to the column which has the Row Override.

Blog 2021 09 26 12 23 25 Window

The Color code is applied as a BackgroundColor as displayed in the next image.  Note, the Color code is prefixed with “FF” as the Color code is specified as an ARGB value, and the FF represents 100% transparency, and the remainder is the Hex value.

Blog 2021 09 26 12 35 04 Clipboard

Select “Open Data Explorer” and the result is that the pink cells are now green cells and the presentation is consistent from an end-user experience.

Blog 2021 09 26 12 36 36 Window

I hope you find this blog helpful and this approach can be used to determine and specify a Color code for other Cube View formats such as TextColor, GridLinesColor, or ReportBackgroundColor to provide a few.  Should you have any questions, feel free to either post a comment to the blog or email me at terry.ledet@perficient.com.

About the Author

Terry is a Senior Solutions Architect at Perficient and a OneStream Certified Professional (OCP) - Lead Architect R1. He is a frequent speaker at Splash and passionate about making clients successful. When not blogging about OneStream, Terry is a husband, parent, and baseball enthusiast.

More from this Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe to the Weekly Blog Digest:

Sign Up
Categories