Recent Discussions
Including Journal Entries from Different Origin Member in Account Reconciliation Discovery
Hi Community, I’m working on an Account Reconciliation solution where I need to ensure posted journal entries balances are also included in the Account Reconciliation discovery process. Currently, by design the Discovery process only pulls trial balance information already imported and validated in the Stage. Therefore, I wanted to check if there’s a recommended, or best practice approach, to accomplish this requirement. Any guidance or examples would be greatly appreciated, thanks in advance for your help!
Accessing multiple import file names via DA
HI Guys, Is there anyway via a method query or rule in a data adaptor that I can specify parameters to give me all file names related to a workflow. I preferably want all file names in a specific workflow for all years in a data table of columns: (Workflow,Year,Filename). Presumably doable with a dashboard data set rule but Ive never played with the staging engine before! Guessing also that its probably a case of looping years and appending tables. Thanks, Tom
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.
