Reporting

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

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

Dear OneStreamers,I'm looking for a solution to have the headers displayed in a cubeview, even if it is repeating (so same header on next row for a dimension member.  I could not find an option to use in the formatting or general / common options.  Do you know how to achieve it ?Thanks,Hilde

I am well aware of the "Suppress Repeating Member Names" True/False box on a Quick View.   I am looking for the exact same toggle on a Cube View. I could have sworn this was a very easy thing but I don't see it. In the below Cube View example below, the first row member expansion is the Actual scenario and the second is a TreeDescendants on the Account dimension. I want the "Actual" scenario to repeat all the way down on each row. Am I missing something easy here?      

HiI'm using Guided Reporting to generate a Cube View. Within the Cube View, a parameter (delimited list) is used to show / hide columns. This is working fine.My problem is that in the Selector List, Guided Reporting is showing the Value Item (of the Delimited List) instead of the Display Item. For example, an end-user will select 'Collapsed' (Display Item) but Guided Reporting will show 'IsColumnVisible = CVMathOnly' as the Display Item.This isn't impacting report functionality, however it looks messy.    

Hi, does anyone know how to get the dimension descriptions (other then default) into PowerBI via the OneStream PowerBI Connector? In the OneStream PowerBI Connector, there is the "Get Dimension" part with an "include descriptions" option but it only loads the default description (which is english in our setup). We have also a German culture setting and all descriptions are setup in English and German but I cannot find a possibility to get the German descriptions in PowerBI. RegardsMartin  

Hello,Is there a way to sort accounts in numerical order using the member filter builder?Need to see trial balance in numerical order based on account name (i.e. A#12345, A#98765, etc) using the hierarchy. It would help as well if we could apply alphabetical sorting as well for the accounts which start with names. (i.e. Investment Other, Autos, etc).Thank you in advance,

SOURCE: ONESTREAM CHAMPIONS Hi All, I am trying to find a way to create a report that shows the Entity and the Parent in a column next to it. I tried to do this by using the functions =XFGetMemberProperty() and =XFGetRelationshipProperty(), both returns an error when I try. =XFGetRelationshipProperty(“Entity”,"",B15,“Parent”,"","") returns “#ERROR: Parent”=XFGetRelationshipProperty(“Entity”,B16,"",“Parent”,"","") returns “#ERROR: Member Name”=XFGetRelationshipProperty(“Entity”,B17,"",“Parent”,“ACTUAL”,“2021M1”) returns “#ERROR: Member Name”=XFGetRelationshipProperty(“Entity”,B4,B5,“Parent”,"","") returns “#ERROR: Parent” =XFGetMemberProperty(“Entity”,B13,“Parent”,“Finance”,“Actual”,“2021M1”) returns “#ERROR: Finance”=XFGetMemberProperty(“Entity”,B14,“Parent”,"",“Actual”,“2021M1”) returns “#ERROR: Parent”=XFGetMemberProperty(“Entity”,B14,“Parent”,"",“Actual”,“2021M1”) returns “#ERROR: Parent”=XFGetMemberProperty(“Entity”,B11,“Parent”,"","",“2021M1

Hoping someone out there has some ideas on how to make this work... Let's say we have a cube view containing a parameter that allows the user to select a scaling option (millions, thousands or no scaling). The results of the parameter are stored in the CV's default CellFormat.Currently, when the CV is run and exported to Excel; regardless of the scaling selected by the user, the display in Excel is in thousands and Excel stores the entire number (unscaled).For example - if scaling selected is millions:If the number is 345,773,247.11; it displays in the CV as 346, it displays in Excel as 345,773 (but the stored number shown in the formula bar is the correct source value:  345,773,247.11).In other words, regardless of whether user selects thousands, millions or no scaling.... Excel displays as thousands and stores the correct number.  If I try to change the Excel format to display in any other way (i.e. millions), it will store the scaled value based on the format and no longer

Hello, I'm trying to create a cube view that grabs actuals from People Planning and populates the future periods with the latest month of actuals. e.g. in M3, M1=M1 Actuals, M2=M2 Actuals, M3=M3 Actuals, M4-12=M3 Actuals.  I need this in a cube view because we need to be able to show the data in both local currency and USD.  People Planning is currency agnostic.  I tried this directly querying XFW_PLP_Plan with SQL and a biViewer, but ran into the problem of not being able to bring in FX rates.  I can only show local currency.Has anybody done this or have any ideas?  Perhaps something with UD8?  Perhaps there is something simpler I'm overlooking?  There is SO much to learn with OneStream and I know I'm only scratching the surface.

Currently i am working on NR reporting, i have created extensible documents with cube views, those cube views has parameters Is there a way where we can supply the cube view parameters, in doc variable? i have tried to apply parameters in book and document section in NR but that is not working. Thanks for your help and support.

Hi. Is it possible to make annotations in the UD1 dimension and have them roll up to the respective legal entity (at consolidated level)?A challenge I'm facing is that only specific base members under the UD1 dimension reference the legal entity in the text field. How can I manage this so that only the relevant regions (that reference legal entities) contribute to the commentary at the consolidated level?

Hi all! How can I wrap V#Annotation text in a column? Right now the reporting is not the most user friendly so we're wondering how to show it better. It looks like there were some suggestions from three years (Maximum characters for Annotation | OneStream Community) ago but wondering if we've made any progress on this issue since then :)  Thank you! -Nicole

How can I get xfgetcell formula to not pull in the next month as a negative? i am making a YTD file and currently have Jan and Feb number but march pulls in the YTD amount but negative and causes the ytd amount to be $0. 

Depending on the circumstances, you could find yourself into a situation where you need to report numbers on Extended dimension Members from the Top Consolidation Cube. In a Vertical Extensibility Cube set up this gets tricky since the data is only available at the lower cube levels. To work-around this challenge (considering the limitations exposed below), I have created a dynamic calculation Business Rule that allows you to achieve that by leveraging a specific UD8 Dynamic calculation Member.    Following it is an overview of the Solution:  Problem Statement: When using Cube Vertical Extensibility, reporting from Tot Group cube is not possible for those dimensions that have been extended. In the example, UD1 is only available at Summary Level for  Tot Group: Solution Overview: UD8 Dynamic Calculation to derive the Extended members from the Base Entities consolidating to the Parent Entity Level (E#Tot Group). Data is dynamically retrieved from the base entities

Hello,I'm trying to figure how to stack 3 cube views on the same page and add that to a book. I know you can create a stacked report in a dashboard. But I don't know if you can add dashboards to a book or not.Thanks,Will