Reporting

Hi, I am encountering an issue with the header format of the 'Total' row below where the ReportBackgroundColor is not filling the entire cell when viewing the report as a PDF.  There is no issue when viewing view the cube view or Excel.   Below is the header formatting we're suing: ELSE IF (RowName Contains ':Total:') THEN ExcelBottomBorderColor = Black, ExcelTopBorderColor = Black, ExcelTopBorderLineStyle = Thin, Italic = True, ReportBackgroundColor = Gray, ReportUseBottomLine1 = True, ReportUseTopLine1 = True I'm using the same formatting for Header and Cell Format but as you can see from the screenshot below, there is a blank space below Total.   Has anyone encountered this?

Hi all,I'm having a strange problem with cubeviews. I created some parameters to apply a standard formatting to my cube views:when I use them into the cubeview and I launch it, though, they appear in the initial popup without any value, as if they were user input params:am I missing something? is there anything I need to configure to make them work automatically?Any help is appreciated!

Hi all, I have an XFBR that I would like to take the entity member in any given row in a cube view. I've tried |MFEntity| but that doesn't work. |CVEntity| and |POVEntity| don't work either since they can only pass a single entity for a given cube view. Is there a way to get what I need outside of manually doing a column override for every single row in my cube view and hard coding the entity that I need to pass to the XFBR?

Hi all, I'm building a cube view which includes pre-filled columns including 12 months for CY budget, PY actuals and columns for YTD actuals. Additionally, I have included all future months in the year to be for the Forecast scenario for users to input.I have embedded this cube view into a spreadsheet form, so that users can either directly enter their forecast numbers into the spreadsheet in OS app, or it can be opened in Excel for users to complete outside the system. When I open the file in Excel, the CV correctly works and refreshes, and submission correctly writes the cells back to Onestream when FCT1 numbers are entered. However, I am stuck on one thing - is there a way to update the Cube View form cells by referencing other cells in another spreadsheet, or in the workbook? I can link 1 cell individually, but once I reference the cell, it automatically converts to a number and I cannot autofill any formula link to the remaining cells. Most users will either be wanting t

We recently upgraded from V7.4 to V9.1 and we’re seeing an issue with the Excel Add-In. A small group of users (about five) are unable to use the Drilldown feature (the option is completely greyed out), while the rest of our users can access it without any issues. All users have been upgraded to the 9.1 Excel Add-In and every other function appears to be working correctly. Has anyone else run into this? Any ideas on how to fix it?

Hi everyone,Quick View new user here, and for some reason I cannot create a new Quick View in a different Excel workbook. Is there a setting or feature I need to have active?  I have an active Quick View in another workbook, and want to create a different one in a new book. I am logged in, and I click the icon, but receive this message: Unable to create Excel Named Range 'QuickView_QuickView1' using '=[workbook name]$B$2'Any insight is appreciated and thank you in advance! 

The XFGetCell function has 20 arguments, when you have a large sheet (e.g. for data validation) there can be many of these functions increasing the size of the excel file. In SmartView it was possible to create 1 cell with commonly used arguments and reference that cell at once. In OneStream i'm not able to do so.  Off course i cannot imagine that SmartView has a feature that OneStream doesn't so i probably need to change my syntax a bit. Hope you guys can help. So instead of: =XFGetCell(TRUE, "Finance",$A274, "",F$4,F$14,F$5,F$2,$C274,$D274,F$3,$B274,F$6,F$7,F$8,F$9,F$10,F$11,F$12,F$13) I want to create a cell (lets say A1) that has the content: TRUE, "Finance",$A274, "",F$4,F$14,F$5,F$2,$C274,$D274,F$3,$B274,F$6,F$7,F$8,F$9, So my formula would look like: XFGetCell($A$1, F$10,F$11,F$12,F$13) Unfortunately the function put double quotes around the cell so i get the whole string as my DisplayNoDataAsZero parameter and the next few down, missing many parameters (see picture be

We are having an issue with many of our Data Adapters. The Results Table Name continues to return as "SICResults".  They are using a DataSet BR.  Not all of them have this issue, even though others are using the same DBConn Connection.This does not happen when using the External SQL ConnectionThis is an issue when we try using 2 adapters on the same Report Component.We cannot have 2 data sources with the same name. Of the 4 ways to change this name:1) Place the table name in the call of a New DataTable()2) Use the TableName property after a new DataTable is made3) Name the query result "Select .......... AS TableName"4) Use the Results Table Name within the data adapter. Our code has no reference to "SICResults" anywhere.  None of our code does.   We just upgrade to 9.2

Hi all,We encountered an issue with the ABS function in a GetDataCell formula. Our cube view has two rows: the first tagged to account A#100, and the second with the formula GetDataCell(ABS(CVR(Row1))). The data displays correctly in the data explorer, but when using ‘Show Report’ or ‘Export to Excel,’ both rows show the absolute value of the original amount, which is not the expected output. An example is provided belowData explorer view (correct amount)Row NameMember FilterOutputRow1A#100$ -1,000ABS_Row1GetDataCell(ABS(CVR(Row1))$ 1,000 Show Report/Export to Excel view (incorrect amount)Row NameMember FilterOutputRow1A#100$ 1,000ABS_Row1GetDataCell(ABS(CVR(Row1))$ 1,000 Does anyone know whether this is an issue in OneStream? Thank you.Best,Jacky

Hello, Since when are Form templates no longer allowed to include a dot (.) or a hyphen (-)? We built our naming convention using dots, and it is now unusable under these restrictions. Please confirm when this change was introduced and what alternative naming format you recommend. Best regards,  

