OneStream Platform Forums

Hi, I am working on extracting data from a Cube view to a flat file. I am using FDXExecuteCubeView query to extract. The extract file is executed to run for one year. I am seeing for each Entity, Scenario, Time (DU) a log entry is created in Task Activity. The Task Activity is getting flooded with cube view log entries. Is there a way to stop the Cube view entries for each Page (Entity, Scenario, Time).? On the Cube view I have the log setting set to False and also in the FDXExecuteCubeView setting I have the logStatistics setting set to False. Is there a way to not log the entry for each time cube view is run for (Entity, Scenario, Period)?  Appreciate your inputs!

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.   

I'm having an issue in which derived YTD values are consolidating in their period and it is throwing off our results.  In the example below which shows expenses by department for a site, there are no longer expenses for the Mfg_Selling dept in M2.  OneStream calculates the derived YTD values of -37905 (0 - the prior period expense of 37905).  This I understand.  What I don't understand is why that value is consolidating up the hierarchy when the view is set to periodic.  NOTE: I know how to hide the derived value in Mfg_Selling/M2, it is shown here for illustrative purposes.  

Hi allit seems that OS 8.4 notification settings by default only send emails to 50 users. Could this setting this changed / amended and if so in which part of the application?Thank you Nou

Hi all,I'm trying to figure out how to leverage on Report Scripts using OneStream objects. Is it possible to leverage on BRApi inside scripts events ? A direct call to BRApi class results in an error, I'm wondering if there's some workaround or trick to reach the object.Best RegardsFabioG

Hello,I am trying to execute this assembly at load time for this specific dashboard.The rule executes as expected, but I cannot seem to get the parameter to function properly. Here is how it is returning in the log:It's as if it is not reading it as a parameter at all. Any suggestions? 

Hi all, I'm trying to build a trial balance that shows line items in their natural debit/credit balances (e.g. - revenue, liabilities, and equity showing up as negative, and all else showing up as positive to arrive at a balanced ($0) report). However, we have some contra-accounts within our Accrued Expenses roll up that should show up as debits instead of credits. The accounts all begin with JDE_1 so I thought I could use the IF statement below to change the formatting for them, but the IF doesn't change anything (everything shows up as a negative, rather than accounts beginning JDE_1 being positive). Does anyone have any ideas as to what may be going awry? This IF statement has worked in other cube views that I've built, so I'm at my wit's end as to why it wouldn't be working here! If (RowE1MemberName StartsWith 'JDE_1') Then FlipSign = False Else FlipSign = True End If

I'm fairly new to OneStream. I've a requirement where if ICP is P213 and irrespective of any source entity then target entity will be "Chicago" and if Source entity is "E123" then target entity will be "New York". The problem which I'm facing is that I do have "E123" in source file where it only takes the mapping of "E123"->"New York". It doesn't even see if the ICP is P213.

Has anyone come across a bug that causes S4 HANA - URL drill-back to get truncated on execution? We are calling a remote URL that opens the Fiori app.  The actual URL gets cut off from the # sign from the OS Drill-back in the browser. Simple code in use - The drillback code is:drillBackInfo.DisplayType = ConnectorDrillBackDisplayTypes.WebUrlPopOutDefaultBrowser.OneStream Support reported this as a bug in the solution.  Any thoughts?

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.   

Our beginning balance formula is as follows: 'Check to see if we are in period 1If api.Time.IsFirstPeriodInYear() Then      ......... Else     ............... This formula worked perfectly rolling from 2023 into 2024, but now in 2025 we are having issues. EX: In Feb 2025, the beginning balance is reverting back to Dec 24 instead of Jan 25. Any insight into where I might start in figuring out this error? I tried looking at our business rules for api.time and didn't see anything that stood out.  Thanks!  

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?

Hello, I'm working on writing a budget report for my company and we have these summary accounts that all start with "S_" and the parent name (i.e. ExtSales would be S_ExtSales). Is there a way I can use substitution variable on my column override, where I wouldn't have to go in and change every line to update the override? Thanks, Will

