Reporting

I created a Reporting book with a loop on CC's. Is there a way I can filter the Tabs without data in the Report? I am planning to implement and test the options listed below but I also wanted to check with the OS community if they ran into this issue and the solution they implemented to fix this Issue. 1.Assign a Text to the CC's with Data and use IF condition to only export data for the Cost Centers with the Text 2.Create Alternate Hierarchy for the CC's that have Data (Note: This list won't change)

Hi there, Im looking for tips and tricks, whether thats any tips on turning an excel file into a OS report build etc. Any insights or documents are appreciated!

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 Sam  

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.  

Originally posted by Chris MatthewsWe are able to freeze panes with a cube view export straight to excel but when the same cube view is used in a book the freeze panes is lost. Is there a setting or way to keep the freeze panes?

Hi Team, We have a requirement like, Finance team wants to have one report with the details of Workflow Status, who certified the respective entity (name of the user) along with certification time stamp.   used the below Dash Board data set rule. followed the below steps to get the grid view Attached the Business rule to Data Adapter Attached the Data Adapter to BI Viewer. But here i am getting two certified status for the entity. we need the latest certified status. can you please help us to resolve this. Imports System Imports System.Collections.Generic Imports System.Data Imports System.Data.Common Imports System.Globalization Imports System.IO Imports System.Linq Imports Microsoft.VisualBasic Imports OneStream.Finance.Database Imports OneStream.Finance.Engine Imports OneStream.Shared.Common Imports OneStream.Shared.Database Imports OneStream.Shared.Engine Imports OneStream.Shared.Wcf Imports OneStream.Stage.Database Imports OneStream.Stage.Engine   Namespace OneSt

Hi I tried to put Dashboard in Report (Onestream Book) but not able to see any dashboard details in the book. Its dashboard report is stage data filtered. Also, can we add the dashboard in excel Book ? Can you please help me with the parameter?    

Hi  I have been trying to dynamically update the short name for UD3 but somehow the i am not getting the result. Not sure where i am wrong. Please help  

Hi everyone,I'm currently working on a dashboard that, through the use of a SQL table editor, will show data stored in a table. Below an example of one row from that table:The interface of the SQL table editor allows me to filter the data to show only specific rows, and I added a filter for the columns T_ENTITY and PERIOD: The first filter (T_ENTITY) works as expected. The second filter should filter out those rows in the table whose Period differs from the one selected by the user in the WF. Nevertheless, if I use |WFTime| as parameter, it doesn't show any row, even those that have the same Period as the WF. If I instead replace |WFTime| with the static period (es 'PERIOD = '2022M11'),  it works fine. The conclusion I take is that |WFTime| is not equal to the current WF period. To check that out, I added the following label to the dashboard header, setting its value equal to |WFTime|:and it shows exactly the current WF period:Is it possible that the parameter |WFTime| d

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!

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?

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! 

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!

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?       

Hello I have a query regarding Graph editing in OneStreamI 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 month 

Hello everyone. I have a problem. In the header of the previous year's column, the month keeps disappearing and only the year remains. Do you know how I can make the month display ? Please.. 

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!

Hi Is there a way to change the path of the folder within the "File Share" so that it would be possible to save a file generated by Data Export step from a Data Management job to a folder other than DataManagement->Export_"MyFolderName" ?   Say for example I want to save the file to a folder under Groups->Everyone->"Specific Folder to be Saved" Would like to do this without using the file transfer step in the DataManagement, since the file is large. thanks Kumar

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.... 

Hi all,We upgraded one of our OS instances to 9.0.0After 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? 

Hello! Is there a way to export the server audit reports to a file? This is the information from the Audit tab on the servers.  Thanks!

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?

Does anyone know how you can default the cell to use the cell detail or even better enforce the users to use only cell detail on the form?Thanks

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.

I created a couple menu components and I'm using images with them on the landing page. I read that you can use an image and also have a header text display but i can't get the header text to show with the image. Is there something special that needs to be done? I am manipulating the parent item below and thought it would be as easy as creating a header text but im not getting the desired result. Below is  a screen shot of the image and the children of the menu but I want to see some kind of value by the image that says Tasks'     'ManipulationsparentMenuTaskItem1.HeaderText = "Tasks"parentMenuTaskItem1.ImageFileSourceType = XFImageFileSourceType.DashboardFileparentMenuTaskItem1.ImageNameOrPath = "LP_task.png"parentMenuTaskItem1.Height = 100parentMenuTaskItem1.Width= 100parentMenuTaskItem1.ToolTip = "Tasks"