Reporting

Hi all, We have a Global Chart of Accounts that is used for both our Statutory and Management reporting. For our management reports, there is a requirement to have expense items below OP showing as negative - such as Tax, Interest, Depreciation etc. Opex accounts above OP will be shown as positive, as is currently happening. I understand this could be done by allocating the sign flip to the specific accounts in the transformation rules and/or changing the account type to Revenue, however, this is only relevant for the Mgmt set of reports, not the Stat reports. I'm interested in seeing if anyone has any ideas for how to show different signage on certain reports, rather than applying them all reports. On the cube views, the rows currently us A#M_NPAT.base for the entire CoA . Thanks in advance. Andrew  

I have 50 rows and 4 columns, here I have to do a calculation with cell wise.For eg: col4row20 = col1row1 / col1row10             col4row21 = col1row2/col1row11             col4row22 = col1row3/col1row12Likewise I need to input the multiple formulas for the cells, here what type of member formula I can use.

Is it possible to use the right click - Navigate button in a quickview?This button shows up but it is greyed out.  I would like to see if there is a way to navigate to a dashboard similar to creating a linked dashboard in a cube view.  It would pass the default parameters (ie EntityNavLink) from the quickview.     

Dear Community Users, We have Blank rows and Blank Columns for the space convention. I'm getting 0s for both blank rows and columns while generating the report. I used below condition: and even tried hard coding 'ReportNoDataNumberFormat = #' in all blank rows and columns. Couldn't be able to resolve it. Any solutions to this are really appreciated. Thanks. If (RowName Contains 'Blank') And (ColName Contains 'Blank') ThenReportNoDataNumberFormat = #ElseReportNoDataNumberFormat = [$#,###,0.00;($#,###,0.00);0.00]End If

Dear Community Users, As you can see in the above image, last character of the data [i.e., ')'] is getting printed in the next row of the report. I have tried increasing the width of the row. But it's not working. Any solutions to this are really appreciated. Thanks. 

We have a requirement to make all the negative value to encode in parenthesis () and to display percentage % for the column "Variance vs Prior year %" in the Cube View. Anyhow, we have written formatting condition as"If (ColName Contains '%') ThenReportNoDataNumberFormat = [#,###,0.00;(#,###,0.00);0.00], ShowPercentSign = TrueEnd If" and it works perfectly fine in the data explorer tab. But while running it in the report it displays only parenthesis () and the percentage sign is missing.  The above is the screenshot from data explorer tab.  The above is the screenshot from while running it in the report.  

Hi,  Is it possible to create a dependent dropdown list using a SQL Table Editor? Example below: If I select Entity A in the Entity column, I would like PC1, PC2 to be options within the Profit Centre column. If I select Entity B in the Entity column, I would like PC3, PC4 to be options within the Profit Centre column.   I have tried using 'Selection Changed Server Task' to update a Literal Parameter that I can use as a basis for a Bound List parameter that I am attaching to the Profit Centre column , however this only appears to work after the row has been saved:   I think it may be possible if the user was to save the row after choosing the Entity and then selecting a Profit Centre, but this wouldn't be an ideal user journey.   Thanks, Mark

I am having an issue where the the logo assigned in application properties is not appearing on exported PDF reports. I have sized the image to 50 pixels in height and have set the "ReportIncludePageHeader = True" on the cube view header format. The logo is still not appearing. Are there any other settings that need to be changed for it to appear on the reports?  

When we open a Spreadsheet Table View from a Dashboard we would like the Content Pane to be hidden.   

I am trying to figure out the best way to embed my monthly OneStream reports into PowerPoint presentations.Do I need install the add-in and have tasks created in task manager? or can this be done through the creation of an extensible documents?Thank you for any help or suggestions,Ricky

I have a requirement to display two logos in the report. The first logo indicates main parent entity and the second indicates the child. I tried exploring multiple options but, couldn't find anything positive. So, is there any way/OneStream allows more than/multiple logos that can be displayed in the report? Or Is there any logic that can be built in the Business Rule (BR)? 

