Using Cell detail in cube view ,forms and reports
Hello Few of questions on using cell details 1. How can we add different classifications for data entry via cell details ? I have created dashboard parameter for same , however its not reflecting in respective cube view or form. 2. Is there any existing report for displaying cell details ? 3. Correct syntax for function -BRApi.Dashboards.Parameters.GetLiteralParameterValue , unfortunately sample code is not working Thanks JA8.1KViews0likes12CommentsHow To Trigger Dashboard Refresh from SQLTableEditor Save Data Server Task (Save button)
The SQLTableEditor in question is used for user interactive CRUD pertaining to Rates used in a calculation. Use Case: I have a SQLTableEditor that holds rates. When the table Save button is clicked, A BR saves the rates and runs a calculation. The results of the calculation are displayed in an adjacent dashboard containing a DataGrid. The DataGrid needs to be refreshed after the Save button is clicked. Question: How do I configure the SQLTableEditor to refresh the adjacent dashboard on clicking the Save Button, in a way similar to configuring the "Save Action" of other components?Solved6.7KViews2likes12CommentsWindows shortcut on OneStream application
Hello Team, We have IE and Edge browser on the system. Once opened the OneStream application when we do Windows shortcut as per below screenshot it is creating the Windows short cut on the desktop. And, then when we open the OneStream application using the shortcut , it is opening on IE browser. How to create a shortcut for Edge and the application should open on Edge Browser when we use the shortcut. Thank you, PraveenSolved5.3KViews0likes5CommentsBuild a cube view for KPI accounts
Hi community 🙂 We have created a new scenario (not actual or forecast) for manual KPI accounts ( no formula on them), e.g Market share. We would like to create a input form where the submitter should populate e.g. market share for the specific month, for the specific QTD and YTD. I asked a question earlier regarding the account setup for this and I got the answer that they should be Account type Balance. From my understanding you need to say Periodic or YTD on the Scenario settings (default view, input view for adj etc). But what to put when it´s regarding these kind of accounts? Also, regarding the input form. Now we have built YTD and monthly in the same form. For QTD in a separate form. But when populating an amount in monthly, the YTD is automatically updated with the same amount. Any suggestion on setup in the CV to not make them "talk" to each other?Solved3.2KViews0likes4CommentsDefault Home Page for Users & OS Logo is an Actionable Event
Thought this was cool and wanted to share so others have the recipe. If you build a default landing Home Page for users upon login, this is where the XML sits for that Dashboard. Then, (I was thrilled) to discover this) once you have a default Dashboard set for users, the OneStream logo is now a clickable button! It returns you to your Home Page Dashboard.2.5KViews12likes5CommentsOneStream UI - Dark mode
Hi, since I am used to set many of the programs I use during my working day to dark mode, I was wondering if it is possible to turn the dark mode on for OneStream, and if that's not possible, is it something OneStream plans to introduce in future? Thank youSolved2.5KViews2likes3CommentsHow to assign images to Tree View nodes when not using the Default Workspace
I have a dashboard that uses a Tree View. Its in a named workspace. The only way I can get images to work with it is to upload the images to a Default Workspace. Is there a way to reference my images in the workspace where the Tree View is?2.4KViews5likes6CommentsPLP register field not displaying values
We have two 8.2 environments with PLP SV 101. In one environment, all of the parameters for the register field lists display as expected. In the other, the same fields are blank. However, we know there is indeed a value there as the plan calculates correctly and we can see the resulting entities in the export to the cube. For troubleshooting purposes, we’ve been using the entity field (aliased as Department in our solution.) The Register Field List setup is entirely conventional: The parameter is configured the same in both environments: The function in the business rule that it’s calling is the same in both environments. I’ve tested the resulting SQL in SSMS and it returns valid values. I temporarily added some logging to make sure the method was actually hiring and returning a data table as expected; it is. The fact that it does populate the entities when calculating the plan data suggests all of this is fine and it’s just a display bug but nothing I can find seems to allow it to display properly. What can we do to address this? I know the parameter is custom but the issue doesn’t appear to be with the parameter as it works fine in every other environment we have except this one. What we need help explaining specifically is the display issue, which seems like a bug.Solved2.4KViews1like12CommentsCan an Excel Journal template be modified to allow upload to multiple periods at once?
Does anyone know whether it's possible to modify the Excel journal upload template to force upload to multiple individual periods from that one file? If it's possible, can anyone provide a brief how-to for setting something like this up? The request is to be able to upload this to a forecast scenario so it's really outside the normal parameters of a typical journal. I know one easier alternative is to create an _ADJ member and just load the data to that but that's not the ask from the team. Would be grateful for any advice. ThanksSolved2.3KViews0likes3Comments