V#Trailing12MonthTotal
Hi , I am trying to use the V#Trailing2-12MonthTotals in my reports. Could any expert users please advise if the TrailingTotal in View Dimension works only for P&L numbers or they work for Balance Sheet and Retained Earnings totals also. Any reponse will be much appreciated. Thanks Sam16Views0likes2CommentsTop Ten and All Other
Hi. I have a cube view / customer sales report where I can get my top ten customer sales, and I have a row that has the total sales. How can I make a row to show 'All Others' so I can foot the lines to the total sales? I've tried a CVR calc but it pulls in the top customer only. Thanks, Brian1.2KViews0likes6CommentsRow Formula is overring Ud8 Calc
Hi Team, In our report we are having multiple formula's in row and columns (Can't apply the row or column overrides). So, have created a UD8 Dynamic calc. though after applying the UD8 member in column, row formula is overring the UD8. Can please help us to resolve the issue.35Views1like3CommentsSQL Table Editor Dynamic Drop down
Hi Community, I have a question. I'm working with a SQL table editor and need to implement dependent dropdowns. Specifically, based on the value selected in the first column, I want the second column to display a corresponding set of dropdown options. Is this possible to achieve? If so, could you suggest any approach that can help me implement this functionality? Thank You!15Views0likes0CommentsTime - 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?6Views1like1CommentAutomating Consolidated Financial Reporting with OneStream
Hi everyone, We currently use OneStream to prepare our consolidated financial statements in Excel, using retrieves linked to OS. But in the end, we still manually copy everything into Word to build the final report. We’d like to automate this process as much as possible to reduce errors and save time. We need to include notes and commentary under certain tables, so Word is our preferred format. Is this kind of automation possible directly in OneStream? If not, what tools are you using to produce your final reports? Any best practices or recommendations would be much appreciated! Thanks in advance for your responses!Solved86Views0likes2CommentsHow 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?26Views0likes0CommentsGraph and Charts in OneStream
Hello I have a query regarding Graph editing in OneStream I wanted to know how we can edit the graph in OS. Eg: The client has a waterfall chart built for the EBIDTA and they have the previous 2 years comparison as well. However the October and Nov month shall start from the start point 0 similar to Sept Month whereas currently they start where the previous moth ends. Also the colour of the bar for Oct and Nov shall be Blue similar to Sept and Dec month16Views0likes0Comments