OneStream Platform Forums

I set the cubeview date to the prior year from the current month input.  I can't get the report title date to show the prior year date, it actually shows the user cubeview date June 2021.  My user input date is 2023M1, and report date is 2022M1 based on the formula T#YearPrior1(|!Param_Time_Select!|)Period(|!Param_Time_Select!|) in the Column formula.  If I put |CVTimeDesc| in the title setting I get June 2021.  How do I get the prior year to show of Jan 2022?

What is the purpose of timeMemFilter, entityMemFilter and scenarioMemFilter parameters for the below function as these will be defined in the cube view? Is there a way to extract aggregated members as a table for the Account and all the UD1 to UD8 dims. Cube views have a limitation of 4 dims on the rows. This is required for an auto feed using OS REST api calls for an external system. We can export base data, dim structures using api calls and perform the aggregations in the external system but wanted to explore the option of aggregated data exports.   BRApi.Import.Data.FdxExecuteCubeView( si, cubeViewName, entityDimName, entityMemFilter, scenarioDimName, scenarioMemFilter, timeMemFilter, nvbParams, includeCellTextCols, useStandardFactTableFields, filter, parallelQueryCount, logStatistics )  

I have 2 rows named row1 and row2.1.  Row1 has two members namely A and B.2. Row2 has three members namely C,D and E.Now, I want to add row1 and row2 so that it sum all A,B,C,D and E.Will this work or will it just take first 2 members(i.e A and C)  of each row? GetDataCell(CVR(Row1) + CVR(Row2)):Name(TotalSum)

Reaching out to the community to see if someone has created a BR to trigger cube loads in a batch or sequence for several WF. Found this snippet but unsure how to use it: Dim objLoadCubeProcessInfo As LoadCubeProcessInfo = BRApi.Import.Process.LoadCube(si, wfClusterPk)

