OneStream Platform Forums

HelloI have created a "level 2" transformation rules on ICP dim in order to force certain accounts to be filled in specific fixed IC elements.Do I have:     -  "level 1" with One-To-One Mappings.     -  "level 2" with a composite filtering on the account A#[140305] "Level 2 Composite" is completely ignoredWhere am I making the mistake?Thanks in advance for the helpMarcello 

Dear Community, We have a requirement to calculate the sums of two rows total for every month we run. We have a time parameter that is helping us to select the desired month. We used GetDataCell formula to calculate it for the particular month.for an instance if Jan period is selected - GetDataCell((Divide((CVR(Row1) + CVR(Row2)), (1)))*12):Name(Total)  will be the formula to calculate the sum total for Jan. If Feb period is selected in the parameter - GetDataCell((Divide((CVR(Row1) + CVR(Row2)), (2)))*12):Name(Total) this should be the formula. The bolded part should be dynamic upon selecting the months selected in the parameter. If it's June the bolded value should be 6, If it's July it will be 7, and it goes on. When we are switching the periods, we notice the totals are not matching and the values remain constant. We have a requirement to make the totals dynamic when selecting the periods in the parameter. How can we achieve this? Are we need to w

How can we  pass the selected row key using a bound parameter? I am trying to capture the selected row to a BR for further processing. I also have a supplied parameter to collect the bound parameter but it does not seem to work as a delimited list. The active selected items will be passed to the defined Bound Parameterfield as a comma delimited list. The Bound Parameter format will be as: item1, Item2, Item3. Please advise.Thank You,Indu 

Hi All,We are using a spreadsheet component to capture some drivers from end users in our application, how do we customize the ribbon of the spreadsheet component to show only OneStream option in the ribbon?If I do right click, "Customize ribbon", it lets me display only OneStream in the ribbon , but the customization is lost on refreshing the page. Any guidance on how to retain this customization would be helpful.   

Hi,I have created some new balance sheet accounts relating to Right Of Use Assets, I have copied the structural dimensions from my existing fixed assets, so that every member property field matches. I use a generic cubeview for recording opening balance adjustments, when I key into all my other balance sheet accounts, then the derived value flows through the remainder of the year. This happens regardless of which is the first month I key into. However, for my new ROU accounts, it does not do it. The values just show as 0 and I have to key in the actual value manually each month thereafter. Here is some sample data to show what is/is not happening. Also, it does not matter which month is the first month.So what have I missed in creating these ROU account codes in the member properties ? They use the same flow constraint as my other fixed assets, so it's not that.Where else do I need to look ?CheersMark

This may be a long shot but I was wondering if there was any kind of functionality to have a message appear if you leave a dashboard page/try to close out of it. The use case is that I have a dashboard that has a button that is hitting when a conference call happens and it updates security groups so certain users can't make updates during the call. I have another button the user SHOULD hit when the call is done and this will put the security back to what it was originally.  If the user of the dashboard forgets to hit that other button at the end of the call then the security never changes back. Was hoping to give a pop up message or something that forces the user to hit that end call button so the security goes back to what it was.

I'm getting the message "'Function GetLiteralParameterValue(si As SessionInfo, isSystemLevel As Boolean, parameterName As String) As String' is obsolete: 'This is a temporary function used by Marketplace Solutions for backwards compatibility with old XF versions. Please change your code to use supported functionality.'."   Anyone know what object & method should I be using instead?     strSomeString = BRApi.Dashboards.Parameters.GetLiteralParameterValue(si,Nothing,"pm_SomeParameter")      

Is it possible to update the Application Security roles with in an extender Business rule? I want to be able to update the Modifydata role with the push of a button.

