OneStream Platform Forums

Hi, since I am used to set many of the programs I use during my working day to dark mode, I was wondering if it is possible to turn the dark mode on for OneStream, and if that's not possible, is it something OneStream plans to introduce in future? Thank you

Hi all, does anyone knows about the limits of using the Direct Load method? Like # of rows, memory, parallel loads, or something else. Thx for advance

We are currently producing and saving excel extracts of CV's into File Explorer using books/parcel service. We would like to connect PowerBI to OneStream to pick up these files from the OS managed server. Is this possible?

Where can we find snippets for OneStream C# Business rule ? I have searched on marketplace but did not find.

Hello,  I am new to OneStream. While adding dimension items below the root, it seems I may have inadvertently broken something. As a result, I am unable to view the dimensions—highlighted in yellow region below. Clicking ‘OK’ on the dialog shown in the screenshot did not restore access to those dimensions. I’m unsure how to rectify this or reset it back to normal. Appreciate any inputs on this. Thanks

I tested the following SQL in a data adapter, accessing a external table Select * FROM Table WHERE "Cost Center" = 'CC_11111111' ; Data returned here, data adapter worked fine. I am using a Business Rule, and can’t seem to get the BR to work if there is a space in the field name of the external table. '****WORKS****getExternalDataSql.AppendLine("Select * from TABLE Where PC = 'XXXX' " ) *****Error*****getExternalDataSql.AppendLine("Select * from TABLE Where [Cost Center] = 'CC_XXXXXXXX' " ) I have tried every combination single quote, quotes, brackets on the Cost Center field. Question: Will an external query work in a BR, where the table has spaces in the names ? Any help or advice will be appreciated.  Thanks  Tom

Business Rule

Hi all, In a case we'd like to have a CV with 3 columns using different intercompany groups (group 1, group 2, group 3), for a particular account (1 row). Do you know how this can be done? I could do a member list but this would show the detail of every I#(partner x) for all the combinations but I'd like to show only the totals of each IC group. Thank you. Best regards, Carlos 

When we attach a file to a Reconciliation, where is the file stored and how is it stored?  It it stored in the application database as a BLOB or on the application server in the file system?  Is it encrypted?

  Hello, I have created a "Data Copy" "Data Management Step" which copies base level entity data from one scenario to another. I am copying import, forms, and journals.  When I run the step I am receiving the following error: "Error processing Data Management Step 'DM Step Name'. Error processing Data Management Step 'DM Step Name'. Journal 'Journal Name' contains line items for entity 'Entity Name' which is not currently being processed." I reviewed the source journal entry and ensured that it was posted and that the entity calculation status was "OK". This error is only occuring in one period as well works fine when I copy other periods. When I review the journals in both periods they are identifcal other than the amounts.  Has anyone else come across this before?  Thank you!

