OneStream Platform Forums

Hello, I an trying to write a calculation to divide one number by another one and have it to flow into a new account. Below is the formula I am using, but I am not getting the date to calculate. Can someone assist on how to write it correctly.    Calculate("A#mpg test","Divide(A#33010, A#33005)",deptFilter)

We’re looking for some kind of way to reference dates in the transaction matching custom filter. For instance I need to be able to reference an attribute (like A9 = ‘ABC’) and also only pull items for D1 = yesterday and then pull another attribute (like A9 = ‘XYZ’) and also only pull items for D1 = two days ago. So the filter would look something like: (A9 = ‘ABC’ and D1 = yesterday) or (A9 = ‘XYZ’ and D1 = two days ago)

I am trying to get prior year actuals in the same column as current year actuals.  The code i am using in the CV is above.  This result pulling back in YTD prior year but I want monthly value for prior year.  

I am trying to export Data including dynamically calculated accounts using a DataBuffer (Not just base members but all intermediate levels).I can do this by looping over Accounts+U1+U2 combined with GetDataCell()... but it is unbearably long and inefficientI am wondering if we can use a data buffer this way ? If not what would the best method be ?  Dim MFEntity As String = "E#TopEntity.TreeDescendants.Where(Text1 Contains 'myValue')" Dim lstofEntities As List(Of MemberInfo) = BRApi.Finance.Metadata.GetMembersUsingFilter(si, "Entity_Dimension", MFEntity, True) Dim MFAccounts As String = "A#Root.Base.Where(AccountType = 'DynamicCalc')" Dim lstofAccounts As List(Of MemberInfo) = BRApi.Finance.Metadata.GetMembersUsingFilter(si, "Account_Dimension", MFAccounts, True) Dim lstofAccountsStr As String = String.Join(", ", lstofAccounts.Select(Function(x) "A#" & x.Member.Name).ToList()) For Each myEntity In lstofEntities Dim mfDataBuffer As String = "FilterMembers(E#" & myEn

Hi All, Can someone explain to me how the StageLoadToFinanceResult table could be empty?  It's my understanding this table gets populated after each load and it's what OS uses to determine what to clear out prior to reloading data from the same workflow.  I am looking at an application with no data in this table which is baffling to me even after performing a load.  Can someone provide an obvious answer to this....perhaps I am not thinking of something obvious. Thx,Mike

Hello all, I'm repeatedly seeing a warning about "A virtual machine in your environment has maintained allocated memory over 85 percent full for the last 12 hours".  In your experience, what's the best way to chase down the root cause or contributing factors to alleviate this?

Hi,  Is there anyone who succeded copying attachment files one period to another period ? There is a getdataattachment function, however I don´t see setdataattachment.  Thanks in advance  Buket

Hi, We are facing a strange issue with Excel QuickViews.  When a non-admin user tries simple quick view, user is getting below message. But when admin tries, he is getting all of the data in single page. We have tried changing all the settings on Max rows, Max seconds, almost 100s of combinations (from 1000 to Billion) but no luck.  Any thoughts on why this is happening? We are using slice security for users. Page 1. Use row paging buttons in Task Pane.

I have a number of column definitions that will use the same Row Range in the Row Overrides.  I would like to use a parameter or XFBR for this, but neither seem to work for this specific field in the Row Overrides. i.e. I can only specify row names. Below is an example of what I am trying to do. Has anyone accomplished this?  

Hi, I have a workflow with a certification as the last step. I can change the status of the questionnaire every month except December. I am an administrator user.  Dec:     Nov:         Do you know how to activate the option in December? Regards, Sara.  

Thought I would share this from one of our Distinguished Architects: Although uncommon, but occasionally happens: Someone closed the workflows! This usually happens during or just after end user training. You’re probably wondering ‘how do people do this when it’s not something we show them?’. Your guess is as good as mine especially since a dialog box opens to ask them if they’re sure they want to close the workflows. So then the next questions are: How do I re-open them? Who closed them? Can I prevent it from happening in the future?   Answers: Go to the top workflow for the scenario and year that was closed and you should see Open WF (step 3).         To find out who closed the WF, you select the cube root WF in OnePlace for the specific scenario and year that was closed. Then in the right window, right click and click Audit (your menu might be slightly different from mine).         In the pop up window, expand Manage Workflow

Hello, I am working on a client that already had OneStream implemented.  I am now tasked with introducing additional functionality.  I am experiencing an issue I have not seen before.  When I am in the dimensions page, searching a dimension using the binocular function.  I can search the name and see all of the names pop up in a window.  I then am able to select one and when I click View in Hierarchy the wheel spins and spins, never taking me to the location of that member.  I did notice if I do those steps and the wheel starts spinning and I immediately close OneStream down and go back into the dimensions it opens up with that member I was searching showing on the screen.  So in this case it is faster for me to perform the search, exit, log back in and see the result.  Has anyone else experienced this?  And I have worked with clients that have much larger dimensions than the one I am searching on and have not experienced this. Thanks in adv

