Workflow and Data Integration

New to OneStream but thought I would post an issue where we have an integration that runs a BR without any parameters and it will run successfully if we run it manually from theData Management menu. However this same integration will fail with the following error if we schedule/run it from the Task Scheduler. Here is the error we see in the Task Activity Log:Summary: Error processing Data Management Step 'Import DB2 Audit Checks'. Unable to execute Business Rule 'DB2_DataAudit'. Select a valid workflow profile... Any thoughts? Not understanding how it runs ok manually but has an issue if the Task Manager runs it. Thanks!

Hi All, How do i get data from Cognos into OneStream? I'm building a Fleet CV report, which uses two metrics -- FUR (Fleet unavailable to rent) and UPA (Under Performing Assets), which is available in Cognos. I'm assuming that I need to built a data adapter, or a manually upload the data.   Any suggestions would be great.   Best, Mustafa     

Do we have a way to transfer a file within OneStream (a pdf report), and automatically import into a public folders.  What will be the file-path to that shared drive in OneStream.       Any ideas will be appreciated. Thank you!

I have a loaded set of base data in our People Register, but this needs to be amended to capture New Hires, Leavers, Promotions etc. I had thought that this would be possible by using the excel file template that was used for loading the base data. I've tried doing this for a leaver, where I have manually changed the base entry to show the "to period" as the month that the person leaves and then created an entry in my blank template to show the remainder of the period with no salary (this enables me to build a bridge of starters, leavers etc.) When I load the file the new entry overwrites the row already in the People Register. What I need it to do is to add a row. The load method in the file shows "Merge" and I wonder what I should change this to in order to get the import of the adjustment file to add the adjustment rows rather than overwrite them.      

Hello Community, Do we have a way to check any missing member setting in an automated way?  For example: Recently we had someone create a few entity members/rollups, which were missing "Auto Translation" setting. So I had to go in and scrub through region/district/branches to amend and change it to USD.  Just curious, if we can "search" where a particular setting might be missing using a simple Business Rule. Maybe it throws a list of members where such setting is missing.      Any idea will be appreciated. Thanks everyone  

Does anyone know if it is possible to combine multiple data extracts into one file in OneStream?We have several DM jobs that we want to extract information about what contributes up to parents. We have found no way to do this in one DM job as the filters needed for each just won’t work for multiple rollup points. So alternatively we thought if we could combine those files it would work. Or perhaps a business rule that could somehow loop through the hierarchy we need and ‘build’ the larger file to save to the file explorer?

SOURCE: ONESTREAM CHAMPIONS Hi all! We just upgraded to 6.4 last week and have migrated our data management jobs running via power shell script onto Task Scheduler. A few questions: Do you set these jobs up with a certain person’s user name? Do you know what happens if that user is later disabled? (I’ve submitted a OS support ticket for that last question). If you don’t set them up under a specific person’s user name, how do you set them up? We have an “Administrator” user and “OSAutomation” user that I’m considering using to keep these auto jobs separate from my regular OS activity. Any insight would be appreciated as I’m trying to gauge how other users have set up Task Scheduler while also asking OS support for their best practices. Thanks!-Nicole

SOURCE: ONESTREAM CHAMPIONS Hi Team, Did anyone successfully able to set up the email configuration for RCM or Workflow profile completion or certification. Best Regards and Thanks Darpan Bhansali

We just went live with our IC setup (ie providing the plug account - We had already required a valid partner prior to adding the plug). Works GREAT! The issue/question we have now found ourselves in is that these feature is not time constrained like formula’s or other features. We decided that we needed to split a statistical volume value into two groups and wanted to go back in to a prior year to get year over year comparisons. At this point we realized that once we make any change to an Entity, when we re-consolidate, IC kicks in and hoses up our Financials. Outside of removing all plug accounts, making change, consolidating and adding the plug accounts back, we can’t update our prior period Statistical accounts. Anybody know of a work around or is this going to be fixed in the future similar to how formalus are handled.Clarke

SOURCE: ONESTREAM CHAMPIONS Hi Team, i was looking for the Audit Log for Workflow profile re-name or workflow profile movement from one parent to another, almost similar to what we have for Metadata logs. Any hints for the same ? Regards and Thanks Darpan Bhansali      

I can extract an entire DataManagementGroup just fine, but if I want to extract only one DM step and/or one DM sequence using XF Project, it fails. It will create an empty zip file. I have also tried extracting the DataManagmentGroup with IncludeDecendants=false along with the DM Step and Sequence but that just creates a zip with one xml that only contains the DM Group, and neither the DM Step or the Sequence are included in the extract. Has anyone had any luck extracting DataManagementStep or DataManagementSequence? It seems the Group must be specified since steps in different groups can have the same name, but I don't see anything about this in the documentation.