Dear colleagues, Could you please advise why error Pov occurred in cube view calculated columns (I use formula GetDataCell in member filter in these columns) when I click save button in order to save text comments in column VarianceExplanation (this column contains member V#VarianceExplanation). When I reload this cube view again this error removes, and I also see that text was saved. See below error:  

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.  

I am having issues with my dashboard appearing on my iPad after clicking through one of the buttons I created (going from one DB to another).  It seems to work properly within the application on my PC but when I navigate on my iPad the next page goes blank.  I made sure the naming convention I want to navigate to is correct.  Is this a potential bug that this doesn't work on mobile device?  Here is the button property I used for navigation:   

Our team submits topside entries in OneStream using the Adj channel. Upon a journal reaching "Submitted" status, I want our application to send an email notification to the approver that the journal is ready for review. We already have email notifications up and running for our application. I would like to have the email distributed based on a security group we have, CorpAdjApprover. Any ideas on how I can set this up? Would it go through an Event Handler business rule? Thanks in advance.

Hi I have created a workflow and need to assign entities however they are not showing up on the list. The only one which is showing up is NoneWhat could be the reason for this?  Regards

Hello Experts, I am wondering if any one has worked on requirement where 2 entities need to be translated at 2 different rates for Budget scenario. I know how we can translate entire scenario by historical rate. I am not sure having entity filters will work in this case or I should be looking at different approach?Thanks,MP

Hello,Something a little different here. Below is an OS Dashboard. The client is leveraging SmartLinks to navigate specified users here (via Email). Upon selecting the link, the user is navigated here on the browser.The first red box indicates the Project to select. SmartLinks allows this to be prepopulated so the dashboard is defaulted with the correct information upon arrival.Everything is working as expected besides the pesky SQL table editor component. Web View:It is important to note that the SQL Table Editor component is populated via Dashboard Extender rule, which is executed when the Project is selected. In this case, the project is already selected, but I cant seem to get the extender rule to execute upon arrival to the dashboard. Any ideas? I want to believe this is less with the new SmartLinks feature and more with standard OS logic.

I would like to create the Report that runs to multiple Entities and my table of content would be list of Entity.I would like to make use of report designer component which is in OneStream .Can someone please help me understand how to do that 

Hi everyoneWe want to do a sign flip on an account to be applicable from a certain period. The sign flip must therefore not have an affect on historic periods. The requirement is as follows:Perform a sign flip on an account data coming from a source system using a transformation rule complex expression where the month period is > 202412.We would appreciate suggestion from anyone who has performed something similar in the past. ThanksJohan

Hi, Does anyone have an example where multiple dbwheres on the same column are executed?The syntax seems to support AND/OR, but I can't seem to get it working.  I have the following dbWheres (without the AND/OR part): Dim dbWhereEntity As New DbWhere("Entity", dboperator.In, entityFilter) Dim dbWhereResignationDate As New DbWhere("TermDate", dboperator.IsGreaterThan, dateEndOfMonth) Dim dbWhereResignationDate2 As New DbWhere("TermDate", dboperator.IsEqualTo, Nothing) Individually, the ResignationDate dbwheres seem to work. The SQL statement needs to look something like this: SELECT * FROM MyTable WHERE (TermDate > @DateEndOfMonth OR TermDate IS NULL) AND Entity = 'MyEntity'; (I know I could build a SQL statement and execute that as a work-around, but I'm just curious how this works) Any help is appreciated, thanks!

Does someone knows the syntax to call a memberlist that is written in a Finance MemberList service accessed via a service factory? I've tried many forms but cannot get to my code. Thanks

Has anyone been able to get an extensibility rule to work in the workspace assemblies? I've looked and I haven't seen much of any documentation on this. I'm working in 8.4 and have the rule working when I have it using the regular extensibility business rule which is attached to a DM job to run. When I try to move it to a workspace assembly and put it on a DM job it doesn't work. I've created a new file as the Extensibility Business rule source code and have the same code with no errors. I don't see an option in the Ws Assembly Factory to specifically call out extensibility rules either. So far I've been successful with getting an XFBR, Extender Rule and Custom calculate rule to work in assemblies but extensibility doesn't seem to work. Below is the error I am getting.