Reporting

I have a cubeview with a header row returning no data for all my time period columns (correct) but returning (100.0)% for columns where I'm calculating percent variances. Is there a way to make those columns blank as well for my header row?   

Our two environments are currently on different OneStream versions. DEV is on 9.1.1 and PROD is 8.4.4. We have an upgrade scheduled to get them in sync soon.  However, currently facing a parameter resolving and passing issue while trying to migrate some functionality from DEV to PROD.  All setups are now equal between the two applications for the workspace that I moved over to PROD. However, I believe version 8.4.4 is having some trouble resolving parameters being passed to a button click that I have on the same dashboard. I have a button whose "Selection Changed Server Task" is set to "Execute Data Management Sequence" and "Selection Changed Server Task Arguments" is set to "{FilteredForecastRollforward_ButtonRan}{SelectedContracts=[|!param_SelectContracts!|]}".  Within 9.1.1 DEV this data management sequence runs no problem an receives the value of "Contract1" upon logging. However, in 8.4.4 PROD this parameter is not resolving properly and comes as "|!SelectedContract

Hi everyone, I’ve developed a report using Cube Views and noticed the following behavior with keyboard navigation: The Tab key moves right and then wraps to the next row The Arrow keys move in their respective directions and wrap at the boundaries When navigation reaches the end of the report, it continues by jumping back to the beginning and starts again from the top. Is there a way to stop this wrap-around behavior at the report boundaries?Is there any property setting to control or disable this? Thanks in advance,Archana

Dear community, I currently have an html document which is located in the file Explorer under "Documents/Public" folder. I am trying to get this HTML document to be presented into the components, embedded in a dashboard. However, with either a Web Content component or a File Viewer component (which will pinpoint to this specific file in Application Database File, as soon as I open the dashboard, it will load the html page into my default browser... I am using OS v8.1 ... is it a known bug or the expected behaviour ? What is even more strange, directing the Full File Name to a URL will correctly open a document in a dashboard ... Regards,

Hi everyone,I need to add a button to a dashboard to allow users to export to csv or txt some data from the staging area, specifically from dbo.vStageSourceAndTargetDataWithAttributesI tried multiple approaches using a dashboard extender but cannot find the right way to do that.Has anyone done that before and has any suggestion or best practice to do it (even without using a BR)?Thank you for the help!

Hi all,my client is loading in OS Actual data in MTD.I set up a cube view to show the actuals MTD month by month. If the user loads the first 3 months, the cv correctly shows the MTD for the first 3 months, but for the 4th month it shows the YTD with inverted sign:If I understand correctly, this setup should be configurable by intervening on the following WF Profile settings:I also changed the following setting in the scenario configuration:nevertheless, the cv keeps showing the inverted YTD in the new month.Can anyone explain why?Thank you!

Hi everyone, I'm curious if there is any information on how to use the dynamic parameters in the dynamic dashboard service. I've created a form is dynamically generated from a SQL query - essentially the query results contain the text I want to display next to the component, the type of component, the bound parameter for the component, etc. I also have a field for "list of values" that I'd like to use as the display and value items for the bound parameter for Combo Box components. Here's a screenshot of the table that holds this information: Right now when I generate the form, parameters bound to text boxes don't have to exist in the maintenance unit and I can use these parameters to collect data and save to a table I created on the database. For the combo box parameters, however, I currently have to create those in the maintenance unit. It feels like there should be a way I can fetch the display and value items based on my List of Values column for a dynamically generated parameter,

I'm building a cube view column that shows combined annotations from descendants. I'm calling an Finance Cell Service BR from inside GetDataCell so I can pass dashboard params needed for the logic. GetDataCell(T#|CVTime|:BR#[BRName=..., FunctionName=CombinedComment, Flux_ID = {fluxID}]:U8#{ud8}):Name({ud8} Combined). I need to the UD8 POV member because that distinguishes what type of comment it is (CMvsPM, CQvsPQ, CMvsPYM, Ect...). The BR returns a String, but GetDataCell expects a numeric amount so the text doesn't render in the cell. Pointing the column at V#Annotation doesn't help either.Has anyone gotten BR-returned text to display in a GetDataCell with full POV/param context? Thanks,Ben

The background fill color on the header is not filling the entire space when viewed in PDF. You can see on four of the six columns there is white space where the text is shorter. I need the teal color to fill to the bottom of the header space, and not just exist where the text is located. It works fine in excel and cube view. The issue only exists in report PDFs. Does anyone know of a way to accomplish this? Report/PDF: Excel:  Cube View: Here's an example of a PDF that looks good because the length of the header text is more comparable across the columns:   I'm sure there's a way to accomplish this through a Custom Report Formatting rule or formula. I'm trying to avoid this, as I feel the formatting should already default to what I want. But, if I have to go this route, I will. Thanks in advance!

Hello,  I currently have a cube where I am having an issue calculating variances.  The row has GetDataCell(CVR(Row1)+CVR(Row2)) and Column is has T#POV, T#POVPrior12, GetDatacell(T#Pov-T#POVPrior12).  When I run the report, the first two columns run correctly for T#POV and T#POVPriorYear, but the third column where the two get data cells meet does not calculate correctly. I can't get it to work on a column override either as I know there is a order of operation for the GetDataCell. I want to keep the report as dynamic as possible, is there a way this can be achieved without breaking the columns out and manually doing the overrides?

My team has recently been unable to save offline copies of Excel files that contain XFGetCells + CubeViews. Prior to this, we had no issues and had saved 100+ files offline as part of quarterly reporting. I have seen prior threads where this has been discussed some time ago, and our team has tried updating preferences, saved elsewhere, etc. with no luck. Is anyone else currently having this issue? 

We are trying to update a table in External DB using SQL table editor. But we are getting below error.  

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?

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! 

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.