Hello,   We are using scenario types 1 and 2 to house multiple scenarios. I'm running into an issue where i can't correctly split out the needed scenario forms separetely. For example, The forecast scenario (scenario type 1) shows the budget forms since budget is also under scenario type 1. Is there a way to filter out the different scenarios? Because it's all under Scenario Type 1 the forms I'm using contain all scenario forms needed.   Thanks!   Paula

Hi Team, Is there any magical code / function to rename the workflow using some business rule. or direct update in the table ?       Regards and Thanks Darpan Bhansali

Hi Team,How to avoid the requirement for confirming dormant MEP workflows, should we setup at all or do an alternative control or any auto certification possibility Long Term?RegardsDarpan Bhansali

Hi, I am working on a demo for BIBlend. I understand that "View" is not supported in BIBlend and we should derive it on the reports or by using BRs. Does anyone have some some examples on how I can use Time math Business Rules to derive YTD values in the BIBlend Dashboards? Or any other methods to report YTD/QTD values for BI Blend? Thanks Liliya    

Originally posted by Sarah Park 2/4/2020 Can anyone provide some guidance on how to change the display of the Matching Accounts on the IC dashboard? Client doesn't like that it's driven off of the plug account ID, so want to rename these as ICPlug - AR/AP, etc. I've seen it done before but can't seem to locate it.

We are looking at the performance of several huge base data imports.  What are the best practices for setting cache page size and cache pages-in-memory limits for the best possible import performance?    We have broken the data load up into >40 separate imports but we still have some imports taking over 40 minutes.  I am hoping there might be other ways to improve the import time without having to break the data imports up further.  

Hello everyone,Hope you are doing good.I have a little question, im trying to load an excel data file using a time parameter that will allow to put load the workflow time automatically, but OS tell me that |WFTime| is Unmapped.   does anyone know if using the parameter wrongly or shouldi use another parameter ? Thanks in advance for you help.

Hello, We have data loaded to stage, voucher row text field, that we do not want loaded to the cube. Is there a video or how to doc that walks you through how to setup Attribute Value Dimensions for this column? I know from some of the OneStream training that I have attended it is possible but just having trouble getting started. Cube Design Attribute Value.docx (385.9 KB)      

Hello,I try to put a condition on workflow months in the data source, but i dont know how to call them in my Complex expression, does anyone have an idea ? Thanks 

I have a question regarding Journal Templates. We have a template that was setup with the frequency "All Time Periods." Does that mean this journal will post every month?  I think the setting should have been "Monthly." If I change that setting in the Journal Template, how does it impact historical data? Will it unpost prior close periods? Or will it keep the prior periods as is, but will stop the journal from posting in future periods? 

Source:   Migrated from Champions I built a mass upload template leveraging XFSet to use for our budget and forecasting processes that has a quick view to pull in all the accounts in our account dimension. I did this so that if we add a new GL account, the quick view updates upon refresh and is available for the users to budget/forecast to, rather than having to update the template for the users. The XFSet is hidden so users don’t accidently break the formula. The quick view is also hidden for the same reason. I have the sheet protected to further mitigate risks of users breaking the template. The issue is when we go to refresh the template which refreshes the quick view, the protected sheet won’t let the quick view refresh. Does anyone have a workaround to protect sheets while still refreshing the quick view?

Originally posted by Hans van der KempIf I look at the Data Adapters, it seems the method type "JournalForWorkflowUnit" contains the required information. So then I would need a Studio report based on that data adapter, similar to the RPTA -> is that the best approach?

I have a csv import coming from excel. One of the columns is of type date but when it gets saved into CSV the date is replaced by integers in the format excel uses to store dates. How can I convert those integers back into dates?

Originally posted by James Kirkby Hello: I want to have a confirmation rule write a value to a single intersection (api.data.calculate) by either calling a finance business rule or writing the calculate directly into rule text. The rule loops thru base entities and certain accounts, then writes the value stored there to a single member; basically, a check to ensure that all base members foot to the top of a hierarchy in USD (We have had issues with this in the past, and now have historical data that doesn't foot in certain areas identified in our most recent conversion.) I don't want this to run on a member formula as it will significantly slow down consolidation on all other data units, and this really is a confirmation by nature; a data quality check. Our consultants suspect that this may be by design; that during the running of confirmation rule, the cube can't get written to. PS - I can confirm the data calculate is in fact running as I'm writing the calc string to the error l