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!How can I become a Advanced User of Member Filter Builder in QuickView
I am a Financial Planner and Analyst and My Organization use OnStream. I want to understand better how to extract the data for Multiple scenarios (act, fcst, budget, py) using Member filters, variables understand workflows, and parameters?
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....
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 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.