Hi all, I am creating a Reporting UD8 node that provides an on-the-fly calculation of the consolidated data at Budget Rates.It is working (mostly), except for one aspect that relates to the pulling of the percent consolidation data for the base nodes of a higher level parent. In this case,  the percent consolidation for that node is not being picked up correctly. Here is the approach I have taken within the script and the steps to test / resolve. The scripting takes a simple approach of picking the Entity node queried and then pulling the appropriate level of base data, so cycling through all Entity base nodes of a given parent, pulling the PCON, Ex Rate and data point from Actuals in the local layer, and multiplying them together, then cycling through to the next base node.In terms of issue, the issue seems to be if i pick a parent that has one or two layers of parent / children beneath it, it fails to retrieve the correct  PCON information. What the formula does ( a li

Hi, I am looking at the Splash Berlin landing page and was looking for some guidance as to how to create the 2 lines of buttons at the top of the page as I'm trying to create a landing page at present. Thanks for any advice.   

A1=100,A2=200 -> Both are Revenue account type and doesnt have any formula.D1=A1+A2 ->Account type and Formula type -> Both are dynamicCalcD2->Account type and Formula type -> Both are dynamicCalcWill the below formula works?D2=D1+100

Hi,Can we someone disable/hide these button from the dashboards?There are few dashboards which are accessed by multiple users to input data. Accidentally , if any user clicks complete form after updating the numbers then it locks the dashboard and restrict users to input again.Its a hustle to explain the same thing again to the users to avoid clicking "Complete Form" button after every inputs.Is there any way where we can hide it so that they cannot mark the form completed? 

This feels like it should be easy, but I'm struggling to get it working correctly... We're trying to build-out a variance scenario where folks can enter data to bridge their forecast to actual. Our set-up is similar to the variance set-up in GolfStream where we've created a variance scenario, a few dedicated variance accounts (Sales, EBITDA, etc.) and then flows to house the different drivers of the variance (e.g., volume, mix, etc.).Where we're struggling is with the View set-up. We would like to have users enter variances for MTD activity only, but we want the MTD data entered to total up to a YTD number (i.e., enter discrete values for January, February, and March, but then be able to use V#YTD in a report to get the total of the Jan/Feb/Mar variances entered for a given account/flow combination). I've tried setting the scenario up for MTD, and the form works fine for the first month we tested. However, when we open the form that's we've created for a subsequent month we get the val

Hello everyone,  we are building an excel based report to get the account hireachy , entity hirerachy. any one having any examples please provide me. =XFGetRelationshipProperty() =XFGetHierarchyProperty()

Hello,I have a REST API which has been tested in POSTMAN. The problem is data is being pushed into OneStream. So how would this work in the BR. Any help would be appreciated. Thank You,Indu

We have recently upgraded to version 6.5 from 5.1. Our Power BI consultants want to try the REST API to pull data out from OneStream repositories. Anyone has done this before and knows what setup/configuration need to perform before using REST API? Thanks

Wondering if anyone can help with this one.  This happens like 1 out of every 3 times logging into OS where when I click external service provider it just pulls this blank screen and won’t let me log in upon repeated attempts unless I fully shut down and restart excel.

Hello - I have a cube view that I created a connection to in Excel. The cube view has an O#Forms POV with a column configured to enter comments - can modify data is set to True, it has a V#VarianceCommentary member, etc. During testing I am able to submit comments through this Excel sheet, since I also see the comments within the application as well (I have a dashboard that calls a similar one set for commentary). However the users I built the CVs for are only able to submit comments through the application - when they attempt to add them through Excel, either they simply can't add text or when they click Submit Sheet at the top the comment disappears. I made sure the settings, cell formats, etc. for commentary are the same for both the application and Excel connection cube views. Are there any Excel specific settings that I need to check for these users?

Hi Everyone!.I have the problem that a button is applying processes to a closed Forecast, for example, the open forecast is for June, but a user could select March or April and reapply those processes to those months that are supposed to be locked. In my case, it applies those processes even when the selected Forecast is closed, so it would help me if you could show me a way to validate it in the BR so that that process does not run (By process, I also refer to Data Management or a Business Rule).

In the case of a parallel hierarchy the status of the entity changes if the data is modified on the scope of another hierarchy,Example: Entity A is 100% owned by parent A, and 90% owned by parent B; we enter the scope with Parent A on the 1st of the month, we launch the consolidation with scope A and the entity has an ok status; on the 20th of the month we load the scope with parent B; the status of the entity is changed under parent A as the scope data is entered in local and the parent becomes a partner.How can we ensure that the status of A does not change under parent A after changing scope B? THANKS

Hi all,I am designing a dashboard home page whereby users can navigate directly to the different Workflows for Statutory reporting and Management Reporting, via a button.I am utilising the Change Workflow action in the button settings to set the scenario, however I have an issue as it is not picking up the correct Cube Root Workflow Profile.As you can see in the screenshot below, Act_Stat and Act_Mgmt both sit under MGMT_ACT Cube Root WF Profile (and they both sit under STAT_ACT as well). So when my workflow is set to MGMT_ACT, and I run the button, it doesn’t open the scenario in the correct CRWP. I had a go at adding CubeRoot to the button POV Action, but it didn’t do anything.Does anyone have any idea how I can change the Cube Root Workflow Profile by using this button below, if at all possible?The less pop-up menus and clicks the better for the accountants!ThanksAndrew  

When end users utilize the excel add in functionality, they are only able to calculate 1 year at a time using the calculate button.  Is there a solution to allow users to calculate all (multiple) years shown on the cube view with a click of 1 button in the excel add in?

Hi all,We are successfully uploading budget information in an excel template. This is a matrix load containing 12 periods of data. For each line the user can upload a textvalue. This is also working. However, the comment is uploaded to each month. However, if there is no data for a particular month (which can happen) the comments are aggregated. For example: I have data in 2024M4 and 2024M12 for the budget. It is a periodic budget. Now I have the comment 4 times in 2024M4 and 8 times in 2024M12. Is there a way in a matrix excel upload to upload the textvalue only for the last period?What else could I do to overcome this issue?With kind regards,Tim

Hi,I've created a tree view component using a business rule which works as expected. The part I'm struggling with is to make it so that it automatically scrolls to the selected tree view item when the dashboard opens like it does when selecting a new workflow view. Does anybody know how to do this?

We have deleted certain transformation rule under 1:1 and while deleting, my other colleague was also updating the same transformation rule group.All those rule are showing up in the validate step as an error even though they are deleted.Error - > "Unmapped items" and then ask me to assign even though they don't exist. How can i get rid of them ?  ( have tried extracting trx , in the extract file, it doesn't show up)

Copy pasting multiple rows / columns seems to auto transpose the values (turns rows into columns, and columns into rows). This is frustrating for end users who are trying to use the cube views to input their values.  Is there a fix for this?

When using cube views to input values, it seems that we are unable to copy paste % values. We must convert it to numerical values and only then does OS allow paste into the % input cells.  Is there a fix for this?

Hi all, I've col A and col B.I want to show a dynamically calculated col C which should be based on below logic: If col A has no data then display col B Else display col A Please suggest the best options to achieve this. Can it be handled in cube views or requires dynamic calc member formula. Thanks in advance

Kinda of a silly question  I was building a cubeview and was trying to adjust the expansion on the layout.  It was set to default view, which got me to wondering where are these default selections set.  I first looked through the documentation, then remembered this is OneStream and this wouldn't be in any documentation.    I know we can set all this up in templates but are these defaults stored someplace else that we can set them?   Oh and I am not talking about the ones in the Application Properties.