The Concept of Primary and Embedded Dashboards
I’ve recently spent time with a client optimizing and cleaning up a dashboard implementation. As part of this I have noticed a recurring issue around Primary (or Main) Dashboards that could use clarification.
The term Dashboard is used interchangeably for a single dashboard or a Dashboard Group that contains many Dashboards, with most of them embedded in other Dashboards, to one degree or another. In fact, when you create a single Dashboard, OneStream creates an embedded Dashboard component based on the dashboard that you just created.
It is this embedded dashboard component that you add to other dashboards in the Dashboard Components tab of other Dashboards as you build out your Dashboard Group.
There is the concept of the Main Dashboard, or the Frame Dashboard that contains all the other embedded dashboards. It is this Main Dashboard that you tend to run, which then renders all the other embedded dashboards as one cohesive whole.
Technically that Main or Frame Dashboard is the Primary Dashboard. Embedded Dashboards are never the Primary Dashboard.
Importance of the Action Property in Primary Dashboards
Why is this important? The Action Property on the Dashboard Property Tab is why it’s important.
Note that the property group is labelled “Action (Primary Dashboard Only)”. This property will run a business rule if it’s configured properly and if it is added to the Primary Dashboard. I have seen too many cases where this has been configured on a dashboard that is not a Primary Dashboard and as a result the called Dashboard Extender function will never run.
Why would it be set up on a non-primary Dashboard? My assumption is that whoever did this just did not realize that it does nothing on a non-primary Dashboard.
Demonstrating the Primary Dashboard Functionality
To prove this out and for demonstration purposes I have created a Dashboard Group that is made up of 3 dashboards, 2 embedded in the first (Primary Dashboard).
When the 00_Frame_PrimaryDashboard is run, it looks like the screen shot below.
I then configured the Primary Dashboard (00_Frame_PrimaryDashboard) to run a Dashboard Extender.
The Dashboard Extender has a function added to the Load Dashboard Case section of the Dashboard Extender. This function writes the name value pair value to the Error Log when the Dashboard is loaded and if it is the primary dashboard.
Common Mistakes with Dashboard Extender Configuration
This is what you see in the Error Log, as expected, when the Primary Dashboard is loaded.
To prove that this dashboard extender will not run if called from an embedded dashboard I set up the Action Server Task properties on one of the embedded Dashboard to run the same Dashboard Extender, but I passed in a different value in the name value pairs. Then I loaded the Primary (Main) dashboard again.
As expected, there was nothing written to the Error log on the load of this embedded dashboard.
To prove that the syntax of the Dashboard Function call is correct, if I run just the dashboard 02_Content_PrimaryDashboard and check the error log I will see the name value pair that I passed in from this dashboard in the error log.
It works this time because the dashboard was not run from its embedded state, but as a Primary Dashboard.
I hope that this clears up when to and when not to add a Dashboard Extender Function call to the Load Dashboard Server Task property on a Dashboard.
Partner SpotLight
OneStream aligns to your business needs and changes more quickly and easily than any other product by offering one platform and one model for all financial CPM solutions. OneStream employs Guided Workflows, validations and flexible mapping to deliver data quality confidence for all collections and analysis while reducing risk throughout the entire auditable financial process.
Case Studies
Accumen
Thanks to the intervention of MindStream Analytics, Accumen's Finance department can now model their business with a new, more organized structure that isn't conventionally available in NetSuite.
Acme Brick
Acme Brick turned to MindStream Analytics for help implementing OneStream to replace their outdated TM1 solution.
Alterra
Alterra sought the expertise of MindStream to address the challenges they faced in their Capital Planning process.
ATCO Group
Energy conglomerate ATCO operates worldwide in utilities, power generation, and related services.
Avalon
Working with MindStream Analytics, Avalon Healthcare Solutions adopts NetSuite Planning and Budgeting to accelerate budgeting and forecasting processes.
Bayer Health Care
Bayer Healthcare implemented Hyperion Planning and Workforce Planning in 10 weeks to dramatically streamline their Income Statement budget and Workforce Planning process..
BluEarth
MindStream Analytics' partnership with BluEarth Renewables epitomizes the power of technology and collaboration.
Celgene
An Oracle Hyperion Planning Upgrade provides multi-national organization Hyperion Application optimization and stabilization.
Cleaver Brooks
OneStream XF was chosen as the platform that would transform Cleaver-Brooks' Finance processes.
CoorsTek
The collaboration between CoorsTek and MindStream resulted in significant improvements in CoorsTek's financial consolidation and reporting processes.
Elite Body Sculpture
MindStream Analytics' collaboration with Elite Body Sculpture encapsulates the transformative potential of targeted tech solutions in streamlining administrative processes.
Enlyte
Enlyte, a merger of Mitchell, Genex, and Coventry, faced challenges with disparate financial solutions and the need for combined reporting.
Flanders
MindStream Analytics collaborated with Flanders to implement OneStream Consolidation and Reporting solution.
Foley Products
Foley Products was facing a significant challenge with its Excel-based actual management reporting system.
Harte Hanks
The collaboration between MindStream Analytics and Harte Hanks culminated in a highly customized, user-friendly NetSuite implementation.
Interface
Interface used a complex, manual, excel-based FP&A process for monthly review, and the summary data was loaded in OneStream.
Kymera International
Thanks to Mindstream Analytics' assistance, Kymera was able to load all of their data into OneStream and validate it successfully.
MacLean Fogg
MacLean-Fogg partnered with MindStream, a leading implementor specializing in modernizing and optimizing enterprise systems.
MEPPI
MindStream's expertise and experience were sought to conduct a vendor selection initiative focusing on MEPPI's F2023 planning process.
OUAI
MindStream Analytics and OUAI's collaboration showcases the transformative power of strategic technological intervention.
Plaskolite
By migrating to OneStream, Plaskolite has achieved a material reduction in consolidation time and overall Financial Close cycle, eliminated the hours spent compiling and verifying data in Excel, streamlined its Planning, Budgeting and Forecasting model and delivered flexible and timely reporting that enables more strategic analysis of their financial data.
Redwire
Understanding the nuances of Redwire's challenges, MindStream Analytics devised a holistic approach to overcome them. The implementation of NetSuite was just the beginning.
Simon
Simon's existing corporate Hyperion Financial Management (HFM) production application was consolidating at a rate of seven hours, a performance issue causing great headache to corporate Accounting.
Source Code
The successful transition to OneStream revolutionized Source Code's financial reporting.
Subway
Subway collaborated with MindStream Analytics for the NetSuite Analytics Warehouse implementation.
UPenn
MindStream Consulting and AppCare team members are proud be working side by side with UPenn university in accomplishing this implementation and along with continuing our AppCare services after go-live.
USG
USG was an Oracle Hyperion customer realizing that it needed more specialized support for its various Oracle Hyperion applications.
Vantiv
Dividing a hyperion planning application, expanding the hyperion footprint to forecast on the business? Customer categories.
Versant Health
Versant Health engaged MindStream to help resolve the challenges they were experiencing with their consolidation, close, and financial reporting processes.
Virginia Spaceport Authority
The MindStream team implemented the Standard + Workforce NetSuite Planning & Budgeting.
WeWork
MindStream Analytics determined that the best solution was to implement Oracle Essbase Cloud as part of the Oracle Analytics Cloud (OAC) platform-as-a-service
WindStream
Innovative use of essbase to streamline and connect hyperion financial management for enhanced financial analysis.
XY Planning
MindStream Analytics, well-versed in addressing such challenges, presented a comprehensive Netsuite solution for XY Planning.