OneStream Platform Forums

Just looking for an Application database data model,  to help figure out how tables join together. Has anyone come across such a document, or created one that wouldn't mind sharing?.   I have never found one in the OS documentation    

  Hi Is it possible to change the blue, green and red color? Is it possible to add a value     

Stop Fighting Your Equity Translation — Let HSR Do the Heavy LiftingA 5-minute read for anyone who's ever stared at a CTA movement and whispered: “Where did that come from?”_____________________________________________________________________________The consolidation problem we all knowIt’s day 4 of close.Consolidation runs clean. FX looks fine. Then someone opens the equity rollforward.“Why is acquired share capital moving again?”The entity was acquired years ago at a historical acquisition rate, but the system is retranslating equity at current closing FX every month.CTA absorbs the movement.Auditors ask questions.Finance posts manual journals.Everyone loses time.This is the classic Historical Spot Rate (HSR) challenge.The design principleThe goal was simple:Freeze selected equity accounts at acquisition FX rates while keeping the standard OneStream Software translation engine intact.No new cube.No custom dimensions.No complicated override framework.Just:metadata tagging,controlled F

Hello!  We have a missing underscore in a combo box and I'm not exactly sure why... Here's what shows:  Here's how entities are set up:  Anyone see this before? Seems related to this one which says it's resolved in 7.1.3 but I'm not seeing that: Underscore in member name not displaying in multiselect listbox | OneStream Community

While building the hierarchy using codes, In the Entity Dimension hierarchy "EntityH1", I have a base member as "MyBase". Below code is successfully creating a new child member as "T2" under Parent "MyBase".I am able to set the Text1 property. Can please some one help to suggest how to set Currency property to select a particular currency (Let's take "SGD")'Set the Dimension Type as EntityDim objMemberPk As New MemberPk(DimType.Entity.Id, DimConstants.Unknown)'Update Dim Name accordinglyDim objDim As OneStream.Shared.Wcf.Dim = BRApi.Finance.Dim.GetDim(si, "EntityH1")'Create New MemberDim objMember As New Member(objMemberPk, "T2", "T2 Entities", objDim.DimPk.DimId)'Create VaryingMemberProperties objectDim objProperties As New VaryingMemberProperties(objMemberPk.DimTypeId, objMemberPk.MemberId, DimConstants.Unknown)'Create new member info object for new memberDim objMemberInfo As New MemberInfo(objMember, objProperties, Nothing, objDim, DimConstants.Unknown)'Modify some member properties

I have created a quick view template file, but each time I launch it, the font gets changed to a light gray. This obviously makes it difficult to see and I need to reformat it afterwards. Here is a sample: My QV has "preserve excel formatting" enabled, so I am uncertain what is causing a formatting override. I have tried different primary styles, but it does not stop the format from overriding after closing and reloading the spreadsheet. Here are my options: Has anyone else experienced the same issue or have any insight into how I may fix it?

Hi All,  I have a process that exports a dashboard and all of its components to XML.  It then reads through the XML and creates new objects.  The process works when I import the XML by hand.  I was wondering if there is a way to have the code: 1) delete objects if they exist 2) import the XML to create the new objects.    Thank you,Scott

Hello, I'm trying to pull in the certify comment section when a user clicks on the "Set Certification Status" button. We currently are using the Workflow Event Helper to send the email when the certification is set to In-Process or Certified. Dim oEntityList As List(Of WorkflowProfileEntityInfo) = BRApi.Workflow.Metadata.GetProfileEntities(si, oWorkflowInfo.WfUnitPk.ProfileKey) emailTo = BRApi.Finance.Entity.Text(si, oEntityList(0).EntityMemberID, 8, False, False) emailBody = $"[{si.AppName}] - Status Of {sWFProfileName} WF | {sWFScenario} Scenario For {sMonth} {iYear} was changed To {If(oWorkflowInfo.IsCertified, "Certified", "InProcess")} By {si.UserName}" emailSubject = $"FM Task: {sWFProfileName} Certification Status has been changed to {If(oWorkflowInfo.IsCertified, "Certified", "InProcess")}" FBR_ConnectorLibrary.emailSend(si, emailTo, emailBody, emailSubject, emailBody) Thanks, Will

I'm trying to call a helper BR that I wrote to pull in two variables to denote our environment, but I'm getting an error message saying the extender business rule.MainClass is undefined. Background: Our GL has three environments, Dev, Prj (test) and PRD.  As we promoted projects up in OneStream, I have to edit the BRs to reference the different environments.  It's a pain when it comes to the SQL because the environment is part of the tableName.fieldName. Goal: to have one helper BR that has the environment variables in it and all other BRs reference this rule so I no longer need to edit them from environment to environment.  The helper rule in DEV would reference the DEV tables, the helper in PRD would reference the production tables, etc. 'test code to pull in environment variables from a Helper 03-05-2026 'Define reference to business rule Dim JDE_EnvironmentHelper As New OneStream.BusinessRule.Extender.JDE_EnvironmentHelper.MainClass '<

Hello,  When we refresh a lower environment from our production environment (app copy), the target environment's System Parameters/Secrets are refreshed from the production System Parameters/Secrets. These secrets contain connection strings to another platform and are environment specific. They must remain static. (Fortunately, I export them before a refresh and then re-import them after.)   There must be a better way! Does anyone else have this issue? If so, is exporting/importing the System Parameters the only way to keep System Parameters with their correct environments? Thanks!   

