Time - Prior11 -- newest to oldest
Is there a way to pull time in newest to oldest? T#|CVTime|.Prior11 ---- Pulling M4 on an Oct - Sep 2025 calendar. This will pull Feb 24, Mar 24, Apr 24, May 24, Jun 24, Jul 24, Aug 24, Sep24, Oct 25, Nov 25, Dec 25. How do I pull the opposite - Dec 25, Nov 25, Oct 25, Sep 24, Aug 24, Jul 24, Jun 24, May 24, Apr 24, Mar 24, Feb 24?
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!
