OneStream Platform Forums

Hello, I have multiple excel files using XFGetCell to pull data from OS.  What I would like to do is, (1) create a report book that includes the XFGetCell formulas to refresh data when the report is ran, (2) Set up a DM/Parcel Service to automate sending the file to both OS and non-OS users.  Is there a way to do this?  I do not want to re-create these files as cube views because they are customized for our reporting requirements and have some intricate calculations.Thanks,Tyesha

Is it possible to avoid the compile error when the workspace dependencies doesn't exist. In our use case all the dependent assemblies (that contain custom config) may not exist. This is expected and we need the rule to ‘fail gracefully’ rather than throw an error. Is it possible to resolve by dynamically adding the dependencies using late binding so the checks are deferred to runtime?  

Hi, I’m trying to run a derivative rule source - final at time dimension so that I can copy the loaded amount across 12 month.In the source I have a Period column with the year. My idea is to bypass the year in one to one mapping and create 12 months using the derivative rule. Something like this  The issue I’m facing is that the derivative is duplicating the rows but not changing the time, however I test for other dimensions and it’s working.Has the time dimension any restriction on derivative rules? Thanks

Hello, Does anyone know if it's possible to rename an existing application through either CAT or other methods? I need to rename App1 to App2. And rename App2 to App1. I know I can make multiple copies to achieve what I need, but trying to see if we can rename to avoid all these copies. Thank you. 

We're currently evaluating the upgrade to OneStream 9.3.1 and noticed that this release requires a move to .NET 10, which appears to be a more significant prerequisite compared to previous 9.x upgrades.For those of you who have already completed or are planning the upgrade, I'd appreciate hearing about your experience and any lessons learned.Questions for the Community1. Infrastructure & CompatibilityDid the .NET 10 requirement introduce any challenges in your environment? Were there any compatibility issues with existing servers, middleware, integrations, or third-party software?2. Upgrade EffortHow much additional effort did the .NET 10 migration add to the overall upgrade? Was the .NET upgrade straightforward, or did you encounter unexpected issues during installation or testing? Were any rollback plans needed? any issues occur and popup related?3. PerformanceHave you observed any performance improvements or regressions after moving to 9.3.1 and .NET 10? Were there any noticeabl

Hi I am trying to build a Genesis dashboard wherein for BI viewer the data source i have taken is cube view , I can not see the toolbar to create a chart or graph after giving source of CV.  

We are using a custom built dashboard to import multiple CSV files to several Import workflows at the same time. Currently the user has to select import separately for each file as the prompt window does not support multi-select. Then all imported files can be Validated and Loaded.The dashboard looks currently like this: Our business thinks this would impact our short closing times severely as users have to do this multiple times after corrections are made and for multiple companies. Rough estimate is about 50 users impacted each closing.Calling a different Windows API functionality should not be a huge change and this could potentially save us a lot of headaches. At the moment we cannot use direct connection to our ERP systems as they are too varied across the companies, so a standardized CSVs are our only option. 

Hello Everyone,I created a pie chart using the BI Viewer in OneStream.The chart displays correctly when viewed directly in BI Viewer. However, once I add the pie chart to a dashboard, the labels are not fully displayed as expected.Has anyone experienced the same issue?Is this a known limitation when embedding BI Viewer components into dashboards? Is there a setting I might be missing? Do you know of any workaround to force labels to display properly?Any feedback or suggestions would be greatly appreciated.Thank you! 

We currently use an ERP to house all of our actual copies of invoices.  Has anyone successfully been able to link Invoices from an ERP to OneStream?  So that when you [Navigate To ‘Drill to ERP’]  it takes you to an actual copy of the invoice back to the original ERP.  Currently we only see limited line item information.

Hello, I am trying to set up the Cube Data Manager solution from Open Place in my working production application. Currently it is all loaded up, but I need a little help figuring out how to add the environment to it containing the applications that I want to work with. Please see pictured below.   Thank you, Jeremy Morgan

We are implementing Transaction Matching with Workflow Channel Import Stage Only. The data is being transformed correctly, but the amount pushed to the solution is the RawAmount instead of the ConvertedAmount. We have also tried Import, Validate (Stage Only), but same result. Is there a property we may be overlooking to have the Workflow Profile push the ConvertedAmount to the solution?

Excel add-in for google sheets | CommunityWhen will “Google Workspace” natively connect with OneStream like “Office 365”?- “Google Sheets” is on its way first?Thank you, OS team.

does anyone have experience running business rules on save of a cube view via excel? I see an old post referring wcfeventhandler. Is there any more robust way by now?

I have a Dashboard Report I am building that consists of multiple Report Components. Each report component was created using a Pivot Grid. Users would like a button to press that allows them to export all of the reports into Excel at the same time, with each report being displayed on a separate sheet of the Excel workbook. Below is a screenshot of the Dashboard for reference.I have a Dashboard Extender Business Rule created for the export button, but I keep running into issues where I can't define the Export File Type as Excel Xlsx.Can anyone tell me if what I am trying to accomplish is even possible and if so, how? 

