Recent Discussions
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.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 P
External Connection for OS App in Same Environment?
Hi there everyone, Anyone ever created a connection between apps in the same OS environment? Working on some data movement and I have the connector set up, but struggling a bit with the connection string for the external database connection I'm setting up to reference the app I'm pulling data from. Is it the same syntax as the BI Blend connection, or are there other keywords that need to be in there? Thanks!
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?Setting Workflow via SmartLink
Hi guys, bit of an odd one here. Our client is looking to leverage SmartLinks once their 8.5 upgrade is complete. We are doing testing in their Development environment and have the SmartLinks up and running (mostly) as expected. Our SmartLink navigates the user to a specific dashboard, but the dashboard is WF driven. On top of that, when opening OS in the Web, it defaults the WF to the WF the user was most recently in. I know SmartLinks is a new feature, but was wondering if anyone had any intel on how far the code can go. We prepopulate parameters with the generated link, can Workflows (Profile, Scenario, Year) be set the same way? It doesn't seem like it. Not sure how I would go about this issue going forward, however. ThanksRESTAPI - Only Supports Default Workspace Currently?
Just a heads-up for anyone using the REST API - this may save you some head-scratching! GetAdoDataSetForAdapter (5.2.0/Synchronous) and non-Default Workspaces There appears to be a problem with running GetAdoDataSetForAdapter if your DataAdapter is not in the Default Workspace. The Data Adapter returns an HTTP/200 in PostMan BUT the Response Body is null. It appears that the WorkspaceName parameter in the RequestBody has not yet been implemented in the RESTAPI. The RESTAPI documentation still referes to this parameter as being "reserved for future use" (but I assumed that this was a documetation bug as non-Default Workspaces have been out for a while in 7.4/8) API Version 7.2.0 and Workspaces In the Asynchronous APIs (7.2.0), there seems to be no way to specify the Workspace when you are generating the Application Session Token (SI), so you get the same problem with Data Adapters not in the Default Workspace. I proved this by moving my Data Adapters to the Default Workspace at which point they worked perfectly via the REST API whether via API-Version 5.2.0 or 7.2.0) UPDATE: Workspace has to be set to Shareable for this to work - all Ok now! (Wasn't in the REST API Guide) Steve
8.5 Excel Add-In Forms and Parameters
Hello Everyone, I was wondering if anyone has experienced and resolved the issue I am finding. I am working on an excel workbook that has tabs corresponding to each workflow step consisting of various forms. These forms have parameter requirements. The request is to have the parameter dropdowns on each excel tab. The issue I am having is some of these form tabs have the same parameters. I am met with the popup, this parameter already exists when trying to introduce it a second time on a different tab. I know you can set one parameter to work across the entire workbook however that is not what my client wants. The only way around this that I have found so far is to make multiple copies of parameters within the Application however I would rather not have multiple parameters that are the exact same. The other option is to have a separate excel workbook for each Workflow task. I find even setting the parameter to be used across the entire workbook to be a bit clunky. Thanks in advance for the input! Regards, Anthony
Automation of exchange rates calculations
Dear colleagues, Please advise do you have experience with automation of exchange rates calculation. We need to pick up daily rates for different currencies from different source websites, calculate monthly average rates and end of reporting period rates and upload them to the correct time period in OneStream. Where can I find guidance to solve this task?
in which Application Database table User Certified details are available?
Hi Team, I just want to create a report, in that report user can review like (which user has certified the respective entity in the workflow with date and time). i could not able to find in which application database table certification status details will store. can you please help us with the table name. so that we can write method query to fetch the data.