Hi, is there syntax similar to forms to load journals into multiple wf periods?My WF is 1 period, 12 months:I tried using similar syntax to form loads:Template set up as monthly:And I return no messages when I load. Confirmed xfj range is set up on file and all dimensions match. Thinking maybe its my "Time" thats preventing the journal from getting into the system and want to confirm I have valid syntax.Maybe the other option is to set Workflow Time to 2026M1 and make individual journals for each period:Is it possible to do all months in 1 journal?

Is there a way to change the color font in the Quickview POV pane?  User is saying the grey font in column/row dimensions is too faint to read, see below screenshot:    

Hi, We have moved to v9, and the previously used IC matching methods are giving us issues. For this we have a ticket open with support, and they have pointed us towards ONC. We use something very similar to the intercompany all plugs, but then supressing any combinations that are matching. Is there a way to filter the IntercompanyDetailAllPlugAccountsGridView_ONC to suppress the matches? It seems to be working in our development environment, but would be great if we can supress the matches as this is something that will be required. We have tried this:  {WS}{GetIntercompanyDetailAllPlugAccountsGridView}{View = |!Members_View_Numeric_ONC!|, SuppressMatches=True} But that does not seem to work. With kind regards, Tim

Hello,Is there a way to pass a combo box paramater into a cube view service? I think would be through the Service Factory.Since the cube view service runs when the cube view is executed and there is no call as XFBRs or Dashboard extenders, Is there a way to pass parameter values into the cube view service business rule? 

Hi All, When opening a cube view via OS Genesis cube view tree view, the content block can take a while to open. Even though there is no data, it is a simple cube view PnL. Opening it via cube view or dashboard takes only 2 seconds with data.Is there a way to improve the performance of the cube view tree view content? Appreciate your help on this.  

Hi everyone,In a dashboard that I'm developing I have multiple dashboards embedded into one another.Within one of the embedded dashboards I have a button that is associated to a dashbaord extender rule. When the button is clicked, I need the rule to retrieve the name of the dashboard that is currently the container of the embedded dashboard where the button is placed (see scheme below)Primary dashboard               Embedded 1                              Embedded 2                                             Embedded 3                                                  -> buttonI see there are two  rules (args.PrimaryDashboard and

Does anyone know how to change the time zone used in OneStream Dashboards from UTC to a different time zone (e.g., Eastern Time)?We’re implementing for a client based in Eastern Time, and we’d like dashboard times to reflect that for end users. Any guidance or recommended approaches would be appreciated. Thanks!

Hellou! Can we configure a single Quick View to show different languages (Spanish, English, and Portuguese) in Excel? I'm looking for a way to switch the aliases or member descriptions dynamically. Thanks in advance

I have a client who is trying to save an offline version of some of their excel reports in order to share them with their auditors.First they open the spreadsheet, refresh the workbook, then select the "Save Offline Copy" feature from the OneStream ribbon bar.Second, they close the original spreadsheet, then attempt to open the "offline" version.  What appears is a series of #VALUE! where there should have been offline data.Has anyone else out there encountered this?  Is it a known bug?  Is there any type of work-around?  The client does not want to use excel's copy-paste value feature because there are excel (non-OneStream) formulas such as "SUM" that they want to preserve.Any ideas, suggestions, or information would be much appreciated.Thank you,

Bi-viewer appears to be limited on font size and type in version 8.5. So, what I've done is created anpng file through paint and chose the Load option in my Title in my bi-viewer to work around the original legend that is too small. What this allows me to do is have the font whatever size I want and I can make my legend line up with my bar chart. Looks beautiful on the client, but as always, the browser requires something "special". Is there anyway that I can use this thought pattern to make it appear on the browser. The Load function only looks at my cdrive which will not work on the browser. I tried uploading it to Data Explorer to get it on Onestream and then using that url in my image, then attaching my image to the same dashboard where my bi-viewer runs but it doesn't embed it into my chart so browser doesn't like that either. Regardkess if what I try, I just get the picture icon where my Title should be. Any ideas? ....even if it's something I've not mentioned here? Thanks ahead

Hi, I am trying to reference a file location using an xfbr string in a image component.When the image component is configured like this:File Source Type - Workspace FileUrl or Full File Name - <FileName.png>This works to reference the other workspace.However when I use an XFBR String Service to return the exact same <FileName.png> it does nothing.I have also tried <Workspace.FileName.png> & <Workspace.MaintenanceUnit.FileName.png> without luck. The idea is to conditionally return different image files. 

Hello OneStream experts: Thank all of you for the dedicate helps. I build onestream quick view using excel. It seems all the functions in my quick view is working except the consolidate button is always greyed out not matter how I change my POV. I would like to use my quick view to consolidate data to the parent entities. But I can only do calculate and Translate, not Consolidate with quick view in Excel.  I would really appreciate that someone may tell me how to do consolidate with my excel quick view. Thank you in advance.

We havre an issue running Onestream Addin with BPC and Hyperion addin at the same time.any solution on this issue?Thank you 

I have built a OS data adapter off of a cube view that has a parameter that prompts for entity.  I subsequently built PowerBI query to pull data via this data adapter.  I can get the PowerBI query to pull data if I hardcode the Entity parameter value in the Custom Subst Vars in PowerBI.  What I would like to do is replace hardcoding the Entity value with list prompt for the user.  That will let the user decide which entity they want to pull when they refresh the query.  Any ideas on how to create this functionality? #PowerBI  

Hi, this might be an easy one, but I haven't worked with Report components before. I have a Report component which is used in a dashboard. All working fine except that I would like the rows to be ordered based on the values on one of the columns. In the example below, I would like to order the rows based on the Lease Start Date. I have tried updating the data adapter that is assigned to the report, but the ordering of rows in the data adapter seems to be ignored by the Report, so that must be something in the Report overriding the rows order.Any suggestion is appreciated.