Hi AllI am updating the Admin Consolidations Dashboard (ADM) so that only some users can execute a Force Consolidate. I can hide the radio button group if the user does not have access but I am struggling to update the radio button group (Consolidate/Force Consolidate) so that the correct option is selected. The list of values for the radio button is controlled by a parameter (pm_ConsolType_ADM). In the LoadDashboard event I have updated this parameter using SetLiteralParameterValue (using v6.8). I am assuming that this is how the radio button selection is controlled as I can't find anywhere else where it can be set. If I click on the 'Reset parameter selections' it works.I have tried unsuccessfully to Redraw the dashboard like this:Dim selectionChangedTaskResult As XFSelectionChangedTaskResult = New XFSelectionChangedTaskResult()selectionChangedTaskResult.ModifiedSelectionChangedUIActionInfo.DashboardsToRedraw = "2_1_AutomationTasks_ADM"Any help you can give me is much appreciate

Hi Team,I am using Excel Column width option in cubeviews to reduce the width of Blank Columns in Excel but it's not working,Please provide me any suggestions

When I use the Pre-Aggregated Member settings, it is copying the data twice.  I've tried multiple settings and multiple scenarios.For example, I have tried just O#Top=O#Forms.  After I run the consolidation, there is data in both O#Import and O#Forms, doubled. It also happens with multiple Dimensions.  I've tried O#Top=O#Forms,U5#Top=U5#PlanningLoad and the data is doubled in both Dimensions 

I would like to create a derivative transformation rule that will add _Qty to the end of the Account and pull the ActualQuantity field from the data source as the Amount.My DataSource has a field for ActualQuantity.I have a Derivative Rule that looks like this:The complex expression on the derivative rule is:this returns 0 instead of the amount in the ActualQuantity field. Thank you in advance.

Hi,I am experiencing a strange behavior with a piece of code in the drill back of a connector rule.I have the following piece of code: If StageTableFields.StageSourceData.DimUD1.XFEqualsIgnoreCase("Zero") Then whereClause.Append("And (Department IS NULL) ") 'Else ' whereClause.Append("And (Department = '" & SqlStringHelper.EscapeSqlString(sourceValues.Item(StageTableFields.StageSourceData.DimUD1).ToString) & "') ") End If  When the ELSE condition is excluded as above the first IF works:However, with the ELSE condition included (see code below) the retrieve from the Zero values does not work anymore: If StageTableFields.StageSourceData.DimUD1.XFEqualsIgnoreCase("Zero") Then whereClause.Append("And (Department IS NULL) ") Else whereClause.Append("And (Department = '" & SqlStringHelper.EscapeSqlString(sourceValues.Item(StageTableFields.StageSourceData.DimUD1).ToString) & "') ") End If Any idea why this is happening? Thank you

Hello! Can't find the location where I can download all the templates below. Could you please point me in the right direction? 

Hello OneStream Admin Certified experts, I would like to perform the certification on OCA and need your experience on how to prepare and what are the documents to refer and minimum duration to prepare on self training. Thanks Sreenu

Hi,Copy pasting data from excel into CV forms generally work, but the exception seems to be for date values (CV Cell Type - Date). Does anyone have experience with this and know if it's possible?  

Hi, I'm trying to get the amount of an objDataCellInfoUsingMemberScript but I couldn't get the data, I'm trying this:objDataCellInfoUsingMemberScript = BRApi.Finance.Data.GetDataCellUsingMemberScript(si,"KemetFinRptg", "E#LEGAL_Y:C#Local:S#Actual_YAGEO_Fx:T#2022M1:V#MTD:A#702006:F#Top:O#Top:I #Top:UD1#0021:U2#Top:U3#Top:U4#Top:U5#Top:U6#None:U7#None:U8#None" )'String to convertDim stringToConvert As String = objDataCellInfoUsingMemberScript.DataCellEx '<-- Update string to be converted'Convert to double. Set to 0 if string if not able to be convertedDim dblValue As Double = stringToConvert.XFConvertToDouble(0)  

Hi I always seem to get an "Object reference not set to an instance of an object" in the error log when I execute data loads that use connector rules.The full error message is: ---------------------------------------- Exception Type: Unknown Message: Object reference not set to an instance of an object. Stack Trace: at OneStream.Shared.Engine.XFTelemetryHelper.GetTaskActivityArgsInfo(SessionInfo si, TaskActivityArgs taskActivityArgs) in C:\agent\_work\411\s\Source\Shared\Engine\SharedEngineBase\UserActivity\XFTelemetryHelper.cs:line 55 The strange thing is that the data load is always successful... Does anyone know how to get rid of this error message?Thanks,Mark  

