OneStream Platform Forums

I trying to bind a combo box with bound list type parameter. The bound list parameter is using Command Type - Method and Method Type - Business Rule please see below screen shots. When I test the parameter it is showing results but combo box is not loading values on dashboard. Any help is appreciated. Sorry not able to attach images.

Hi All, We have alert configuration if a workflow step failed. Similarly, can we configure alert IF DM sequence failed? -Asish

Hi,I need help implementing conditional visibility for a button in my dashboard. In the attached image, there's a Store button that I'd like to make visible only when the "Single Store" option is selected in the Store Hierarchy combo box. When any other option (e.g., "All Stores," "Takeovers2024FY," etc.) is selected, the button should either disappear or have a different style to appear disabled.Can anyone guide me on how to achieve this behavior?Thanks in advance! 

Dear Community Members,I have a spreadsheet rule in my own workspace assembly.The workspace is set to 'shareable'.But the BR does not show up when i try to add in Table View DefinitionWhen i define a rule outside of my Workspace in the regular Business Rule section my spreadsheet rule shows up.Did I miss a setting somewhere to tell Spreadsheet to look into Workspaces?Thanks in advance    

I have  a Summary & Detailed Account dimension. The Detailed Account dimension extends from Summary dimension.Ex   Account DimensionCash  Summary A Detailed B Detailed C DetailedI have a Cube where I have set the Cube dimension Properties of a Scenario to use the Summary Account dimension. I was able to load the data at Cash account level as shown above.However when I retrieve the data with BalSheet.Base , OS still treats A,B,C as base member instead of Cash and show up no balances. When I specifically identify A#Cash I get the balances I loaded.Is this expected behavior that OS doesn't treat "Cash" as Base member from Summary Account Dimension? If so is there a solution to retrieve the Cash account as Base.ThanksManoj   

Hi OneStream Community,  Does anyone know why an import would add two rows in the load step with an excel import? In the import processing log shows only 1 line read but it adds 2 rows. (edited) Thank you,Sharon

When attempting to upload a form input excel template with around 3,500 lines of data, the system throws the following error - "Unable to load file <filename>. The size necessary to buffer the XML content exceeded the buffer quota". However, when I reduce the number of lines, the file uploads successfully. Does anyone know if there is a row limit for form input Excel templates, or if there's a configuration change that can resolve this error?

Hello,       We have a View Selection screen with users selecting the columns and the order they want to see as we have a  total of 136 columns to choose from.  This should happen on the 1st tab of the Dashboard. On the 2md tab the sql table editor has to show those columns and the order in which it has been chosen. Any insights on this would be appreciated.    Thank You, Indu

Hi all,Hope you are doing well. Can someone help me with hint or approach to see account hierarchies side-by-side. Thanks 

Hi OneStream Community,During a UAT phase, one of our client’s users encountered an unusual error. When this user attempts to export either a CubeView or Dashboard using the "Export to Excel" button, a text file is generated instead of the expected Excel (.xlsx) file (see attached image). This text file is unusable.Interestingly, this issue only affects this particular user, while all other users are able to export successfully to .xlsx without any problems.As a temporary workaround, we’ve had the user export through the "Report" functionality, which provides the correct .xlsx output. However, this is not a sustainable long-term solution.Has anyone experienced a similar issue or know the root cause and how to resolve it?Thank you in advance for your support! 

Hi All - I have the below rule, which calculating 30% on NI and Copying it to the InvestmentinSub account from one entity to another. The rule is executing without any issues, but data is not copying to the target entity. Any Help would be appreciated.  I was able to see the correct value in the log Buffer, but the data is not writing to the DB.     Select Case api.FunctionType Case Is = FinanceFunctionType.Calculate 'api.Data.Calculate("A#Profit = A#Sales - A#Costs") Dim resultDataBuffer As DataBuffer = New DataBuffer() 'Data will be written to the Destination. Dim destinationInfo As ExpressionDestinationInfo = api.Data.GetExpressionDestinationInfo("") 'Consol Member Dim parentCurrencyName As String = "Local" 'Source Data POV Dim sourcePOV As String = "V#YTD:C#" & parentCurrencyName & ":F#EndBalInput:O#Top:U1#No_CostCenter:U2#10:U3#No_Projects:U5#OracleDataLoad:U8#No_UD8" 'Filter for BalanceSheet Accounts which has text1 as Investments. Dim filter

Hi All, Has anyone integrated Azure data warehouse into OneStream kindly walk me through the process. How are databases integrated into OneStream  need help ASAP

Greetings OS Integrators, Going with v8 and SIC for integrations, it is not an option to have 3. party assemblies added to the cloud environment. I am building a integration to push data from OS to an Azure Blob Storage location, and in this case I want to use some of the nice nuget packages (assemblies) that provides an easy way to do this, hereby authentication. I therefore want to use the following assemblies for my solution, that will run on SIC as a Smart function: Azure.Storage.Blobs Azure.Storage.Common Azure.Identity Azure.Core As such, I am able to compile my Smart Function against an existing SIC gateway, and able to call the function from within OneStream. But, issues lies in required other dependencies within my code-logic. So my questions are: Are Smart Functions compiled against .NET framework 4.8? Looking at the assemblies already available within the SIC folder, I can see that both Azure.Core and Azure.Identity are there. Can I reference those by just using an import