Hi Folks,In one of my UD2 member , i am trying to apply a specific value of [0] to all base level members of A802 account and a completely different set of values [3000] to all other base level accounts that exist in the A4 account hierarchy. The hierarchy structure is as follows:A4---A5----A501----A502---A8----A801----A802-------A8xxxx------A8xxxx1----A803The issue i face is currently all accounts are coming out with a zero, does anyone know a better way to apply two different type formulas to two different set of base level accounts and allow for natural aggregation of parent values? My logic is as follows:                      Dim accountDimPk As DimPk = api.Pov.AccountDim.DimPk                    Dim currentAccountId As Integer = api.Pov.Account.MemberId                    Dim isParent As Boolean = BRApi.Finance.Members.HasChildren( _                        si, _                        accountDimPk, _                        currentAccountId, _                        Nothing)       

Hi Folks,I need help updating a UD5 member formula that should impact the base level accounts only. I want the consolidation to aggregate/consolidate parent accounts with the calculated base level values.Currently my logic calculates all accounts including the base and parents and no consolidation/aggregation takes place. Basically i want the calculation to happen like the logic below:For example:For a given UD5 Member i.e. growth the member formula is driving certain calculations for the account hierarchy members.  For a parent account 1200, i want the member formula to update values for all its base members using the logic 2*3.For all other accounts beside the account 1200 in the account hierarchy, i want the following logic applied 2+3 at the base level. After these two set of calculations at base level accounts, i want natural OS aggregation to calculate the rest of the accounts in relation to ud5 member where the logic is being applied.Does anyone know how to go about this? Curren

Environment: OneStream Workforce Planning module, PV9.0.0 SV3.0.0.A calculated account in an employee-driven Workforce Planning register throws a divide-by-zero error during Calculate. The formula divides a salaried employee's compensation by a Cube Driver representing their expected monthly hours. For any given employee, that driver correctly returns their real hours value starting the month they are hired, but for any period before their hire date, it returns a literal 0 rather than null or blank. Dividing by that 0 is what triggers the error.Simplified version of the formula (anonymized):IIF(EmployeeGroup="Group_A",  IIF(EmployeeType="Hourly",    Hours*HourlyRate,    Hours*(A#BaseSalary/(IsNull(StandardMonthlyHours,1))),    0  ))What we have tried, and how each attempt failed:IsNull(StandardMonthlyHours, 1). No effect: the driver is not returning null, it is returning an actual 0, so IsNull's substitution logic never triggers. IIF(StandardMonthlyHours=0, 1, StandardMonthlyHours). No

I'm trying to execute a calc after an input data in a CV, when the user click in the OS default save button (giving the flexibility to use a DB, CV or Excel addin with the same CV) Is possible?

Hi,Does anyone know where the StatusValue shown in the WorkflowStatus method is actually stored?I'm trying to locate the source of the workflow status data. I'd expect there to be a table in the Application tables that contains this column. Does anyone know which one it is?

I am getting several errors when setting up a New Task in the Data Import Schedule Manager. We are on OS version 9.01.17403, and I have installed the latest version of DSM, which is 8.4.0_SV100. I suspect this may be a version compatibility issue, so I am curious if anyone has been able to get this solution to work in a 9.01 application. I have already uninstalled and reinstalled the solution, which didn’t resolve the issues.Below are the two errors I am seeing:When choosing Global Scenario from the Scenario(s) drop down list, I get an immediate error “Error processing member. The item was not found. Member, 11111111.” The details state: Unable to execute Business Rule ‘DSM_Paramhelper’ where it appears to be trying to call the Global Scenario by OneStream.Client.Api.DashboardsAjaxServiceReference.DashboardsAjaxServiceClient.GetParameterDisplayInfosUsingDashboardNameCompressed(SessionInfo si, LoadDashboardInfo loadDashboardInfo, Boolean isForDashboardUIWithInteractiveComponents, D

Hello All,We have a workday connected to OS through REST API for data loads. Is it possible to setup a Connector rule for Drill Back using REST API? (I am only seeing examples of SQL and see if an example exists some where)Thank you,MP

Hello everyone,Is it possible using a business rule to make a quick certification for a Certify Workflow?I was abel to complete the Certify Workflow task using business rule but the certification status remains rejected.Thank you in advance for your help.Regards,Antony

Hi, I am trying to load the data from a file into the cube (import validate load steps) via Business Rule and while I am able to load it successfully. I am not sure how to reset it if the job fails in between. For instance: Data pulled from the file gets failed at validate step due to some transformation rule issue. Now if I trigger the rule again , it will not do anything as import step is already completed. I need it to reset clear the cache from stage and redo the load process again when the business rule is triggered. Can you please assist? Below is the code being used  

Dear Community,   It is very easy for a user to add comments on a given cell, using data attachments : However, what are the reporting possibilities for such comments ? Could we use them in dashboard, for instance to be shown as footnote of a dashboard ? Or could these be used as footnotes in pixel-perfect pdf documents generated from a cube view ?   Many thanks,

Is it possible to auto start tasks that are configured with the auto-status function in Task Manager? The auto-status function doesn’t work unless the task is started, which kind of defeats the purpose for my use case below.I have two different requirements from the operational and corporate accounting teams related to journal entries tasks in Task Manager. The operational accounting team posts a single JE for five entities (i.e. month-end allocations) and views this as one task. However, the corporate accounting team needs a view of the close by legal entity, so they would like to see five individual tasks by legal entity for that single JE. I was planning to use the auto-status function to Prepare the individual legal entity tasks once the operational accounting team marks their single task as Prepared using an XFBR. The auto-status function using the XFBR works once the task is started, but manually starting the five individual tasks kind of defeats the purposed of auto preparing it