OneStream Platform Forums

What would be the ideal integration method to fetch approx. 100000 records in a single import  between OS and SAP(ECC and S4 HANA)? Any steps required to achieve the same would be highly appreciated. 

Hi, I have a Book that is not creating any data in Excel, it is supposed to loop through all entities. I know that there is data in the system that should populate the Book because I can retrieve single entities as CubeViews into Excel direct with their correct data. I have created other Book loop definitions this morning for other CubeViews and they have generated correctly, I even tried copying and renaming the variable elements from the ones I have created ( that do work ) but it will not export to Excel anything other than a blank tab for this particular CubeView. What else could be causing it to fail ?  Our "Loop" settings for ALL books is identical. The "If Statement" tab only varies by the account name ( copied and pasted so not incorrectly entered ). The "Change Parameters" tab is identical for ALL books. Finally the "Excel Export Item" tab has the cubeview name as "Name" and is connected in the CubeViewName field, output name is identical in ALL books. I have more complex

Dear community, I'm currently stuck with a cube view. My cube view have Projects (UD1) is first element of the row, then Cost Center (UD4) is second element of the row. The requirement is to show "Tot_CC" (UD4 dimension) when we are NOT in base level of project, but show base members of cost centers when we are in base member of project. I am using a CustomMemberList which should look at |MFUD1|, however the business rule is not parsing it, as the ErrorLog show me that the formula is looking for |MFUD1| and not the element which was specified in the first level of the row (see below). IS there another way to define conditional list of elements based on the first level ? Regards,

I'm trying to do a Composite Rule to Bypass an account if it's part of a specific Scenario?  Can you use Scenario as part of an Account Composite Rule?  This is my statement "A#[525300]:S#[Budget_Dist]" that isn't working.

Hello,The client would like to view forecasted, budgeted and PY data based on a ratio that takes into account current day of the month for Periodic and YTD data.Below, is a functioning calc. Use Case: it is October 22nd, and the client is using daily uploads for Sales. To get a more accurate view of the Sales compared to the scenarios listed above, they want to multiply the monthly total by the factor relative to the day of the month. E.g. if Sales is 100,000 for the October budget (periodic), but it is October 22nd, we would multiply (100,000 by (22/31)), the cube view would show 70,967.74. The calculation in a UD8 member above represents this logic.The tragic flaw is that if view the data in YTD view, it takes the entirety of the YTD amount by that ratio, when I only want the current month to apply the ratio. What would be the best way to approach this? Ideas:Use a ratio that uses total days of year up to end of current periodE.g. In October 22nd, 295 total days have p

We are attempting to upgrade the Financial Close Marketplace Solution from version PV640 SV100 to PV710 SV201. We are on platform version 7.2.4.  We have a group of SuperUsers (similar to an Admin role but with less access than an Admin) that should be able to access and execute batches for the Workflow Multi-Period Processing page. (screenshot attached). They can access the page, but the Execute Batch button is greyed not allowing them to execute any of the steps. They have this ability in the environments where the solution has not been upgraded yet.  I cannot find anywhere in the workflow profile or business rules where security is being referenced for this Execute Batch button.  Can anyone guide me in the right direction to allow them to have access to that button in the upgraded solution? 

Hi there - Im creating a Supply chain report and the first page (cubeview) is a very generic page but I wanted to add an image of some sorts. Any idea how to add an image in cubeviews? 

I am having XFGetCell formula cells in multiple workbooks (Sheets) within a Spreadsheet.Issue/Problem:When I tried to save a copy of this spreadsheet by selecting (OS Excel Add-in) OneStream/ Save Offline Copy, only the ACTIVE sheet saves an offline copy without the XFSetCell formula (as expected) but the other workbooks (sheets) still shows the XFSetCell formulas.I expected to see all the workbooks (sheets) to save without the XFSetCell formula (offline copy).Please can OneStream release an enhancement to save all the worksheets within a workbook to be saved as an Offline Copy i.e., without the XF() formula functions?

Spoiler (Highlight to read)  Hi everyone,I am trying to replicate an example that i have created in OneStream 8.2, where I have a combo box inside a cubeview:But when I do the same in OneStream 8.4, the combo box doesnt work:I replicated the same parameterization in both version but I dont understand why in 8.4 doesnt work.Does anybody knows if there is a bug? Thank you   

Hello!I have one of the users receiving the error "OneStream Excel AddIn Setup Wizard ended prematurely" while trying to install OneStream Excel Add-in. The user is an administrator on the laptop.Tried a few things like closing all Microsoft office applications, deleting the APPDATA folders, restarting the computer....nothing help!Anyone faced this issue or seen this error before? If so, what steps were taken to resolve it?Thanks,Hari

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.