OneStream Platform Forums

I have a Cube View with three Account dimension columns - Net_Rev, Std_Cost, and a CVC calculated division column to calculate Std_Margin (Std_Cost/Net_Rev). Rows are a UD dimension representing the Product.  In my Dashboard, I have a Cube View MD Data Adapter using this Cube View as the data. When I add a BI Viewer Pivot Grid, I want to display the same three columns - Net_Rev, Std_Cost, and the calculated column. I see CalcScript in the Pivot Grid's Data Source dimensions. How do I use it in the Pivot Grid to display the calculation that the Cube View was doing for that third column?I thought I might reference it in the Value filter along with the two Accounts, but it doesn't appear as a column in the Pivot Grid. 

Hi Community, I try to save a simple data buffer within a Custom Calculate and receive a cryptic error message. Dim sourceDataBuffer1 As New DataBuffer sourceDataBuffer1 = api.Data.GetDataBufferUsingFormula("FilterMembers(C#Local,UD8#None)") sourceDataBuffer1.LogDataBuffer(api,"sourceDataBuffer1",100) Dim resultDataBuffer1 As DataBuffer = New DataBuffer() For Each cell As DataBufferCell In sourceDataBuffer1.DataBufferCells.Values Dim sCell As New DataBufferCell(cell) api.LogMessage(sCell.DataBufferCellPk.GetMemberScript(api)) resultDataBuffer1.SetCell(api.SI, sCell, True) Exit For Next resultDataBuffer1.LogDataBuffer(api,"resultDataBuffer1",100) api.Data.SetDataBuffer(resultDataBuffer1, api.Data.GetExpressionDestinationInfo(String.Empty)) When I start the Custom Calculate from data management, I select a base entity and C#Local, scenario and time. The code will write a log with an usual POV of the cell without common members (line 7) and also log the restultdatabuffer1 with 1 cell

Hello,  I setup a filter on a workflow profile calculation to run a data management job as long as the no calculate is the selected option.  We have a Data Quality Event Handler Business rule to run this; however when I click on process cube, it's running the job twice at the same time.  This is the example of what it's doing when I say it's running twice:     Here it the code from the event handler: Namespace OneStream.BusinessRule.DataQualityEventHandler.DataQualityEventHandler Public Class MainClass '------------------------------------------------------------------------------------------------------------ 'Reference Code: DataQualityEventHandler ' 'Description: Event handler method that provides an opertunity to supplement a normal data quality ' action with your own custom functionality. ' (Example: email after ProcessCube or publish report to sharepoint after failed Confirmation). ' 'Usage: Executes when a Data Quality a

I am trying to get a dashboard to have a particular scrolling behavior that I am not sure how to do if it is even possible.  A simple example of the ideal is below.  In this ideal dashboard the dashboard will scroll horizontally only.  The inner dashboard will individually scroll vertically.  I can not seem to get the outer dashboard to only scroll horizontally, and when it does that outer horizontal scroll turns off it appears the inner vertical scrolls.  I think I am asking for too much but was hoping to get some confirmation.  Thanks.  

Hello everyone, I am experiencing an issue with a dynamic calculation rule in OneStream for a user-defined dimension (UD1) grouping entities. The rule works correctly for all Consolidation dimensions except for "Translated," where the data is not calculated or displayed at the UD1 level, even though the base entities have values for that member. Context: I have a dynamic calculation rule that sums the values of base entities grouped under a UD1. The rule’s logic is the following: Dim entity As String = api.Pov.Entity.Name Dim text5 As String = api.Entity.Text(5) Dim ud1 As String = api.Pov.UD1.Name Dim ud1Man As String = ud1.Substring(1,3) Dim parent As String = "P" & ud1Man Dim result As Decimal = 0.00 'Filter the entities by Text5 Dim entityPk As DimPk = api.Dimensions.GetDim("Entities").DimPk Dim entityList As List(Of MemberInfo) = api.Members.GetMembersUsingFilter(entityPk, "E#PL00.Base.Where(Text5 Contains '" & ud1 &"')", Nothing) 'If we deploy the entities with an

Hi Everyone,We recently received a request from the client to set up a default value in the combo box for the cube view. The cells are set with type Annotations and has a dropdown of options to be selected. The client wants to default the dropdown as PctBudget until and unless it is changed.Is there a configurable setting that can be used to achieve that? I used the default value/members under parameters but it didn't help the cause.Thanks in advance!PragyanshuJackLacavaHenning 