We are trying to create an advanced chart using a secondary y axis and are running into issues.  We referenced https://community.onestreamsoftware.com/t5/Implementation-Q-A-Archive/Question-In-Advanced-Chart-component-of-a-Dashboard-can-you-show/ta-p/1551 blog which explains how to code the business rule.  However, there is no place within the chart to reference the cubeview and when we run the dashboard, we get an error message stating the data adapter type does not match the chart type.  Any solutions or if there's any document we can refer to which would show end to end flow around the cubeview, data adapter, business rule, and chart?  Below are screenshots of our data adapter, chart, and dashboard error.  

Hi everyone! I'm currently building a linked cube view that will inherit the Entity and IC members from the original cube view from which it is called. The IC member, though, will need to go through a transformation (remove the last 3 digits) so I created a XFBR rule to do so. For example, if the Entity member will be 1010TRW, the IC will be 1010. I tried to call the XFBR rule in the POV but when I launch it it returns the following error: "Index and length must refer to a location within the string."   Am I missing something? Below you can find a screenshot of the POV of the linked CV Thank you in advance!

Hello, I am using a cube view that has the same rows, but it needs different columns based on the UD8 member. I built multiple template columns cube views, and created a parameter for UD8 members. I want to retrieve the column template CV based on the selection of UD8. I created the following XFBR: I then attached it to the main Cube View: When I run it, and select UD8, nothing appears: If I put directly the template name, the cube view runs with no issues, showing data as well. Any idea why it is not working? Thanks, Ioana    

Is there any documentation available on standalone cube vs extensible cube? it can be pros/cons or functionality differences like data transfers

Hi - Has anyone done WEBAPI through SIC ? I followed the document and I am not successful connecting to the endpoint. All I am trying to get the HTTP response. There are no issue from the firewall and thr port are open. We are able to successfully execute the endpoint from POSTMAN.   Any help would be appreciated.   Thanks    

Can somedody help me on how to connect the golf database to OneStream 

Hi,Can OneStream consume Json data (retrieved with a API from 3rd party system) or must it be converted?Thanks

We have several workflows that for audit backup we have the users attach documents.  With employee turnover the next person didn't know they had to attach the document.  Is there something like an After Event rule you can do to check that something was attached or in a confirmation step?

Hi  I create OneStream parameters for the fields that I want to bring in from OneStream into an extensible document in order not to mess up the formatting of the document as the formula is very long to pull the data into OneStream.  Now I want to create a parameter that uses a business rule to check if the amounts for one line of the two year's  income statement (This year and last year) lines are both positive, then put "Profit" in the text of the account or "Profit/Loss" if the one amount is positive and the other is negative or "Loss" if both amounts are negative.   How do i do that ?     

Hello, I am receiving the error "Entry with the same key already exists" when trying to load a xml through a workflow. I have checked all of the dimensions, transformation rules, data sources, etc. and am not finding any duplication. Looking online I see recommendations on other platforms where the issue relates to a ListDictionary and Add within the code where it tries to add something that may already exist?  I am curious if anyone has ran across this issue and how you resolved it.   Summary: An entry with the same key already exists. ---------------------------------------- Description: An entry with the same key already exists. Error Time: 3/3/2023 10:03:03 PM Error Level: Error Tier: AppServer App Server XF Version: 6.8.1.13230 App Server OS Version: Microsoft Windows NT 10.0.14393.0 Total Memory: 68,719,005,696 (64.00 GB) Memory In Use: 1,979,629,568 (1.84 GB) Private Memory In Use: 2,175,569,920 (2.03 GB) Peak Memory In Use: 2,666,090,496 (2.48 GB) Maximum

Hi everyone! Quick question - I have a workflow profile which is used for the Actual scenario in order to post central overlay adjustments. This all works fine for our needs. However, when it comes to other scenarios like Budget, Forecast, etc, it's just not at all relevant and my hope is that I can simply switch off the whole workflow in certain scenarios. However I can't see a setting for this in workflow profiles. I can see I can easily make individual Forms and Import steps not appear according to scenario (in the "Profile Active" setting) but I can't see a way to switch off the entire workflow for any given scenario. PS - the idea is that someone doesn't have to click through a bunch of forms in the budget/forecast every time which will always have zero/nil entries in them. Let me know if you've got any ideas! Thanks,Richard

Hi Everyone. How do I add an entity to this section of a workflow profile?  

Hi All, Does anyone have any good advice on what Workspaces should be created in the application dashboards screen beyond Default?  In reading the guide, workspaces seem to have a lot of focus on separating development activities or perhaps for partner place solutions(?).  I am struggling a bit to understand at what level to offer a different workspace.  We have been toying with the idea of having a separate workspace for Actuals and Planning but as 90% of our dashboards live in Planning, not 100% sure this is the best use of this split. Any practical advice on the kind of workspaces that people are setting up that adds value?  I want to make sure we are using them in their best manner. Thx, Mike