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.     

Hello,   I am looking for help with the quick view functionality. We are moving from HFM, and when creating back up for certain journal entries/rollforwards in HFM ad-hoc excel files, we would type POV:{} in the header of the spreadsheet so that when the file was printed it would also show the POV members used to generate the data in the spreadsheet. I have included an example. Does anyone know how to accomplish something similar through quickview? Thanks!  

I am able to display it in data explorer but unable to display in PDF report.

Hi All, I need to share few specified columns  from one Cube View to another, Can anyone suggest how to use specified  columns in Cube Views.     Thanks in Advance.

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

When I develop cube views, is it possible to have the description in the header for the data in the rows, for instance first column might be Account, second column Customer.  When I extract the cube view the header for these is blank and I have to manually insert a description to the dimension is relating.  Same issue occurs with quickviews.   Any solutions

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.  

Hello.  I have a user who is attempting to refresh his excel workbook using the Refresh Workbook button.  The file contains multiple tabs with XFGETs only.  He is returning the following error message.  I can re-create the error on my end, but the refresh workbook also appears to work intermittently.Has anyone come across this error before and know the cause/remedy? 

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

Hello all !I come to you about quickviews which crashed when we tried to open them.We built lot of quickviews for the top-reporting or analysis of figures. We store them on the server company and when we try to reopen them to update, all formulas crash (hsget... hsset... )Did you already see a similar case ? Did you find a solution ?thank you all,VN

A#Cash.TreeDescendantsInclusive.Where(Text8 = L1).I have used the above formula to display only level1 members of one account but now I want to like to display level1 members along with the parent members of L1.Help me out in reframing the above formula.Thank you.

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?  

I have a cube view that displays values that are entered monthly. For the months that haven't had any data entered yet, it automatically fills in a 0 in a greyed-out format. Similarly, if I display this same row in a YTD view, it shows the YTD value in the months that have not been entered in yet. My customer would prefer these cells display no value. I cannot find any setting or formatting that will display it that way.I've tried changing the number format to empty string ("") based on IsNoData or IsDerived but that has not yielded the desired result.  

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

Hello; Im crating a cube view with 2 rows (maybe more) that one of them is a result of a complex function: "A#INCOME_STATEMENT.Base.Where(Text1 Startswith On-Campus)" and shows several rows qualified as Text1, now I want to sum those Accounts but don't like to use each Account; it could be possible to use a function in a 2nd row like this: GetDataCell(A#INCOME_STATEMENT.Base.Where(Text1 Startswith On-Campus))::Name(On-Campus) is that possible?   Thanks in advanceand best Regards. Mario GV

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

How to customize the OneStream Excel Addin Ribbon.     In Excel, go to File > Options Select Customize Ribbon Select Main Select the OneStream Tab on the left – that is the source of all the buttons Select the Onestream Ribbon on the right – that is your target customization Move the buttons you need from left to right. You can create groups for your menu too.   If you want to separate the Save and Refresh, you first need to Remove it and then recreate it. Like shown in the screen above. You can then create a ribbon like below where I separated the Data Refresh vs Data Save. Unfortunately each user has to do that.  

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,I created a cube view group in the in the application and it works fine. I placed it into a cube view profile so I could then pull it into an excel workbook via the onestream add-in. This also worked fine.However, now when I go to refresh the data, as this will be a monthly report, the cubeview is not connected and everything is essentially hardcoded. What changed to cause it to go from a living report to not connecting to the data base? 

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.