Hi, Is it possible to create member filter in QV using Text1 that varies by Year and Scenario. Is it dynamic enough to read T# and S# of POV and use them to get Text1?  For example, I have few members with "AAA" in 2024 and "BBB" in 2025.  In other members, "BBB" is in2024, and "AAA" in 2025. I want to pull all UD2 members that have "BBB" in 2025. If this doesn't work, other way is BR "CustomMemberList" I guess. Anyone has sample code that can create list by reading Text1 in 2025? Thank you in advance, Mikki

I am trying to build a rule to copy data from one year/Forecast Scenario to another e.g Long term and have req to copy data to derived cell value but dont want data to be enable for input.Is there way to copy data? I tried DM job and Custom finance rule but it did not work.    

Hi everyone,   I'm having issues when launching the consolidation process after loading data on the cube. Below you can see the calculation that is triggered when the consolidation process is launched:   api.Data.ClearCalculatedData(True, False, False,"A#2A900A01","F#CHI","I#None") api.Data.Calculate("A#2A900A01:U1#None:U3#None:U5#None:I#None:F#CHI=A#3ABCDEF0:U1#TotProduct:U3#TotMarket:U5#TotCostCenter:I#Top:F#None") The 3ABCDEF0 account is the top node of the PL account hierarchy, and the intersection is correctly populated. The 2A900A01 is the balance sheet account that should be populated as a result of the consolidation process, nevertheless it doesn't get populated. I have already verified the intersections, and they are correct. Does anyone have any suggestion on why the 2A900A01 account does not get populated? I know the question is a bit vague but I'm really struggling to understand what the issue might be Thanks in advance for any help!

Hi, All I have a column in a cube view for which I need to get the time description prefaced by "YTD". This was no problem for the current period as I could use a variable "wfTimeDesc" as follows: T#WF:Name(YTD |wfTimeDesc|) However, when trying it for a prior period, I couldn't find a variable to use that gave me a description.  This is close, as it returns "YTD M9 2023" but what I really need is "YTD Sep 2023": T#PeriodPrior12(|WFTime|):Name(YTD |WFSubPeriod| |WFYearPrior|) I know I could add a header row and put it underneath, but this was the request, if I can do it. Thanks in advance!    

I am getting error "Unable to access database table 'ABC'. Database table 'ABC' does not exist". If we create a table with extensibility. Does it solve the problem?

I am trying to post an adjustment to OwnerPostAdj member using FinanceFunctionType.Calcture function, is it possible to do that. If so could you please share some reference or if there are any cube level setting that I need to make. Currently I am getting the following error, even if I specify the OwnerPostAdj as a part of my data unit, but same works fine for Local member: 

We see some ghosted elimination amount stuck at parent level and they keep getting carried forward to the rest of periods. The elim amounts are greyed out, but still get aggregated up along the entity rollup. Is there a way to stop the ghosted elim amount?  We copied the actual data from Actual scenario to Fcst Scenario.  Actual scenario is fine, but Fcst scenario has this ghosted elim amount issue.  Is there any setting which triggered this?

Hi, I am creating a report for our auditors that takes the IC accounts and their elimination "Plug" account throughout the Origin dimension. I don't want to create a bunch of separate reports for AP/AR, Sales/COGS, IC Expense, etc. My thought is to define these in a Parameter and then build a book. Can anyone point me to a good starting point on how to define these 4 different drop down options? For example, the AP/AR one would include A#19999, A#29999, and A#IC_DIFF, and the report user would select AP_AR_DIFF or something like that. Any insight is appreciated - the forum has been very helpful! Thank you!

hi Team, good day; it is possible to block the file upload in the Data Attachemnt cell? theusers need to type an explanation, not just upload a file. Please let me know if it is possible. thanks in advance. Regards Mario G

Hello All, Anyone knows how we can achieve Consolidation- NCI, Equity pick up, GW calculation in OneStream?

Just wondering if anyone out there has figured out a way to report the attributes/properties of a Workflow profile.  What I'm actually trying to do as part of a security overhaul is determine WHERE a particular security group is actually being used.I am using the XFGetMemberProperty() function to pull security for all of my dimension members but I need a solution to pull the security groups used in each of our FPA workflows.There is no built in security dashboard report to provide this and the best advice I've received so far is to download the application and search for the security groups there.  That's one way, but we literally have dozens of security groups set up so it'll be a long and manual effort.Would love to hear from anyone who's found a better way to do this.  Thanks

Dear Community,Can we have common column header for multiple columns. For example, we have same entity name for different columns, and we want to merge and center those column headers for multiple columns. Below is the attached cube view and desired output image.Desired Output:Any solution to this will be very helpful and thankful.