omit a derivative rule, but only for a specific period
Hi, I’m currently working on a project where I need to omit a derivative rule, but only for a specific period. I'm looking for the most effective and clean way to achieve this without disrupting other rules or calculations that remain in effect. Does anyone have experience with this or suggestions on how best to approach it? I’d appreciate insights on both technical implementation and best practices to ensure future maintainability. Thank you,180Views0likes2CommentsNew connection requiring a date and scenario transformation rule
I cloned an existing connection that pulls the Scenario and Date from the workflow. The new connection is requiring me setup a New Scenario Transformation rule that is basically Budget --> Budget and time rule 2024M1 --> 2024M1. The connection I cloned doesn't require the additional rules and was pulling Actuals. All my Data Sources, Scenario, and Workflow settings seem the same. Any suggestions on what I am missing? I don't want to maintain the time rules, so that's why I'm trying to see what I'm doing wrong.Solved166Views0likes2CommentsHow to treat blank values for Source field and wanted to assign it to 'None' Target member
Hi Team, My validation step failed because the source mapping is missing for blank records. I attempted to add a mapping with (blank) for the source value and None for the target value, but it didn’t work. How should blank source values be handled in the mapping? Can you please help me with this if anyone face similar issue ? Thank youSolved214Views0likes2Commentsremove transformation profile member by an import
Dear coleagues, when I need to change transformation group within multiple transformation profiles I wanted to export XML file, do the change and then reupload it. Unfortunatelly it add new group but does not remove the old one. I guess the merge approach it to blame. Do you know a way how to do this excersise in more sophisticated way than running a clicking derby? Thanks for help!557Views0likes6CommentsRange transformation rule
Im being given an account consisting of 4 numbers, a - and 4 more numbers like:5150-0707. Im using range TR to map to the OS accounts, so for example5000~5050-0304 works fine, but if i put the~ after the- like this:5000-0001~0304 it doesnt work any more. is there any way to fix this and make it work?189Views0likes1CommentETL : Mapping entities/ transformation Rules
Hello OneStream community,I'm working on a data import process where our source file contains Entity codes with hyphens (e.g., "ENT-BER"), but in our OneStream application, these codes use underscores instead (e.g., "ENT_BER").I'm looking for an efficient way to automatically transform these Entity codes during the import process without having to create individual mappings for each entity. Where in the OneStream configuration should I add this transformation rule? In the Data Source settings, Transformation Rules, or somewhere else? Any guidance or examples would be greatly appreciated. Thank you in advance for your help!Solved340Views0likes2CommentsValidation Intersection Error
I am using a below code to display Intersection Error. The code works perfectly fine- except for one thing. The problem is when the error is - Invalid Member Name.Entity,2010 It only outputs- "Invalid Member Name" (may be because it gets period) Is there a way to update below code to also show Entity ,2010- instead of just 'Invalid Member Namr' ***************************************************************** Guid gWFid = si.WorkflowClusterPk.ProfileKey; int idScenario = si.WorkflowClusterPk.ScenarioKey; int idTime = si.WorkflowClusterPk.TimeKey; using (DbConnInfoApp dbConnApp = BRApi.Database.CreateApplicationDbConnInfo(si)) { string strSQL = "SELECT * FROM StageToFinanceValidationError WHERE WorkflowProfileKey=@wfk AND WorkflowScenarioKey=@wsk AND WorkflowTimeKey=@wtk"; List<DbParamInfo> lstParamInfo = new List<DbParamInfo> { new DbParamInfo("wfk", gWFid), new DbParamInfo("wsk", idScenario), new DbParamInfo("wtk", idTime) }; using (DataTable dtValErr = BRApi.Database.ExecuteSql(dbConnApp, strSQL, lstParamInfo, false)) { StringBuilder sb_ValErrorsReport = new StringBuilder(); foreach (DataRow drVal in dtValErr.Rows) { string strValMsg = drVal["ValidationmessagesXml"].ToString(); DataCellValidationMsgList validationMsgList = (DataCellValidationMsgList)XmlObject.ReadXmlString(si, typeof(DataCellValidationMsgList), strValMsg, true); foreach (DataCellValidationMsg err in validationMsgList.Messages) { sb_ValErrorsReport.AppendLine(string.Format(err.ErrorMsg, err.StringParams)); } } ******************************************************************************************228Views0likes1Comment