I'm building a cube view column that shows combined annotations from descendants. I'm calling an Finance Cell Service BR from inside GetDataCell so I can pass dashboard params needed for the logic. GetDataCell(T#|CVTime|:BR#[BRName=..., FunctionName=CombinedComment, Flux_ID = {fluxID}]:U8#{ud8}):Name({ud8} Combined). I need to the UD8 POV member because that distinguishes what type of comment it is (CMvsPM, CQvsPQ, CMvsPYM, Ect...). The BR returns a String, but GetDataCell expects a numeric amount so the text doesn't render in the cell. Pointing the column at V#Annotation doesn't help either.Has anyone gotten BR-returned text to display in a GetDataCell with full POV/param context? Thanks,Ben

Hi OneStream,I am utilizing the XFBR String Service to add my time filter in my data management job. Before moving to assemblies, I have tested the rule via Business Rule XFBR, and it works. However, when using the XFBR string service, I am having difficulty making it work, as the string I am adding to the time filter is most likely incorrect. I have tried the different approaches based on documentation, but to no avail.Can you please advise how I can fix the issue? 

We're moving most of the Business Rules to Workspaces Assemblies under PV 8.4.- We have several Extensibility Rules that are run by multiple Data Management (DM) Jobs like you.- Hence, we included separate DM Step Services (DMSS) in the same Service Factory (SF).- The result of this SF setup was chaos.- We saw that launching one DM Job by a given DMSS in the SF will also launch other DM Jobs by their DMSS in the SF. We couldn't find enough practical advice on the SF/DMSS setups in the Design Guide to overcome this chaos.Pls share how to set up Data Management Step Services in a Service Factory to launch one Extensibility Rule/DM Job at a time. TY.

 

Hi, I have encountered an error when running reset scenario that says "Error processing data. The item was not found. Entity, Parent, -1."I understand that the possible cause of this issue is that there might be orphaned entity members. However, in the application I am working on there are no orphaned members. Could there be any other possible cause that I could look into? There is not much detail in the logs that I can find. Any suggestion/recommendation is appreciated :) Thanks!  

Hi all,I’m currently upgrading instances of Genesis-created workspaces and ran into an issue.The workspace named "Genesis" was upgraded successfully. However, the ones with different names are failing and returning the error below.For example, one of the affected workspaces is named "Landing Page." I’m not sure if the naming is related to the issue, but it’s the main difference I’ve noticed so far.Has anyone encountered something similar or knows how to resolve this? I’d really appreciate any guidance. 

We have recently received feedback from several entities regarding outdated account members that still exist within our Transformation Rules. Before making any changes, I wanted to gather input on best practices for handling these scenarios. Specifically, I’m unsure whether it is appropriate to remove or delete these members, or if they should be retained and continue to be mapped for historical reporting purposes. If anyone has guidance or experience with managing outdated members in Transformation Rules, your insight would be greatly appreciated.

Hi, we would like to know if it is possible to load multiple columns of amounts and annotations as a matrix load ( we have 3 date columns and 3 columns for amounts and it would be an account matrix as each column would go to a different account).We are able to load a matrix load where one column is an annotation and there are multiple amount columns, but when there are multiple annotation and amount columns, we have not been successful.See screenshot.  The date columns would be loaded as annotations, the Begbal, Pmt, Interest columns to amount. Each column would be going to a different account. Please advise, thank you   

I'm trying to write a BR that returns data using HTTPClient. I've tested out the api.open-meteo.com example and can successfully pull data from this site. The site that I am trying to query requires a site certificate for authentication and I'm not sure how to tell my BR to use the site certificate that is already installed on the SIC server. On the SIC server, I can manually run the query to the source site via a web browser which prompts me to select the appropriate certificate.  Has anyone been able to include a site certificate to a HTTPClient request? Thanks, Cosimo

I’m experiencing an issue where the email template preview sends without any problem, but when I execute an import with DISM itself (actual), the email is not delivered. There are no visible errors or warnings with the data import itself.Has anyone encountered this issue before? What configurations, permissions, sender settings, or campaign requirements should be checked when preview works but live sending fails?

I have some users who like to view a report in actual currency and others in 000's.  Is there a way a user can change the number format of each report?

Is there any known way to prevent a user from utilizing XFSet in Excel?

I'm receiving the following error when trying to add additional Register Definitions.  During the build, I've added new Register fields as requirements evolve but now am facing this error when running the Update button.  Has anyone run into this issue and resolved it?   Error executing Workspace Assembly Service class 'Workspace.PLNB1.CustomEventHandler_PLN.WsAssemblyFactory'.Invalid column name 'PayGroup'. Invalid column name 'Location'. Invalid column name 'EmpStatus'. (SQL Error Number -2146232060, 207, 207, 207). User Interface Stack Trace: at OneStream.Client.Api.DashboardsAjaxServiceReference.DashboardsAjaxServiceClient.StartExecuteSelectionChangedServerTaskCompressed(SessionInfo si, Boolean isSystemLevel, Guid primaryDashboardID, Guid embeddedDashboardID, Guid componentID, PageInstanceInfo pageInstanceInfo, XFSelectionChangedServerTaskInfo serverTaskInfo) at OneStream.Client.SharedUI.DashboardWcfHelper.ExecuteSelectionChangedServerTaskAsync(SessionInfo

In consolidation system in the month after close example if we close April , May should show reversal of April. Please see below screen shots of how system is should show up and how it is showing. We tried clearing base data through data management. Any ideas would be helpful. Normally  However the system is doing   

Is there an ability to calculate HC expenses that account for when in the month an employee starts and prorate accordingly? As an example, if the employee starts on the 15th then their monthly salary would be Salary / 12 * (15/30). The syntax available in the blocks don't clearly identify if this can be done.