OneStream Platform Forums

Hi All,I want to copy Data seed from one scenario to another scenario.(example current year actual to Prior year actual Scenario with different rate.can anyone help on this

Hi all,  In my delimited upload file (trail balance) there are two columns that include amounts: beginning balance and the sum of periodic movements. The sum of the two is the number I want uploaded in the import stage.  Is there a way to make OneStream add an additional calculated column (source dimension) to the datasource with the sum of the two columns (so prior to transformation / validate / process)?  Any help would be much appreciated!

Hello,Is there an event handler or dashboard extender rule that could be used to stop a user from completing a workspace if certain steps are not completed first? I have a workspace that needs to be completed, but only after the import, journals and certain forms are completed first. We don't want to lock the workspace, rather when they go click the "Complete Workspace" button it gives an error message that they need to finish the other steps first. Thank you!

Hello Experts,I am trying to pass cube bound parameters to a BR to do something with it. I can read all parameter except Cube Name. For some reason it is blank. Anyone came across this issue?  Cube Definition:Reading in BR as below:Dim CubeName As String = args.NameValuePairs("DrilledCube")brapi.ErrorLog.LogMessage(si, "DrilledCube:- "+CubeName)

We are still in the development stage of our OneStream implementation.  We are currently running 7.4.  When v8.0 came out, I started doing some research on .NET6 (and 7).  It appears that Microsoft is more focused on CSharp than they are on Visual Basic.  I believe, eventually, Visual Basic will be deprecated.  With this in mind, and since we are still in development, I was thinking about converting our VB business rules to CSharp and using that language going forward.I would like the feedback of the OneStream Community before I take this project on. Thank you.

Hi everyone! I have two entity hierarchies, one in currency EUR, and one in USD. I need to create a cube view to retrieve the FX rates based on the parent’s currency. I’ve created an account, for example ClosingRate, as a DynamicCalc. I am using this formula to retrieve the rate: api.FxRates.GetCalculatedFxRate(rateType, cubeId, timeId, sourceCurrId, destCurrId)   For the destination currency, it’s straightforward: Dim destCurrId As Integer = api.Pov.Cons.MemberPk.MemberId But I am unsure how to set the source currency as variable, I usually either set it to EUR, or USD. Dim sourceCurrId As Integer = Currency.EUR.Id Is there a way to get a parent’s currency? Or, I had another idea. To create a Text1 property at the level of each entity base member, to specify the Parent’s currency. I can retrieve it in the script as a string, but after that I don’t know how to get the Id. Appreciate your help! Thank you!

Dear Community, I have a requirement to apply conditional formatting for a parent member which has it's children members underneath it (eg., A#Cash.ChildrenInclusive). So, when I apply formatting, it automatically applies for it's children member too. Here, I have applied "ExcelTopBorder" cell formatting for the parent member and it got applied to all the children members too. 

I am using powerpoint xfdoc to pull CV using alt text. This cube view had 3 parameters, each with 2 or 3 values. The ask is to pull each combination of those parameter on a different slide of the ppt. Is there a way to achieve that outside of report books loop feature where I can only export it as pdf?

Hi,We are trying to Display User Time when we export the report to excel on Excel Header. We tried using this code, but it is giving us the UTC Time.If args.FunctionName.XFEqualsIgnoreCase("DateandTime") ThenDim localTime As DateTime = DateTime.UtcNowDim timeZone As TimeZone = TimeZone.CurrentTimeZonelocalTime = timeZone.ToLocalTime(localTime)Dim formattedTime As String = localTime.ToString("yyyy-MM-dd HH:mm:ss")Return formattedTime End If Is there any way to display the User specific Time?Thank you  

Dear Team,I saw this topic few times, but with none solution - hopefully this feature was implemented.Is there a possibility to set OneStream in dark mode? Thank you 

hi,Two account A and B needs to be subtracted in the source applicaiton and assigned to the third account on destination application  in the transformation rule for App2App copy process . Below is my Composite but its throwing error for one-one transformaton mapping.  TR Composite Rule:Validaiton error:  

Hi guyswe frequently work with data buffer (or sometimes even with setcell) and there's a problem for which I coudn't find a solution. E.g. we have an allocation setting the values to certain intersections in the target data buffer. If among all cells to write some of them are invalid intersection (not within the constraints of the account for one or more Flow/Ud element), there's no error and they are simply not written. From here: is there a function to test an intersection and check whether it's valid or not? Is there a function to do that for the whole databuffer without loops and get the list of invalid records?Even worse, sometimes the target members don't exist and we just get an error. But I need to log the data buffer and investigate each single row to identify where the problem is. Is there a function or a best practice to get a log with the rows in error in case the target members don't exist?We found this function(s) api.Account.IsFlowICOrUDMemberWithinConstraintM

I am debugging some business rules.  I would like to add a Console.WriteLine, but I am not sure where that gets written to.  I would like to avoid clogging up "Error Logs" and a simple MsgBox is not enough. Any suggestions on where to look? Thank you.

Hi, sorry I always get a bit confused on how to use parameters in data management sequences/steps.I have a dashboard with: a combo-box that let users select an Entity member; a cube-view which Pov is based on the combo-box selection; a button which runs a data management sequence.The combo-box bound parameter uses a member list.The data management sequence contains only one step, which is a custom calculate.I would like the data management step to run on the selected Entity member (the one selected in the combo-box). How do I link the Entity of the data management step to the selected Entity member?With the current Entity filter setup in the data management step:- I can run the step from Application/Data management page and I am prompted to select an Entity. No issue in this case.- I receive an error if running the data management sequence from the dashboard (Summary: Error processing Data Management Step 'Plan_Growth_Adjs'. Invalid parameter. Entity Filter, |!prm_plan_bu_entity!|.)&nb

After an application copy , We usually go to the newly copied application and disable/delete the tasks.TIP->  You can press CTRL+A or can select multiple task by pressing shift and then Delete it.It might be that you already know about this, but just sharing the tip for the wider community.

Hoping someone in the community might have a solution for this and is willing to share a snippet of code that will enable us to properly 'clear' any data (including zero) from a specific intersection so that we can delete a metadata member.The DM step "Clear Data" is simply too all-encompassing to use in this case and we need to be more surgical in our approach.Thanks in advance for any assistance.

Good afternoon,Can anyone share their experience of the potential impacts of switching the Cube Consolidation Algorithm Type from "Standard (Calc-on-the-fly share and hierarchy elimination)" to "Org-By-Period Elimination"? I am balancing the decision between making a second cube with the different algorithm type vs changing the algorithm type of our current primary cube.I'm curious if anyone has any experience with the algorithm type outside of OneStream included documentation (see below) like consolidation time performance impacts."Org-By-Period EliminationThe Org-By-Period Elimination Consolidation Algorithm Type uses the calc-on-the-fly Share – as in Standard – but has unique elimination considerations. When determining if the data cell’s IC Member is a descendant of the Entity being consolidated, this Consolidation Algorithm Type considers the position of the Entity in the hierarchy and also checks the Percent Consolidation for every relationship down the hierarchy. If Percent Cons

I have application which has 47 entities and users who have Entity wise rights to upload TB/Reclass and Cube views. So far Admin is downloading TB  manually (using view source document) by going through Entity.  Now I want to download TB and Reclass files through some business rules (if possible to be schedule to run once in Month) or some procedure for all entities using user who has administrative privilege.   Thanks all in advance for your help. Regards, Yashwant

Hello Team!I am trying to save a spreadsheet file using the native "Save As Application Dashboard File" button.    I am running OS 7.4.2 but also tried on 7.4.1.It seems that it is only possible to save in a DEFAULT workspace on both OS version. Could someone confirm that? Now, if you save in a DEFAULT workspace under a specific Dashboard, I would like to know where is this file saved. I tried to extract the dashboard where I saved the file but nothing shows in the XML. So how do we extract it and where is it saved? I can see it in the Database under DashboardFileResource, but not under this Dashboard Files. Thanks  

Hi,I need to create an account to calculate two values multiply together.I had set formulapass2 and set the formula as below:api.Data.ClearCalculatedData("A#COG762D:U1#None",True,True,True)api.data.calculate("A#COG762D:U1#None = A#COG931:U1#ALLDEPT * A#KPI142:U1#1520")It shows zeros while A#COG931:U1#ALLDEPT is 100 and A#KPI142:U1#1520 is 25.May I know why? Thank you.

Hi All, I want to seed the data from below source, please help me how to write a code for the below data copy. Target:- api.Data.Calculate("V#PERIODIC:O#Import:U3#" & UD3 & ":U8#UND_UD8:U4#" & CurrWk & "= Source:- RemoveZeros(S#Actual:U4#TOP:T#" & Priortime & " - S#Weekly_Processes:U4#Week_1:T#" & Priortime & " - S#Weekly_Processes:U4#Week_2:T#" & Priortime & " - S#Weekly_Processes:U4#Week_3:T#" & Priortime & " - S#Weekly_Processes:U4#Week_4:T#" & Priortime & ")","A#KPI_PPV_MONTHLY,A#KPI_TOT_PURCH_DPO",,,,,,,,,,,"U8#Top",,,True)

1. We have a very basic "standard entity workflow" with Import, Forms and Adjs.2. Local uses does his job and lock the workflow and the related entity assigned to that workflow. Fine..... And now we are lost.How the consolidator can post central adjs OwnerPostAdj? If we try to post the journal we receive:"Data validation error. Workflow Profile 'BlaBlaBla' is locked for 'Actual', '2023M4', 'AdjInput', and Workflow Channel 'Standard'."Is there a native configuration to enable "OwnerPostAdj" on a locked company?Or, if it is not a standard Onestream feature, are you aware of any a basic workaround to enable it ?Thanks in advanceMarcello

Hello,I was reading below thread and wanted to try that out. Unfortunately that didn't work which might be due to OneStream version:https://community.onestreamsoftware.com/t5/Office-Hours/Data-was-loaded-to-People-Planning-then-Loaded-into-the-cube/ta-p/1254What I wanna now is if there are any way to remove the loaded cube data from the workflow. The Clear button seems to only clear stage + workflow but not Cube.Above advice was quite interesting but it gives me following error:    

Hi all,I'm currently developing a dashboard for a client and I need to assign a literal value to a dashboard parameter from the BR code. I'll try to explain the issue better:I created the following parameter "test" within a dashboard group: within the BR, I entered the following: In this case, I'm trying to assign the text "SampleText" to the parameter "test".I then created a combo box, I assigned the parameter "test" as a bound parameter, and placed the combo box in the dashboard: My goal is that, once triggered the BR, I will be able to see "SampleText" in the dashboard. Once the BR is triggered, though, no value is assigned to the parameter, and the combo box remains empty. What am I doing wrong? 

Guys, there is a requirement where we have to use a single template for all the 5 forms in  a workflow and depending on which form the user selects the rows and columns should generate dynamically . Is there any way we can get the Selected Form name in a BR. Or Is there any other solution for this Problem?  Thanks a Lot.