OneStream Platform Forums

This is the layout of my CVI'm using an XFBR in rows (and columns); the rules for each scenario are different; how do I get the context from the columns?In other words, when the scenario is Budget I want to apply specific rules for that scenario, same thing for Actual. This would be the script:   Namespace Workspace.__WsNamespacePrefix.__WsAssemblyName.BusinessRule.DashboardStringFunction.REP_ParamHelper Public Class MainClass Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As DashboardStringFunctionArgs) As Object Try If args.FunctionName.XFEqualsIgnoreCase("GetAccount") Then //Do something End If End Function End Class End Namespace 

Hi,We are currently using a Dashboard that allows admin to remove users from Security groups. I would like to enhance this functionality so that approvers, rather than admins, have the ability to remove users from security groups.Currently, the system security roles under the " System tab" are set to "ADMIN" by default for the "Manage System Security Groups" setting.Unfortunately, we cannot make changes to these System Security roles due to the large number of approvers across various groups.Could you offer suggestions or guidance on how we can implement this enhancement effectively?Thanks in advance.

Hello everyone!I require some assistance regarding the following objectives that I have in mind for this cube view.Showing the monthly data input cells (which I have done), along with the total sum of all the months in the year.Getting a percentage by using the monthly data / current year.Currently, the Amount 227.00 under actuals - 2025 column is a member filter under rows/columns whereby i use getDataCell(CVC(Col, 1) + CVC(Col, 2) .... CVC(Col, 12)) which I know it isn't the best idea. But I want the column under 'Total' to show this amount and with this amount, I will calculate the percentage in the next table.For example, on the 2nd table (green cells), on row ACTYPE001, when the user click calculate, the answer should be 1/227 x 100 = 0.44% at Jan 2025, 2/227 x 100 = 0.88% at Feb 2025.Please advice on how I should approach these issues or any improvement or suggestion I should be doing.  

After having read a lot of this superb forum to discover OneStream, I'd like to ask you my first problem that I haven't managed to solve. I'd like to forecast sales for month M in relation to actual sales for month M-1 (if imported), or alternatively the M-1 budget, to which will be added management sales. If I perform this calculation in the view cube of the child entity, it replaces the actual M-1 with the budget when the actual M-1 does not exist (not imported).If I perform this calculation at parent entity level, entities with no M-1 actual are shown at €0 and not at the amount of their budget. I therefore end up with a sales figure that has been reduced by the number of companies that did not report sales in M-1. In my forecast calculation UD7, I was thinking of looping through each base member so that the condition calculation (if the actual is absent then takes the budget, otherwise takes the actual) so that the forecast sales figure displayed corresponds to the sum of the indiv

Hi everyone, I'm currently working on a Cube View and would love some help with setting up conditional formatting based on a comparison between two columns. Specifically, I’m trying to highlight in red any cell in the “Actuals” column (Actual CPK @ ACT 2024 rate, Jan 2024) where the value is greater than the corresponding value in the “Cost per kg” column. To give you a clearer picture, I’ve attached a screenshot showing the layout I’m working with. The "Cost per kg" values are budgeted figures, and I'm comparing them to actuals from 2024 to identify any overages. I’d like the Cube View to visually flag these instances, so they stand out during reviews. Of course, the numbers in both columns are exemplary. In the rows I have different Entities.  Has anyone done something similar or can guide me on the best way to achieve this? Thanks so much in advance for your support!        

Hi all, I'm trying to create a Cube View with a single column that aggregates data for the past 12 months, rather than showing each month separately. Instead of this: MonthMay 2024Jun 2024Jul 2024Aug 2024Sep 2024Oct 2024Nov 2024Dec 2024Jan 2025Feb 2025Mar 2025Apr 2025Sales102030102030102030102030   I'd like this: Time PeriodLast 12 MonthsAggregate Sales240 To do this, I created an XFBR business rule that returns a time range like T#2024M5:T#2025M4 Here’s the relevant part of my XFBR: If args.FunctionName.XFEqualsIgnoreCase("Trailing12Months") Then Dim baseYear As Integer = args.NameValuePairs("year") Dim baseMonth As Integer = args.NameValuePairs("month") Dim endDate As New DateTime(baseYear, baseMonth, 1) Dim startDate As DateTime = endDate.AddMonths(-11) Dim startMember As String = String.Format("T#{0}M{1}", startDate.Year, startDate.Month) Dim endMember As String = String.Format("T#{0}M{1}", endDate.Year, endDate.Month) Return String.Format("{0}:{1}", startMember,

Hi All.Is there a way to exclude entities that do not have a Text1 from the following? E#XFMemberProperty(DimType=Entity, Member=|!PerformPnL_Entity!|, Property=Text1).Base or E#XFMemberProperty(DimType=Entity, Member=|!PerformPnL_Entity!|, Property=Text1) Since I have that in my data management and it shows an error if it does not find Text1, I need to exclude those that do not have Text1

Hi, I am building out a Trend report by year and by product, so I have Jan-Dec along the columns, and then 2022-2025 for each product type by row.  My problem is that because i'm viewing this in V#Periodic, when I run the report for March 2025, April's balance shows up as the negative YTD balance for 2025.  Is there any kind of conditional formatting I can use that says something like "If the intersection of month and year in the cube view (in this case, April 2025) is larger than the Time POV parameter selected when you run the report (March 2025), then change the text color to White so it doesn't show up?   

I am looking for different options to do Constant Currency. 