We upgraded to 7.3.3 and noticed that grouping that are created in excel is disappearing when we refresh the quickview report in the excel add in.  If I refresh the report in spreadsheet application, the grouping disappears but at least it is hiding the columns/rows that were grouped.  Has anyone noticed this?  Is there a fix or work around for this?Thanks 

Hi, does anyone have a clue on how to use the Binary Array facility inside the Image component in a BI Viewer? I couldn't find anything in the documentation apart a simple mention. How do I actually load image files inside this Binary Array? Thanks 🙂  

Hi All,   Can anyone help me with row Division Formula in Cube view, I have tried below one but getting error. Please suggest GetDataCell(Divide(CVC(Row7), CVC(Row2))):Name(CM%)     Thanks in Advance.

We are using XFString to present text on Cube Views in different languages. It is documented here: https://femsadev.onestreamcloud.com/OneStreamWeb/Help/Content/Design%20and%20Reference/Presentation/Reference%20Alias%20via%20XFString.htmI don't want to prompt the user for their language - is there a way to use the user's culture code and suppress the prompt?Thanks

SOURCE: ONESTREAM CHAMPIONS Hi Team, Greetings for the Day. We have a requirement to download the registers data into an Excel Book with all Account as different Sheets and that too from within one stream. One STream table view is the best option provided to fetch the data from one stream. The question here is we have 100+ Accounts in there, which we need to bring in the tabs, and to achieve that we need to add all tabs 1 by 1 under Spread Sheet - Table view (Refer to attached screenshot). Is there any automatic way to append the Table view with all accounts tab names using some macro or inbuild One Stream Functions?     image.png1114×546 39.1 KB    

I noticed that the application tables have an odd time format in column called timeid   is there another table that houses the times in 2023M3 format or is there a way to convert this column easily when using it in a SQL data adaptor?

We're trying to export a Form into Excel and we are receiving the following error.  Has anyone had this error when trying to export a form into Excel?   Thanks

Is there a way to make dashboards stop refreshing every time you navigate to another tab in OneStream and then come back to the dashboard?

What is the difference between 'drill down' and 'drill back' functionality?  is it just the matter of different names refering to the same function?  thank you.

Hello,  We are using the Excel - Addin and made some templates to work better with OneStream. It worked great, however we found that the users sometimes have the error of clicking "Submit Workbook" instead of "Refresh Sheet".  We tried to customize the ribbon to separate them but it is not possible because the Refresh and Submit button are in the same tab ("Data"). Is there a way to modify it? Is it a common mistake? Thanks for the attention and best regards,  

I am trying to use the the GetDataCell function for both Rows and Column and the math is not working.  For the row, I am using GetDataCell to sum several G/L accounts.  For the columns I have Actual(C1), Budget (C3)and the 3rd is a GetDataCell (C3) to take the difference between Actual and Budget.  I am not getting any errors but the Variance Column (C3) is returning the value in the first column.  Its as if the second column has a zero loaded.

Hello, For a project management perspective, I would like to use the Gantt component in a dashboard. The documentation only explain that we should use XFGanttTaskCollection for that. Are there any implementation that have been using this component, any documentation to share about it ?   Regards,

I created a combo box in a dashboard and the combo box is associated with a parameter that provides a considerable list of elements for selection. The user would like to have a button to clear all the selected elements as needed. Would you know of any alternative to clear the selected elements from the combo box? Thank you for all the help.  

Hi, So I have inherited a OneStream application and although I know how to build cubeviews, I cannot work out how to replicate the feature shown below on some of my existing application's cubeviews. The cubeview "parent" is referencing a row template to provide the flow lines and a column template which holds the parameter elements to select in this example the PPE Class.  I am trying to recreate this layout, but try as I might, on running the cubeview it just serves a popup for the user to select the parameters, rather than docking it to the cubeview output. What do i need to select, or where do i need to place these various elements in order for me to be able to dock it like this screenshot. Thanks Mark