Load to Multiple Scenarios?
Is there a way to load to multiple scenarios from one Workflow? Example, from the below Workflow POV, I want to load to the Actual_PP scenario, but also to the Forecast_PP scenario. I don't want to create a new workflow for forecast because I want to use the values from People Planning that have been calculated for Actual_PP to populate both scenarios. I don't what to load the People Planning register twice and calculate it twice.
Security Access Error | Get Parent Workflow Status
Hi, I've got a business rule where I use BRApi.Workflow.Metadata.GetParent(si, si.WorkflowClusterPk) to look at the status of the parent workflow profile. However, if a user does not have access to the parent workflow profile, then they get an error "Security Access Error. User is not authorized to access workflow profile". So it seems that the function BRApi.Workflow.Metadata.GetParent(si, si.WorkflowClusterPk) is not very useful and it is a bit bizarre that it refers to user security. Is there a way to run this business rule as administrator perhaps or something else I can do?NetSuite to OneStream Integration
Hello all, I need to verify and confirm the method of choice to set up an NS to OS 8.5 integration WITHOUT the SIC in play. Here is what I have uncovered thus far.... A SuiteAnalytics Connect is being considered via ODBC so OS can pull data from NS. I read a few things about this. One is that a BR would be set up in OS to call on a SuiteScript in NS initiate the data pull. Now, the missing piece is how to set up the connection in OS if there is no ODBC installed. Another thing is that SIC would not be needed. I also perused a blog that stated that Support can set up s direct connection to NS from OS, provided they have the NS info. Can anyone please confirm this approach? Rest API could be leveraged but looking for an alternative. Any input would be greatly appreciated. Thanks, Ed PValidation Error: No security access to data cell being cleared
Hi Team, We have a client that upload excel templates using xfdrange into OneStream. They have different files per Business Unit (UD2). Two of the files run into the following intersection error during the validation step: All the other files are correct, however, when they upload these two files, all data intersections (from all other files) are suddenly also invalid intersections. For examples, the line listed here is not from either of the two files but from a seperate file that has no errors when uploaded individually). When you would navigate to "Intersection" instead of "invalid Intersection (1)" all data intersections from all files are there. Only the local users get this validation intersection, when I (administrator) would run "Validate" from this screenshot, the error dissapears. Strange thing is: they have uploaded data on this intersection before in previous Forecast Scenarios without errors Security has not changed for either the application, user, workflow profile, entity etc. these two files both have an account that is only used there but is set up in the same way as all the other accounts (and previously could be loaded in other scenarios). Could just be a coincidence. Application Security: ModifyData is set to Everyone One thing to note is that this is a new forecast scenario we recently created for them, however, setup is the same way as the other forecast scenarios in terms of security. I am also having a hard time understanding the error and why it is refering to "clearing data" in the validate step. Anyone that can help me a little bit more in understanding the error or knows what could cause this? Thanks in advance!
Is it possible to hide workflows based on Period?
We have a client who wishes certain workflows (Input Child) to only be visible at specific periods during the year (6 and 12) The only way I could conceive of this based on my knowledge of OneStream to date is through managing security profiles somehow (Access Group) But everything I have seen indicates a very binary process, you have access or you don't.
No valid DataKeys Error
Hello, Has anyone had this error message "No valid DataKeys (Scenario/Time) found in data source". I received this message when importing a "text" file through the workflow. Once import is selected and is at 94% complete prior to validation. I have checked on Scenario & Time to make sure it is proper. I need help on how to fix this.Set Workflow POV with a BR
Hello, Is there any way to leverage a Dashboard Extender rule to set Workflow POV items? I previously had made a post by doing this in the new SmartLinks rule, but I was able to find a way to avoid using that. When my dashboard gets loaded, an extender rule executes, I want to run a subfunction that updates their workflow profile, scenario and year. Is this possible?Stage data
Hi all, We have Excel file that we upload into Cube (some tabs from this Excel file). This file also contains additional tabs that we want to upload into stage only and create cube views based on numbers on these additional tabs. Could you please advise where I can find instructions how to create, upload, perform mappings (if necessary), aggregate stage data and create cube views based on stage data.
