Reporting

Hi, I am building out a Trend report by year and by product, so I have Jan-Dec along the columns, and then 2022-2025 for each product type by row.  My problem is that because i'm viewing this in V#Periodic, when I run the report for March 2025, April's balance shows up as the negative YTD balance for 2025.  Is there any kind of conditional formatting I can use that says something like "If the intersection of month and year in the cube view (in this case, April 2025) is larger than the Time POV parameter selected when you run the report (March 2025), then change the text color to White so it doesn't show up?   

Hello,On version 8.5 (could be earlier, but didn't have a need to try) I am trying to create an embedded cube view that retains excel formatting. When I check mark the preserve excel format this works, BUT when I save the report, close it, and reopen it the cube view itself stays a light font vs black. Once I uncheck preserve excel format it reverts back to the expected black font cube view.....Is this a known issue or a way around it? 

Hello all,I've written a Member Filter Builder on A#IncomeStatement.Base.Where(AccountType Contains Revenue).  A second one for Expense too. I am now trying to sum those rows and cannot seem to get the math logic to render. Any advise out there - what am I missing or not considering? Columns are Entities, not row/column sharing, and the number of rows are extensive.I've tried the following and cannot seem to get it right:GetDataCell(CVR([TB_Rev])):Name(Total Revenue)GetDataCell(A#IncomeStatement.Base.Where(AccountType Contains Rev):NameThanks in advance for your help, 

Hi everyone, I am creating a graph in a report. This report is a component in a dashboard maintenance unit and is using a simple data adapter linked to a cube view to retrieve the data.  The graph is working. However, I would like to only show a data label based on a time selection parameter that is part of the data adapter. For instance, if I select 2022M11, I only want to see the data label for November 2022. Please see the screenshot for clarification. So, if I select November 2022 (or any other year) I would only like to see the data label for November (I still need to work on the number formatting). Is there anyone with experience in this and can help me? I have checked all the options but couldn't find anything. I was thinking to work with the scripts part of the report components.  Any help is much appreciated. Thanks! Floris van der Poel

Hi, we have a custom member filter in a cube view (i.e. E#Root.CustomMemberList(BRName=X, MemberListName=Y)), and it seems to disable row suppression.In other words, the cube view brings back all filtered members in rows, regardless if there is data, even when the row suppression settings are set.Has anyone else experienced this and can confirm/deny? And if so, is there a way around it? We based architecture on CustomMemberList following the same rules as any other member filter.Jon  

  I have the following cube view in Oneplace and I would like to know if it is possible to create subgroups below the Main group.  For example I would like to create a subgroup of Income Statement report, Revenue reports etc.  They are currently in separate groups in the cube view set up but that does not seem to translate to Oneplace.  We are currently on 7.3.3 and moving to 8.5 in the next month.    

Hi guys,I need to create a pie chart on a report component (under dashboard), but this pie chart has the particularity that, instead of showing up the labels of the data presented in the chart itself, i need to show the Total Amount inside the pie. The achieve this, i wanted to add an XF label taking the total from the cube, but  when i set the label over the chart then i have the error "The control is overlapped". Do you have any workaround / solution to allow the controls, in particular the labels, overriding a chart?note: ok under preview that works, but at the end i need to use this report component in a docx file (with narrative reporting) - that's blocking me to use the report.Thanks a lot in advance,Regards,Florence

Hi I linked several cube views into Excel with the settings below (Version 8.4.0). I then created some basic formulae within the cube views. E.g. = C25. The Excel formula is retained by the first cube view but in the other cube views it is moving up 4 rows on each refresh. The Cube View Connection options are the same in each one. I have tried selecting/deselecting the insert/delete rows & columns and including/excluding the header. The cube views all have some rows with a specific account and at least 1 row that uses “.Base”. Has anyone come across this before? Thanks. Robert

Hello,I need to create a pie chart in a report component (under dashboard). So i created a very simple cube view with 2 elements of the UD1 dimension, and 1 column showing up an account. With this cube view, I created a data adaptor, with Command Type = Cube View and Data Table Per Cube View Row = False; when I open the data adaptor then I can see the correct data, with 2 rows and 2 amounts then.Now, when I create a report component and add a pie chart on it, the pie chart appears properly and as expected (2 pieces in the pie, for each UD1) but it appears twice ! And twice the exact same pie! Any idea from where/which setting this is coming from please? I am struggling in finding it.. Thanks in advance,Florence

Hi,I have a classique cubeview that uses !prm_entity! as Entity POV.When using classic Dashboards, everything works as expected.When converting the dashboard from "Embedded" to "Embedded Dynamic" and using a simple Factory service to add the template cubeview stored component, nothing more: then the !prm_entity! POV of the cubeviews seems not interpreted at run time, no prompt showup and this cubeview displays a blank page. When checking cube POV we can see parameter is handled like a string in the POV.Any idea what basic setting i am missing to do in the Dynamic Dashboard way to let OS prompt for the prm_entity parameter value?Thanks in advance,

Originally posted by Mike TurbesHow can I copy a tab in Excel that includes 1 or more Quick views to a new tab or to another file? Thanks, Mike

Hi, Is there a way to open a dashboard within the same page of a dashboard by clicking a button in OneStream? Thanks

Hi Team, Generally, In Scenario settings will updated the "Workflow Start Time & Workflow End Time". so here we want to get these workflow time rang in Cube View. (Eg: Work Flow Start Time: 2025M6 & Work Flow End Time: 2026M5). Based on scenario selection in  the report, we should get the (12 periods) time range in report.  Please help us to get the solution. Thank you, Shiva Prasad

Hello - I'm using Parcel Service to generate/ship a Book. The book is an Excel export file of a Cube View. Very simple.I can get the Excel file to email properly through Parcel Service. But, I also want to save a copy of the Excel file in the OneStream file system. Does anyone know the syntax for the OS file share path? I've tried everything I can think of. Thanks,Bil 

Hi,I have a CubeView with indentation applied on row members. When exporting to PDF, I need all columns to fit on a single page. To do that, some column headers wrap onto two lines. The problem is that the indentation works only on the first line of the header. When the header text wraps, the second line is not indented, which creates a misalignment.Has anyone faced this? Is there a way to apply indentation on all lines of a wrapped header in PDF export? Thanks in advance

Hi everyone,I have an issue when exporting a CubeView to PDF.In the web view, column headers do not wrap. All rows have the same height and everything is aligned properly.When exporting to PDF, I need all columns to fit on one page. To do that, some column headers wrap onto multiple lines. The problem is that the row cells under these wrapped headers do not adjust their height accordingly, which causes a misalignment between headers and data cells.Is there a way to force the row cells to align with the wrapped headers in PDF? Or any workaround to keep the layout consistent while making sure all columns fit on one page?Thanks a lot for your help

We are looking to have a cube view that uses a parameter or CV Extender to possibly control the primary dimension selection. This is used in a dashboard to show metadata selections with the dimension in the rows and ud8 dynamic formulas across the columns. Looking to see if anyone has any ideas on doing the dimension selection dynamically to use one CV only for display

Hello,We’re trying to display the date and time in the footer of our cube views in the following format:"Wednesday, April 16, 2025 - 16:27:13" (or "Mercredi 16 avril - 16:27:13" for a user with French culture settings).We are currently using the |DateTimeHHMMSS| variable, but it shows the server time (e.g., 14:27:13 instead of the user’s local time: 16:27:13).The native option via Application Properties > Show Date doesn’t meet our needs, as it displays the date in the format "4/16/2025" or "16/4/2025".We’re looking for a more readable format depending on user culture:"Wednesday, April 16, 2025" (EN culture)"Mercredi 16 avril" (FR culture)Does anyone know how to achieve this — displaying both the user’s local time and a culture-based, readable date format in the footer?Thanks a lot ! 

I have a daily report in bi viewer. This works by selecting the Week from a combo box and then it displays the days within that week (based on a sql table). I want to have the prior weeks show up as totals. Can't figure out how to do this within BI viewer or if I'll have to create a more defined sql query. Below are the screenshots from current setup. In this example I want to also see W1-4 but at their totals.  Select Week combo box: 

Hi team, my client was excited to upgrade to 8.2 to center headers. After turning on this functionality, what we have found is below. Can you tell me if I'm missing a setting here to make it work like we want it to? Finding: It only works if it is the top row AND it is a single member repeating. Notice how the months aren't centered, also notice that even though the scenario is merged and in the center cell, it is not centered WITHIN the cell.    

Is there a way with the :Name(description1) parameter to make cubeviews stack the headers so instead of the header being like "Description1 Description2", the header is "Description1" over "Description2" in the Column Header?  Particularly in a pdf report.

Hi,  We have several excel sheets with XLOOKUP formula. In application-spreadsheet (v6.8 and V8.4) this is not working. Whereas it is working in MS-excel. Is this possible in OS-spreadsheet? Working around with match/index/vlookups etc is not a solution. Thanks, Rutger

hello  we've a excel addin based report (XFGETCELL). this report has macros as well. the data is used for recon process on another server that doesnt have excel addin. Is there a way to run this though DM/ business rule? or can this be automated through onestream spreadsheet and save as offline?  i separated macros in different file and tried running this report as xfdoc,xlsx. getting #Logon error on server (calc is automatic, cant change on server) is there a way to save as offline? i tried running through DM but facing #Logon issue. the server where we want to run recon does not have excel addin and we dont want to install. any ideas, please suggest.  in longer run, cube view might be a better option but is there a better way to achieve this? pls suggest. thank you in advance

Hi! If we have a workflow scenario like forecast month 1, forecast month 2, etc. How do I change the # of days that fall into each month? I know there is a specific way to do it because I recall a colleague of mine literally typing out say 30 or 31. I've tried going to application, time profile, in the time periods tab, if I go to 2025M1, it only has the ability to change the first day of the month. I've also changed what days week 1 start and end in but these workarounds are not what I'm looking  for. Help please!

Hi,Are there any updates on merge and center on headers for cube views? It was informed that the enhancement is expected in one of the quarter releases in 2020. Do we have it available?https://community.onestreamsoftware.com/t5/Office-Hours/Question-Are-there-any-updates-on-merge-and-center-on-headers/ta-p/1503Thanks