cHi All, good day.   I'm using a database connection and it's working good: Dim dt As DataTable = Nothing Dim dbConnApp As DbConnInfo = BRApi.Database.CreateDbConnInfo(_si, Dblocation.External, "OneStream BI Blend")Dim stringSQL As String= "SELECT Entity,UD1_01,UD1_02,UD1_03,UD1_04,UD1_05,UD1_06,UD1_07,UD1_08,UD1_09,UD1_10,UD1_11,UD1_12,UD1_13,UD1_14,UD1_15 from XFC_UD1sbyEnt where Entity = " & "'" & api.Pov.Entity.Name & "' ; "dt  = BRapi.Database.ExecuteSql(dbConnApp, stringSQL.ToString, False) but in the error message log have a lot of messages that I need to close the connection Summary: Error in DbConnInfo.~DbConnInfo(). DbConnInfo should be used in a 'using' statement or Close() should be called explicitly.   does someone know how should be the command for close the connection?   Thanks in advance and best Regards. Mario Guerrero

When loading data through batch file, does transformation event handler invoked the same way as running through manual workflow steps? Also, how can I execute Workflow (import->validate->load) through batch?

Hi, I wanted to check if there are any ways where we can set the members for each dimensions in the quick view by default as per our need so that the user doesnot have to update eachmember everytime while creating new quick view. Currently it is pointing to None for UDs, can we set any specific member to default?

Hi All, I need to access parameter A which is present outside default workspace in my cube view. |!A!| this doesnot work as it only pulls the parameters within default workspace.  

Hi all,  I'm encountering an error with one user who is attempting to export a report to Excel. The download process is functioning correctly, and the file is being saved in the OnStream temporary folder. However, the issue arises as OneStream is unable to open the file automatically. It appears to be an issue related to permissions on the user's laptop. Could not find a way to fix it, any ideas? Thanks.  

Hi all,  I'm currently facing a challenge and do not seem to be able to get this to work. I have a CV displaying (amongst other things) a Dynamic Calc-Account (in Column) across Entities (in Rows), where entities have various currency. I want to be able to display the currency in the cell (with setting on CV cell format (ShowCurrency = True) I tried in essence the following in the business rule that calculates the value: Dim currencyID As Integer = api.Pov.Cons.MemberId Dim value As Decimal = 120.10 Dim result As DataCell = New DataCell(New DataCellPk(), value, New DataCellStatus(DataCellExistenceType.IsDerivedData, DataCellStorageType.Calculation)) Dim resultEx As New DataCellEx(result, "", currencyID, AccountTypeId.Asset) Return resultEx But that is not working unfortunately. Does anyone have an idea on how to get this working? Thanks Markus

I need to update the security on a scenario using a dashboard button, is this possible through a dashboard extender rule? Essentially a meeting will take place and certain scenarios will need to be locked down so no one can make changes besides the appropriate security group on the call. I will then need to change it back to the original security settings with a separate button once the meeting is over

Hi Team, The user is unable to download the OneStream Application in Edge and getting the below error.   The issue is coming from after Windows 11 upgrade, and it was working fine in Windows 10. We have tried with the solutions which all are the options available in below KB articles. KB0012987 : OneStream Troubleshooting Click Once KB0011265 : Error Starting Click Once Windows Application "Application cannot be started" Regards, Praveen