Hi All,I wish to change the property 'Show Manipulation button' of my SQL table editor to hide manipulation buttons if the workflow selected is a parent but show if the workflow selected is a base. Is this possible?Regards,Mark

Hi OS Community,We have custom business rule to manage Data cell access security (Slice security). We have created new row category(DHRStat_Fcst)select group and it should have Read access only to PLP register but issue is it also have write access to add or make changes to register (screenshot below highlight in yellow) which we are trying to retrict through BR. Custom BR code: Line 253-259 is it is for data cell read access for PLP registerLine 263- 264 is the code for write access for PLP register and we try to restrict by category, but it is still not working. If Not itemAccess.Category = "DHRStat_Fcst" AndAlso itemAccess.MemberFilters.Scenario.IndexOf(wfscenarioname) > -1 AndAlso brapi.Security.Authorization.IsUserInGroup(si, groupID) ThendashSet = "3b2b1w_RegisterMaint_PLP"End If Data access:I need help with the BR code change to restrict the write access to the particular Data cell category .Let me know if you need any more details.Appreciate your help!!

Hi All - I am trying to create a View using a Extender BR and It is compainling without any issue but when I try to execute it am getting the below error. Any help would be appreciated.   Dim vSQL As New Text.StringBuilder() vSQL.AppendLine("CREATE View dbo.v_stageData AS SELECT WFP.ProfileName As WorkFLowProfileName, S.Sn AS SrcScenario, T.SnT AS TgtScenario, S.Tm AS SrcTime, T.TmT AS TgtTime, S.Et AS SrcEntity, T.EtT AS TgtEntity, S.Ac AS SrcAccount, T.AcT AS TgtAccount, S.Fw AS SrcFlow, T.FwT AS TgtFlow, S.Og AS SrcOrgin, T.OgT AS TgtOrgin, S.Cn AS SrcConsol, T.CnT AS TgtConsol, S.Ic AS SrcICP, T.IcT AS TgtICP, S.U1 AS SrcU1, T.U1T AS TgtU1, S.U2 AS SrcU2, T.U2T AS TgtU2, S.U3 AS SrcU3, T.U3T AS TgtU3, CAST(S.Am AS DECIMAL(18,2)) AS Amount FROM StageSourceData S INNER JOIN StageTargetData T ON S.Wfk=T.Wfk AND S.WtK = T.WtK AND S.Ri = T.Ri INNER JOIN WorkflowProfileHierarchy WFP ON WFP.ProfileKey = S.Wfk WHERE T.SnT = 'Actual' AND T.TmT = '2023M1' AND WFP.ProfileN

I have UD8 DynamicCalc members that calculate various Growth %s.  These work as expected when the Account dimension member referenced in the formula has a normal Account Type (e.g., Revenue or Expense).  It doesn't work when the Account Dimension member's Account Type is a DynamicCalc.Any tips on how to solve for this?  We can workaround this with some math in Cube Views, but would love to have a workaround for XFGetCell and Quick Views.

Hello, I've deleted several on prem databases from both SSMS and the Database Configuration Utility, however, when I access System > Tools > Environment the deleted databases are still listed under OneStream Database Server with a message "((Database Not Found #))".  There doesn't appear to be a way to remove these via the front end. Is there any other way to remove these?

Hi, I am currently working on creating a ParamHelper business rule to be used in a CubeView. The goal is to have the S#scenario driven by the time dimension parameter selected by the user, rather than by the workflow time. For example, if T# contains M1, the scenario that should be returned is S#Projection. I would appreciate any pointers or guidance. Thanks in advance for your help!

All Scenarios belonging to the same Scenario Type must have the same Formula assigned Question Credit: Janice Kirkbride Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in two weeks. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases