Recent Discussions
Custom Validation Before Saving Cube View Data
Hi Community, I have a dashboard that includes a Cube View and a button with the "Save Data for All Components" action. Users enter data directly in the Cube View and click the button to save. I’d like to implement a custom validation step before the data is saved. Specifically, I need to calculate the sum of four specific accounts, and if the total is not zero, I want to prevent the save operation and show an error message to the user. Is there a recommended way to intercept the save action and apply such a validation check? Any guidance or best practices would be appreciated. Thanks in advance!
Using XFBR String Service in WS Assembly
I'm new to WS assembly - trying to get a simple example of setting up an xfbr and use it in a cubeview but not successful. Here's what I did - what did I do wrong? 1. Set up XFBR String Service: 2. Then set up factory: 3. Then added to my maintenance units & workspace 4. Added to cv: => I get this error. Not sure why it is looking for the service factory in default. I followed the design guide, tried all the following syntax, none have worked: XFBR(Workspace.Reporting.myAssembly.Time, SayHello) XFBR(Workspace.Current.myAssembly.Time, SayHello) Thank you.
Row Headers based on condition
I have a cube view similar to below. What I want to see is all the Accounts in the left most column like you see below and nothing where it says "Top" (not even the level where Top is). When I switch to UD1 in the same cube view, I then want to see the header as "Loading", "Unloading", etc., in the left most column where you see "Oper Expense". and not see the "Oper Expense" at all even though I'll have the account in my POV. The row header only allows you to have one header as Header 1. I'm thinking this is only possible with an XFBR String? Has anyone else done this? If so, please share. Thanks....
BI Viewer component and OneStream 9.0.0
Hi all, We upgraded one of our OS instances to 9.0.0 After a first look, it seems BI Viewer does not work anymore from Desktop app, but charts are showing from Modern Browser interface, any idea? Can't find a clue on Know Issues. On Desktop app, only the layout shows, no content: Same Dashboard from Modern Experience shows fine (I blurred data here) Any advice?
Mid-year base entities to new parent
Mid-year we created a new parent entity and added base entity relationships to it because the base entities moved to a different legal entity. We load YTD trial balance and the previous parent should report the base entities for the first 6 periods of the year; new parent second 6 periods. We're using the "In Use" setting on the old parent member to cut off at period 6 which seems to work fine. For the last 6 periods, revenue and expense accounts continue to show the first 6 periods' activity. Is there a way to continue loading full YTD balances with the new parent reporting YTD periods 6-12 not 1-12?
Report (PDF) Header Background Fill Color Not Extending to Bottom of the Space
The background fill color on the header is not filling the entire space when viewed in PDF. You can see on four of the six columns there is white space where the text is shorter. I need the teal color to fill to the bottom of the header space, and not just exist where the text is located. It works fine in excel and cube view. The issue only exists in report PDFs. Does anyone know of a way to accomplish this? Report/PDF: Excel: Cube View: Here's an example of a PDF that looks good because the length of the header text is more comparable across the columns: I'm sure there's a way to accomplish this through a Custom Report Formatting rule or formula. I'm trying to avoid this, as I feel the formatting should already default to what I want. But, if I have to go this route, I will. Thanks in advance!
Cube View showing amounts loaded into plug account during consolidation
Hi all, I recently launched the consolidation process for my client, and the amount under the plug accounts is unusually high. I would need to develop a cube view showing, for each account in the rows, the amount that was loaded into the corresponding plug account during the consolidation process. Is there a way to do that? Thank you in advance!
Cube View formatting mixed dimensions
I have a Cube View that is displaying a single dimension in the first column (Departments), and a second dimension (Accounts) in the second column. In order to match the formatting of the report that is currently in use I’d like it to display in the first column Departments up to the bolded Total row, then accounts from there on out. In essence it would be mix of two different dimensions displayed in the first column. I would also like for the second column to be hidden. I have made some attempts to match the formatting as I described, but without success. Do you have any ideas on how to achieve this? Thank you for your time in advance.