Having the option to disable the "Load" button and only show "Load and Process" on the WF step would help when we add a rule in the process step that needs to be run every time the user uploads a file. This would reduce the risk of a user clicking Load and not Process, which is important for our operational planning teams to avoid data being missed or incorrect because a calculation or rule was not completed.

Does anyone have a business rule that will send you an email notification when the SIC goes down?Or does anyone know if this is possible?

Is it possible to use Member Expansion functions like U1#[Top].Base.Where , U1#[Top].Base.Options within api.Data.GetDataBufferUsingFormula?I want to get data to the buffer from a Scenario / Scenario Type which is setup with a Summary UD1 dimension in the Cube Configuration.The data is loaded to this Scenario at Summary UD1 members.In the Spreadsheet I am able to pull  the data using below member filter function. U1#[XX].Base.Options(cube = AA , ScenarioType = Operational)However when I apply the same function in the api.Data.GetDataBufferUsingFormula , I am getting errors stating need a comma after Options.If this function cannot be used within Finance BR is there another way to get the data from base members of Summary UD1 dimension?Dimension    Summary UD1            Detail UD1 MembersSummary UD1      Top            CC001 Detail UD1      Top        &

Need some ideas on how to out bound files from OS shared folders to a network driver using UNC through SIC (we are upgrading to 8.2 from 7.3). We have SFTP through SIC works already, however, this specific process cannot be replaced by SFTP at this time. I have seen discussions and recommendation about inbounding through SIC only.

Hi, I get this error when saving data into a particular WP#Workflow S#Scenario T#Time member. Cannot execute step because the specified step classification doesn't exist for the workflow profile When I click OK to the error, when I refresh the data is saved. Any ideas what the problem is? What is a step classification? Thanks G

    Close

Hello OS Community.I'm working on a confirmation rule that is supposed to check for the presence of annotations when thresholds are defined. The intended behavior is:If thresholds are present, but no annotation/comment is provided, the rule should fail validation.However, the logic isn't working as expected. Even when no comment is given, the rule still passes and acts as if a comment is provided.Here’s what I need help with Ensuring that the rule correctly identifies missing comments and fails as intended. Identifying what might be wrong in my current logic it seems to incorrectly detect comments even when none exist.Any insights or examples of similar logic would be much appreciated! 

Hello,On version 8.5 (could be earlier, but didn't have a need to try) I am trying to create an embedded cube view that retains excel formatting. When I check mark the preserve excel format this works, BUT when I save the report, close it, and reopen it the cube view itself stays a light font vs black. Once I uncheck preserve excel format it reverts back to the expected black font cube view.....Is this a known issue or a way around it? 

Hello all,I've written a Member Filter Builder on A#IncomeStatement.Base.Where(AccountType Contains Revenue).  A second one for Expense too. I am now trying to sum those rows and cannot seem to get the math logic to render. Any advise out there - what am I missing or not considering? Columns are Entities, not row/column sharing, and the number of rows are extensive.I've tried the following and cannot seem to get it right:GetDataCell(CVR([TB_Rev])):Name(Total Revenue)GetDataCell(A#IncomeStatement.Base.Where(AccountType Contains Rev):NameThanks in advance for your help, 

Hi, In our application account dimension member formula field is freeze so unable to see the formula its under Vary By scenario Type and Time and don't see member formula in any of member formula from 1 to 9, so is there any way to track member formula of this account?

hi all, I just want to confirm the tool's approach: If I have a foreign entity (defined as EUR), can I post a journal entry directly to USD (Translated), and it won't be overwritten by the built-in currency translation? (in other words, it won't just overwrite translated with whatever is in local?) Or is there something else I have to do to accomplish a USD journal in a non-USD entity?

Hi, we have a custom member filter in a cube view (i.e. E#Root.CustomMemberList(BRName=X, MemberListName=Y)), and it seems to disable row suppression.In other words, the cube view brings back all filtered members in rows, regardless if there is data, even when the row suppression settings are set.Has anyone else experienced this and can confirm/deny? And if so, is there a way around it? We based architecture on CustomMemberList following the same rules as any other member filter.Jon  

  I have the following cube view in Oneplace and I would like to know if it is possible to create subgroups below the Main group.  For example I would like to create a subgroup of Income Statement report, Revenue reports etc.  They are currently in separate groups in the cube view set up but that does not seem to translate to Oneplace.  We are currently on 7.3.3 and moving to 8.5 in the next month.    

Hello, I've successfully set up an automatic upload using the Harvest Folder. However, I want to use the Skipline functionality within the file to reduce the import size. This works perfectly when I manually import the file into the specific Import Step. But when using the automatic upload via the Harvest Folder, the Skipline functionality doesn't seem to be applied. Does anyone have an idea for a possible workaround?

Hi guys,I need to create a pie chart on a report component (under dashboard), but this pie chart has the particularity that, instead of showing up the labels of the data presented in the chart itself, i need to show the Total Amount inside the pie. The achieve this, i wanted to add an XF label taking the total from the cube, but  when i set the label over the chart then i have the error "The control is overlapped". Do you have any workaround / solution to allow the controls, in particular the labels, overriding a chart?note: ok under preview that works, but at the end i need to use this report component in a docx file (with narrative reporting) - that's blocking me to use the report.Thanks a lot in advance,Regards,Florence

When we created our application years ago for a particular source our account mapping only needed the Source Account to map.  Now I have a need to do the account mapping based on a Location Source field that denotes a location for just two records exceptions.  Can I make a Composite Rule mapping that somehow includes the location from the Source file to create a composite rule for this exception or is the only solution to now include the source location field on my data source, and modify all the current mappings to have a wildcard for that field except my exceptions that need to be mapped to a different account.