Missing underscore in member names displayed via combo box
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 CommunityHybrid Scenario Issue: Copying Single Period Without Affecting Prior Months
Hello everyone, I’m encountering an issue with Hybrid Scenarios: I’m trying to copy data for a single period only. While I’ve successfully managed to copy Local data for that specific period by updating calc status, the results become inconsistent from Translated up to Top. To align the data from Translated through to Top in the target scenario, I currently need to run a Force Consolidate. However, doing so also brings in data from previous months, which is not desired. Has anyone faced a similar issue or found a way to restrict the consolidation to a single period without impacting prior periods? Thanks in advance,
OS 9.2 Form Templates Parameters
Hi All, I have a cube view with a set of parameters as a member list. I attach the CV to a form template and override the cube view parameters by using the 'cube view parameters' feature in the form template. As an administrator, I can see the filters I added in the drop-down list, but for the end-user, it is completely blank. (See photo). All dimensions displayed are set to everyone, including templates, cube views, and workspaces. What is causing the issue? In 9.2, the members do not appear in the member list.
Issue Referencing Parent Entity in an Stored Account Member formula
Hi, We have a few accounts that contain stored formulas. These accounts contain formulas that reference another Account and Parent entity and it stores the result at a Base Entity. Below formula is for an account that has a formula pass 4. We are storing the result in "BaseEntity" and calculate Account1 by looking at OPEX at a Parent Entity. Obviously, since it is referencing a Parent Entity we have to run our consolidations twice in order to get the result. Is there a way to sum up the Base entities of Parent1 and reference that value in a formula or is there a way to run a consolidation within the formula for just that Parent Entity? In other CPM/EPM products I've worked with in the past you can right rules where you run an aggregation on the Entity and then run your calculation. In OneStream I cannot seem to find a way to do this. If api.Pov.Entity.Name = "BaseEntity" Then api.Data.ClearCalculatedData("A#Account1",True,False,False,True) api.Data.Calculate("A#Account1 = A#OPEX:E#Parent1:C#USD",True) End If Any help or assistance would be appreciated. Thanks John
Same Scenario Across Two Cubes vs Separate Scenarios — Pros & Cons?
Hello everyone, I’m looking for feedback on the pros and cons of using a single Actual scenario across two cubes (e.g., Consolidation and FP&A) versus defining separate scenarios for each cube. For example: Option 1 (shared): Consolidation Cube : Actual (Scenario Type = Actual) FP&A Cube : Actual (Scenario Type = Actual) Option 2 (separate): Consolidation Cube : Actual (Scenario Type = Actual) FP&A Cube : Monthly (Scenario Type = Control) From your experience, how do these approaches compare in terms of data governance, maintenance, performance, flexibility for planning/reporting, and potential risks (e.g., unintended impacts between cubes)? Any best practices or lessons learned would be greatly appreciated. Thanks in advance!Error processing member. The item was not found. Member, -100.
I am running a cube view form in a workflow from OnePlace, i can able to execute other forms like Total Revenue, COGS, IC COGS, OPEX etc but not IC Revenue, Need help, if anybody come across this. Error processing member. The item was not found. Member, -100. Error Description: Unable to execute Business Rule 'CFO_NoInputRule'. Error processing member. The item was not found. Member, -100. User Interface Stack Trace: at OneStream.Client.Api.DataExplorerServiceReference.DataExplorerServiceClient.StartOpenCubeViewGridCompressed(SessionInfo si, Guid workspaceID, String cubeViewName, CubeViewUIModuleType uiType, Dictionary`2 customSubstVars, TriStateBool suppressRows, Int32 pageIndexForPreviousPage, CVGRowOrColUniqueIDStruct lastRowIDInPreviousPage, Int32 compressedRowIndex, List`1 overridenCubeViewMemberExpansions) at OneStream.Client.SharedUI.DataExplorerControl.InitializeGridAsync(TriStateBool suppressRows)Create dynamic members using api.ReadDynamicDimensionInfo
Hi, I'm trying to create dynamic members within a dimension using api.ReadDynamicDimensionInfo. I created a custom table within application database. When the service runs, it creates members under the root member even when I pass the "Parent" member's name. Also, the aggregation weight is being set to 0 even when I've passed numerical values. Table: Dimension Library: I want the members to be created under "All_Customers" Code: It works when I use - CreateAndAddrelationships but not with the api mentioned above. Am I doing something incorrect?