I have the following in Rows: Trying to exclude one account Goodwill from OI_EX_O. Member Expansion 1 - Primary Dimension Type UD1 / Member Filter / GetDataCell(A#FINS57:U1#OI_EX_O - CVR(GoodwillImp)):Name(OIE_Operating).   Columns are shared. The calculation for Variance$ and Variance% is not working for this particular row:   Shared Columns:        

Hi all  What would be the best way to create an intersection of two hierarchies within the same UD? For example, assume these are Profit Centres in UD1.    I would like to be able to create a cube view where by I could choose a node from hierarchy 2 and it will display the members (and the relevant subtotals) using hierarchy 1. i.e. if you choose 2022 you get the following: Thanks, Mark

Is there any way we can disable load to cube. Any EventHandler Operation type I can use? to throw and error. on a specific WF? My Ultimate aim is just to see the Intercompany Matching Report on the profile which is visible only if Process step exist. 

This is a follow-up to my prior post about Parcel Service. Converted my excel worksheet to CV's and imbedded them in a Book.  That works great and I can pass parameters and burst without any issues.  In the Admin guide under the Book section it talks about adding a Report.  I added 4 Reports with Report Type = 'Dashboard Report' and 'Dashboard Chart' and selected the related Component Name.  There were two - One listed as a 'Large Data Pivot Grid' and one listed as 'Spreadsheet'.  When running the book, nothing gets created in the Excel workbook generated for these 4 new members. I thought I saw somewhere that you could use a book to generate output from a Table.  In the above, the spreadsheet has a 'Table View' imbedded that works fine in Excel or in the Dashboard.  The Large Data Pivot Grid also works in the Dashboard. Is my issue that it does not work with anything that is imbedded in Excel.  In writing this I went back and linked the Report t

Hello, I'm trying to sum up a calculated amount using Row Column Intersection and I cannot get it to work properly. I'm using Rows Override in order to sum up these calculated amounts (also using row override). So the Input Inventory Amount, I put some dummy info in and the calculated reserves are taking those amounts and multiplying it by those percentages (name override as UD8#None). So the amount in LC column should be 265LC, but I cannot get it to populate. Below is my row override formula. I've tried putting a row range but it comes up with an error message of Invalid calculation script. I don't want to make a new UD8, because I don't really know how to do that, so if it can be done with a CVRC, or a different formula, that would be great! Thanks, Will

Hi everyone, Thanks in advance for helping. I am new to tree views and trying to get a simple hierarchy (from the account dimension) to show as a tree view. Part of the structure is shown in the screenshot below: I'm using the following Dashboard Data Set Business Rule that I run using a data adapter linked to my tree view: If args.DataSetName.XFEqualsIgnoreCase("TreeView") 'Declare the account dimPK Dim DimPk As DimPk = BRApi.Finance.Dim.GetDimPk(si, "actAccount") 'Declare the parent ID + member Dim parentMbrId As Integer = BRApi.Finance.Members.GetMemberId(si, dimTypeId.Account, "CF_000000") Dim parentMbr As Member = BRApi.Finance.Members.GetMember(si, dimTypeId.Account, parentMbrId) 'Declare the child list of the parent Dim childList As List(Of Member) = BRApi.Finance.Members.GetChildren(si, DimPk, ParentMbrId) 'Dim the new XFTreeItem List + properties Dim treeChildren As New List(Of XFTreeItem) Dim textColour As String = XFColors.Black.Name Dim imageSource As String = X

Hi everyone, I wanted to reach out to the community to see if others have a slicker way of dealing with head office overlays…. Here’s how we are currently doing things: Sites/business units complete their year-end workflows as normal, importing their TBs and adding the usual supplementary data (eg. balance sheet roll-forwards, ageing analysis, statutory disclosures etc, etc). The site-level workflows are then certified and locked to prevent any changes being made. Consolidated numbers are then reviewed at a group level to see how it’s all looking. Following this the group tax team reviews the numbers and then decides on tax overlays and adjustments that they want to make. We deal with this by having a separate workflow set up called “Tax_Overlays”. This workflow has NO assigned entities but it has the “Can load to unrelated entities” property set to True so that any entities can be adjusted in this one workflow. (As a slight tangent, not really related to this question, but for complet

Hi, this cube view report would run quickly without issue on Onestream application but when referring to it from the cube views in Excel plug in, I receive this error. Why could it be? Thanks for your inputs.   

Hi, All Any insights or suggestions on how to resolve these obsolete functions after update (we are currently 7.4.2) would be greatly appreciated. Dashboard Extender: Public Overloads Function GetBusinessRules(si As SessionInfo, brType As BusinessRuleType) As List(Of BusinessRuleSummaryInfo)' is obsolete: 'This is a temporary function used by Marketplace Solutions for backwards compatibility with old XF versions. Please change your code to use supported functionality.'. Public Shared Overloads Sub SetCultureInfoForUserToThread(si As SessionInfo, thread As Thread)' is obsolete: 'This is a temporary function used by Marketplace Solutions for backwards compatibility with old XF versions. Please change your code to use supported functionality.'. Connector:  Access of shared member, constant member, enum member or nested type through an instance; qualifying expression will not be evaluated.   Thank you in advance! 

Relatively new to OS and trying to figure out what may be preventing me from pulling newly imported budget data into an excel report via XFGetCell. I've verified the data exists in OS using the dashboards.  Now I'm trying to compare the data from the Actual Scenario with the Budget data in Excel.  I'm able to pull the actual data without issue.  The Budget data, however is coming through as $0.  To troubleshoot I change just the scenario parameter in the formula from Budget to Actual and the Actual data pulls as expected.  So, I believe there must be a step I'm missing in the import to push it to wherever it gets grabbed by the GetCell formula. Hoping someone out there has an idea. TIA

Hi All, I need help to importing data to stage via excel template. There is some instruction given in Design Doc Loading Stage Data (mcoutput.com), but its confusing. Can someone confirm what I am doing is correct, please refer my excel template below:  

Hi Community,I was looking in SIC guide and over the community but I dont see find a simple question.- If we can have two SIC (Gateway Server) install into the same server that each will be point to different environment (e.g. one for Dev and one for Production different environment).Not sure if anyone has done that type of configuration or it might not be possible because of port conflicting?Thank you

Is there a way to format excel cell's = 0.000 when exported? It is possible with Cube View formatting if NumberFormat = N4, but I cannot figure out a way to format it the same when exporting the CV to excel. Any information is appreciated, thanks!

I am wondering if anyone has changed the precision of the FxRate?  It shouldn't be to hard.  What I am wondering is if changing it would cause other issues ?  

Hello, I'm creating a Custom table in OS true a business rule that retrieve data using Rest API. My source is an external Datalake from witch I want to load data to my cube. The probleme here, is when I compare data that I have in my Datalake with data that I have in my custome table I can't find the same number of Row 39200 (Datalake) vs 25000(Custom Table). Is there any default limitation in the number of rows that we can add to a custom table ? it is possible to increase it ? Thank you in advance, Yahya