Announcement
ABC
Recent Activity
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)
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.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
Manage Workflow Issues
Hi Team, In Manage Workflow initially i have faced an issue, we thought Workflow channel name "Whatif_R&O_Adj" contains special character &. is this really because of '&' symbol. or is there any other issue. Could you please advise on this. and after clicking on the 'ok'. it is not showing unlock and Unlock Descendent options. Please help to resolve the issue. Below are my workflow settings. Thank you, Shiva Prasad.
Automated email notifications on workflow status changes
I’m exploring ways to configure OneStream to send automated email notifications when a workflow status changes. Specifically, the requirement is something like: When a workflow transitions from Not Started --> In Progress, or From In Progress --> Completed (or similar workflow status changes), the system should automatically send an email notification to a defined user or user group to inform them of the status change. If anyone has implemented something similar or can point me to the right framework (or limitations) around workflow-driven notifications, I’d really appreciate any guidance or examples. Thanks in advance!
Extract dbo.vStageSourceAndTargetDataWithAttributes data to csv or txt
Hi everyone, I need to add a button to a dashboard to allow users to export to csv or txt some data from the staging area, specifically from dbo.vStageSourceAndTargetDataWithAttributes I tried multiple approaches using a dashboard extender but cannot find the right way to do that. Has anyone done that before and has any suggestion or best practice to do it (even without using a BR)? Thank you for the help!
Navigation behavior
Hi everyone, I’ve developed a report using Cube Views and noticed the following behavior with keyboard navigation: The Tab key moves right and then wraps to the next row The Arrow keys move in their respective directions and wrap at the boundaries When navigation reaches the end of the report, it continues by jumping back to the beginning and starts again from the top. Is there a way to stop this wrap-around behavior at the report boundaries? Is there any property setting to control or disable this? Thanks in advance, Archana
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, MikeWhy 2+ Import of a Matrix Flat File of One Workflow Profile to Load Certain Months into a Data Cube?
For the first Import of a Workflow Profile, data in certain months in a "Matrix flat file" failed to be loaded into a Data Cube. For the second+ Import of that Workflow Profile, data in those months in that "Matrix flat file" could be loaded into a Data Cube. - In summary, data in certain months in a "Matrix flat file" must be Imported > 1 time of a Workflow Profile to be loaded into a Data Cube. Please share the root causes for v9.2. Thank you, SMEs.
