Recent Discussions
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!
Write Data to Dynamic Dimensions
I've been going through some training material on DCS for a use case that requires frequent changes in a dimension (UD3 - SKU). Because of this, I'm considering dynamic dimensions where the SKU can be written and generated via code. Unfortunately, I haven't found anything that supports writing data from a cube view. I've only found material that says the "Dynamic Cube" needs to have the share and edit feature turned on. Question - Is it even possible to create a cube, use a dynamic dimension as one of its dimensions, write allocation calcs to allocate data to SKU level and be able to modify that data using cube views? If not, what is the best way to handle this use case without having to create another non-dynamic SKU dimension.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)POV Action on OS 9.0
Hi all, I'm experiencing a strange issue on OneStream (rel 9.2.0.18004) that was working as expected under previous release (8.*) In a dashboard I have combos that let me select Scenario and Time, with a "POV Action" that set them back setting - respectively - WFScenario and WFTime parameters. Now, starting from the above mentioned release, whenever I change a combo, the focus moves from the dashboard, opening the selected Workflow. So, the User is experiencing something like: Launch the Dashboard Select Scenario System opens current WorkFlow Open back my dashboard Select Time System opens current Workflow Open back my dashboard Run the action In previous release, the POV Action didn't took the User away from the current dashboard. Have you experienced the same issue ? Is there a workaround to let the user stay in the dashboard ? Thanks in Advance FabioG
TXM - TXM - Reconciling Duplicate Lines with the Same Amount in the Same Data Set
Hi, We are working on a Proof of Concept (POC) with the aim of implementation. However, one issue remains a roadblock and is hindering the adoption of the solution: the deletion of lines loaded with the same amounts, which we are unable to reconcile or isolate. In TXM, our ERP system sends us many identical lines (following corrections by the accountants): e.g., Transaction ID 1, CPT1, Invoice: 10000 Amount: 10; Transaction ID 2, CPT1, Invoice: 10000 Amount: 10; Transaction ID 3, CPT1, Invoice: 10000 Amount: 10. I would like to know how, within a single Data Set and from the same Data Source, to reconcile and/or isolate these lines, which represent unnecessary noise in the analyses. From my understanding, intra-Data Set reconciliations are not possible in this case. I sometimes have 2, 3, 4, 5 or even more almost identical lines that unnecessarily clutter the analyses and hinder the actual cases that need to be studied. Do you have a solution for reconciling these lines and placing them in a reconciliation status awaiting validation? (Ideally, matching them with a reason code like "same lines," for example.) Thanks! BR
Excel Spreadsheet Component Annoying Popup
Hi All, We are using a spreadsheet component on a dashboard to show a cubeview. When we enter text into an annotation field, it works fine and you just have to hit save afterwards for the data to be committed to the cell. However, if we want to attach a file to the cell, once we do that and click ok, we are prompted with a message box that says "Do you want to refresh OneStream data? All unsaved changes will be lost". Regardless, of whether we say yes or no, the file still gets attached. Is there anyway to disable this prompt as it really doesn't offer any value to us? Is this out-of-the-box functionality? Thx, MikeHide Tabs in Dashboard
Hi, I have a dashboard with 5 tabs which is assigned to a workflow step. One of the tab has a cube view where assumptions are inputted. I want this tab to be visible only for administrators and not for every user. IsVisible is something i have used to hide dashboard components with an XFBR but i dont see the same option for embedded dashboard. Is there a way to get this done?
Dynamic Parameter on Bound List
Hi all, I'm trying to pass a Dynamic Parameter (from a repeater) to dynamically build the Bound List of a Combo. While (for example) ~!Text!~ and ~!Tooltip!~ params do correctly populate Text and Tooltip properties of a Combo, I'm not able to pass a Dynamic Parameter (eg: ~!DisplayMember!~ to the param (Bound List) beyond the Combo. It's not translated into its actual value. Since the repeater is Dynamic, and the number of repetitions is variable (unknown at design time), I'm wondering how would be possible to parametrize a single Bound List Parameter, without having to duplicate it 10 times (limiting de facto the power of dynamic components). TIA Regards FabioG