I know I can have a different scenario where I can combine actuals and forecast each month with data management job and I can use AllPriorYInearInclusive for Actual columns and AllNextInYearInclusive for Forecast to do this when i want just months. But I want to also have quarters summing 3 months potentially actuals and forecast together if date selected is in middle of quarter. And YTD columns summing actuals and forecast.   Below is example of what i want to achieve. Is there CubeView Extender i can build to make this happen. For Quarter and YTD columns i can just use getdatacell(CVR(Col1)+CVR(Col3)+CVR(Col5)... etc. but i would like to somehow switch actuals to forecast for all future months of WFTime, TimePOV or Parameter selection.

Hi,I want to build an input form for project planning where the projects are defined in UD1 dimension, but for the rest of the columns (Start date, End Date, and Contact type) there is no dimension defined. How can i build a input form via cube view if there is no dimension defined in Onestream. But Clinet wants to input the columns data (Start date, End Date and Contact type), in the system via form. 

Hello OneStream Community,I'm working on how to implement a REST API in OS, but i'm not sure to understand all the steps, i've already read the documentation and i've found it very hard to understand, can anyone please explain how can we implement it in OS what are the steps to follow, i started by downloading and installing POSTMAN for the tests but i don't know what should do i do after, please any help will be much appreciated. I'm also woundering if there any data management that should be used for this Thanks and merry christmas.

I’m trying to create a text box component that can be added to a BI Viewer and easily updated by end users directly in OnePlace. The goal is for the users to be able to edit the text without having to modify anything in the underlying application or configuration. Here’s what I’ve attempted so far: Created a string parameter intended to store the text. Tried adding a dashboard parameter control (such as a text box) linked to that parameter. Embedded it into the BI Viewer view. However, this approach didn’t yield the desired result. The text either doesn’t update as expected, or isn’t visible to the user in the way I intended. Has anyone successfully implemented a user-editable text box that can be directly manipulated by end users in OnePlace and reflected in a BI Viewer component? Any guidance, best practices, or examples would be greatly appreciated! Thanks in advance for your help.

Hello OneStream experts: Thank you for the helps in the past. I found this forum is very helpful.  I feel the MultiplyUnbalanced function is very nice and wonder if it can take more than 2 components to multiply. They give an  example: If I want to do A#UnbalancedMultiplication=A#60000 x A#41000:U2#Parts   I can use the following: api.Data.Calculate("A#UnbalancedMultiplication = MultiplyUnbalanced(A#60000, A#41000:U2#Parts, U2#Parts)") But, if I want to do multiply three components A#UnbalancedMultiplication=A#60000 x A#41000:U2#Parts x A#51000:U2#Material how to use the MultiplyUnbalanced function? Thank you in advance for any answers.

I am looking to create a transformation rule for Accounts to map to a destination if the Department on the record is a child of a specific parent in the OS department dimension.ACCT600 DEPT101  --> ACT_EXP600_100ACTT600 DEPT321  --> ACT_EXP600_100Where departments 101 and 321 are descendants of Dept_TotRD

Hi all Are there any key short cuts in the business rules editor? Cheers

Hi AllDoes anyone know how to add a carriage return in Annotation text (if it's possible)? We have a Cube View with an annotation member that displays data. Currently the annotation text can take up most of the screen on some rows and it would be really useful to be able to enter a carriage return. I have tried Environment.NewLine, vbCrLf, \r\n, <br>

I would like to apply a member filter on a scenario, which will return a list of a scenarios based on it's properties like Name, Description, WorkflowTime, WorkflowStartTime, and WorkflowEndTime...i.e.  WorkflowTime = |someYear| or WorkflowStartTime = |someYear| or WorkflowEndTime = |someYear|I can do this S#Scenario.where(Name contains paramScenario) I can do this S#Scenario.where(Description contains paramDescription)I cannot do this S#Scenario.where(WorkflowTime = 2025)I cannot do this S#Scenario.where(WorkflowStartTime = 2025)I cannot do this S#Scenario.where(WorkflowEndTime = 2025)What am I missing?

Hi. Is there a way to automatically hide the Navigation Pane when the OS application is opened? I am using  Administrators Solutions Tools to set a homepage and I would like that homepage to open full screen (no Navigation Pane).  Thanks! Samuel

Hi Everyone. What I want to achieve is to obtain the amount of three times in a single getdatacell. What I have is the following: Dim first As Decimal = api.Data.GetDataCell("S#[" & strScenario & "]:" & timesTest(0) & ":E#30801_30800:A#FINVOLUME:F#None:O#BeforeAdj:U1#D0000:U2#P0100:U3#LOCAL_DATA:U4#PJ00000").CellAmount The issue is that I need to use three different times, but I don’t want to create three variables to sum those values, and I also don’t want to do something like the following: 'Example Dim tot as Decimal = api.Data.GetDataCell("#Time1" + "#Time2" + "#Time3") So, I wanted to see if there is a way to put all the times together in one so that the sum is done internally, or if it can only be done as shown above. I hope you can explain the best method to achieve this.