Application Build

Can someone please explain to me how the "Alternate Currency for Display" UD property works in Onestream?I am looking options to translate balances to a Cost Center (UD) currency (which is different from Entity Local Currency) 

Hi ,A report book has been developed which gets downloaded as a Zip file  on a click on of a button on a Dashboard. The process is working flawlessly when I run the Dashboard via the Windows Client . When the same dashboard is accessed via the Browser UI , the file is not processed and it downloads a *.xfdoc.zipbook file which cannot be opened. Has anyone faced this issue ?  The client primarily wants to access the dashboards via the Browser so is there any kind of workaround that I can do? Thanks in Advance

Hi All, I'm working on a requirement where I need to create a report with 5 columns that needs to be added to workflow profile entities. following are the member filter configuration of each columns. col 1 -   

I just created a BI Blend table and when I open the file using a data adapter, I see the data unit and aggregation fields all have an extract column prefixed with "s" (i.e., sEntity, sScenario, sAccount, sUD1, etc.). What do these columns represent?  

I have this error when trying to launch OS v9 app. I have no issue launching another app that's on v7.4. It is not authentication issue, I can access via BUX. The error occur when I try ClickOnce. This has happened before, these tricks worked last few times, but not this time:1-Clear Cache: Windows + R -> rundll32 dfshim CleanOnlineAppCache 2-Delete folder 2.0 from C:\Users\USERNAME\AppData\Roaming\OneStream\Desktop3-Uninstall latest Microsoft updates.Anything else I should try? Thank you. Below is more error detail:  

Hello,I installed OS 9.0 on premise version recently and I am having the following error when I try to upload a file:You can find below the error details:Unable to load file.An error has occurred. BadRequest.User Interface Stack Trace:   at OneStream.Client.Api.FileExplorerServiceReference.FileExplorerServiceClient.UploadFileFromStream(XFFileTransferRequest request)   at OneStream.Client.Api.FileExplorerServiceReference.FileExplorerServiceClient.<>c__DisplayClass370_0.<BeginUploadFileFromStream>b__0()   at System.Threading.ExecutionContext.RunFromThreadPoolDispatchLoop(Thread threadPoolThread, ExecutionContext executionContext, ContextCallback callback, Object state)--- End of stack trace from previous location ---   at System.Threading.ExecutionContext.RunFromThreadPoolDispatchLoop(Thread threadPoolThread, ExecutionContext executionContext, ContextCallback callback, Object state)   at System.Threading.Tasks.Task.ExecuteWith

"Creation application Database" option is freezes in our cloud application and I've admin access. Is there any privileges I need to create app db?    

Hi, I wanted to ask about the OneStream guidelines for an acceptable proportion of zero cells. I remember reading something a few years back about a suggested maximum proportion, but I can't find that info now.I know it's important to minimize zero cells and that there are ways to do this, like using the RemoveZero command in formulas. I also get that the proportion of zero cells is just one part of the overall system performance.Could you share the specific proportion of zero cells to total cells that would typically trigger further investigation? Also, what threshold would indicate that I'm in the clear?I have one client with an existing implementation where zero cells make up about 20% of the total data cell count at the total entity level for Actual. Is that a reasonable proportion?Thanks

Hi all, Within our application, we have a requirement to be able to do restructurings. This means, on date A, a legal entity is owned by holding A, but on date B, it moves to a different holding company and is then consolidated under that holding company. Has anyone got this working, and if yes, could you share how? What I am running into right now: We can leverage org-by-period settings, but in that case for example opening balances become 0. Plus there is the complexity that you have to set the scenario consolidation view to Periodic, which brings challenges in rolling forward balances where there are no movements. This also means we cannot keep the consolidation setting to standard which means the performance is degrading significantly.  So the question is, did anyone get this scenario workign, and can you share how? This would be grately appreciated! With kind regards, Tim Vierhout

Hi, Is there any option to freeze column in cube views? one of our report has column called it as "Grand Total" so we want freeze this column.

Dear Users: I had just one user who was not able to get their instance of Excel Add-in 8.4 for various workbooks. However, if the very same workbook was emailed or shared with another users it worked just fine.  The main issue is that the user could not "REFRESH" the sheet. Eventually, the Excel add-in started to work.  Has anyone experienced this in the past?  What was the solution? This is the error message: Description: Object reference not set to an instance of an object. Error Time: 1/17/2025 5:49:51 PM Error Level: Error Tier: AppServer User: xxxxxx Application: OneStream_Prod App Server: vmPRD1int000001 App Server Version: 8.4.0.16413 App Server OS Version: Microsoft Windows NT

Managing Sold Entities Without Losing Consolidation Results.Hi Community,We’re looking to hear how others handle this in OneStream:When an entity is sold in a specific period (e.g., 2025M5), the requirement is to:✅ Retain its posted journal values in group consolidation❌ Prevent any further use of the entity (journals, data loads, forms)The challenge we've encountered is that setting In Use = False — even after journals are posted and consolidation has been run — can cause OneStream to drop that entity’s data from the group during future reconsolidation. This results in the loss of valid P&L impact from the sold entity.Our workaround:Keep In Use = True for the sold periodUse workflow locks and security restrictions to block future changesOnly set In Use = False once everything is finalized and locked💡 Feature Suggestion:It would be incredibly useful to have a system property or override flag that allows us to:Set In Use = False to fully disable the entity in the workflowStill reta

Hi all, Does anyone know if the standard OS security audit or application dashboard reports present a way to determine all of the objects within a OneStream application where a particular Security group is used?For example - let's say I have a grp called "E_WF_specialUsers" and I want to better understand where this group is used within my application (i.e. is it attached to the display group of certain user dimensions, or account members, or workflows, cube views, etc.). I can't seem to find anything that does this within OS but want to make sure I'm not missing something here. Thanks in advance, K.

Hi all,it's not clear to me the meaning of the Culture field in User's configuration.I thought that changing the culture (eg: from English to Italian) would change all the "core" labels of OneStream (I mean menu options, labels, etc...).Instead, looks like that everything keep on being presented in English.Is this right or my (local) installation is missing some package/configuration ? Thanks

Hi,through XFString I am able to get a string defined in the same Maintenance Unit (or in another MU of the same WS).Looks like is not possibile to grab the String from another WorkSpace, even if it's marked as "Shared".Am I right or am I missing a clue ? ThanksFabioG

Hi ,Good Day!I'm currently building a dashboard in OneStream that allows users to select all possible points of intersection for dimensions and their members. Once selected, they can click a button to export the data to a file share using a Data Management export sequence. This part is working well, and the dashboard is complete.Now, I want to enhance it by capturing user details (who entered the data) and the timestamp of when the data was entered for each point of intersection. I'm wondering if there's an existing OneStream Marketplace solution or feature that supports this kind of tracking and logging.Has anyone implemented something similar or come across a solution that could help with this?Thanks in advance!

Trying to confirm if the spreadsheet tool in v8.5 is working for anyone in the following manner...Created dashboard with the spreadsheet tool.  The page renders fine...However, when doing something as simple as Save As, the following message is generated.Excel file is defined in the configuration.  One client mentioned this, so I tested this on another client with the same results.Heard this is fixed in v9.0.  Is this correct or am I missing something?Thanks for any input!Ed Puente

Hi Everyone, I know we can use culture settings to show users localized member descriptions, or XFStrings to change text in dashboards, but what defines the display language of the core UI? If I wanted the desktop or browser app's UI to render in another language (e.g. French for certain users), what options do I have? Thanks

Hi All,I am working on a Cash Flow Cube View to show the beginning cash, ending cash, and change in cash (activity) in three separate rows. All the base cash accounts are under the new parents (beginning cash, ending cash, and change in cash) in an alternate account hierarchy for the Cash Flow. We are using the BegBal_Dynamic flow member from the Blueprint app for beginning cash, EndBal for ending cash, and Activity_Calc for the change in cash. Figures are flowing in, but for these accounts the columns have a view member set to Periodic, QTD, and YTD. The problem is that figures are not representative of the View member, that is to say that they are all the same on the ending cash. Below is a screenshot and the Cell POV for each of the members. I am happy provide any other screenshots or additional information to get a resolution on this.Thanks in advance!MTD (Periodic):Cb#Batesville_Cons:E#LE_TOT:P#?:C#Local:S#Actual:T#2025M5:V#Periodic:A#End_Period:F#EndBal:O#Top:I#Top:U1#CC_TOT:U2#P

Hello everyone, I'm just wondering if there's a method or a way to delete ALL Data with a click of a button.I know about data management steps and the use of it along with the finance BR.So my concept and idea is that, I allow the user to select the member (step 1) or list of members (if step 1 is good). Then the user can click one button to delete all data. Why I want to do this is because let say the user want to delete a certain member, it will be easier for the user to do so.I tried to retrieve all the cubes that I have in the application and changing it via the scriptbuilder/databuffer method and setting the cell to 0 but the concept of DataUnit do not allow us to do so. Thus, I am here seeking for guidance and wisdom from the community. :)Thanks! 

When the Flow Processing Type "Is Alternate Input Currency for All Accounts" is enabled on a Flow member (as shown below Data Intersections become invalid for that Flow member and Foreign Currencies (USD, CAD).Entity BU_200 default currency is EUR. Note that when this property is not enabled the foreign currency cells are valid.My understanding is when this setting is enabled the foreign currency data cells should be enabled for data load or input. Appreciate any clarification on this.

 In the world of Enterprise Performance Management (EPM), clean and accurate dimensional mapping is essential for a reliable reporting process. Fortunately, OneStream makes this easier through its robust Transformation Rule framework, which intelligently handles new dimension members automatically.Whether it's a new GL account, cost center, or entity, OneStream’s transformation engine ensures that new data doesn’t derail your process, even before user intervention.🔍 Key BenefitsDynamic Member DetectionWhen a new source member enters the system—say, a newly created account in the ERP—OneStream flags it immediately as “Not Mapped” in the staging area. This provides the user or administrator with a clear indication that attention is required. Mapping can then be quickly added or adjusted to keep data flowing seamlessly.Centralized and Flexible MaintenanceTransformation rules support Wildcard and Dynamic Mapping, making it easy to set default routes for unknown members (e.g., directi

Hi Everyone, Is there any possibility not display Dimension icons in the cube view reporting?   

Hi Experts, I have a dynamic read only cube, source of this cube is a relational table having details like salary band, department, position, benefits %, tax %, etc. I am simulating some calculations in workspace assembly and setting records in the dynamic read only cube. I see expected data at base entity levels. How can I see correct data at the top entity level? Entity structure: I see same data at multiple levels. Asia and AllRegions data should not be same.  Also drill down results are same at multiple levels which is weird. So if we are setting data at base entities in a dynamic cube, how does consolidation work here? JackLacava​ , would you please clarify this?  

Hi all,I'm working on a Data Management to "Export Data", launching it from a Dashboard.Everything works fine, since filters (Cube, Entity, Account, Flow, etc) can be parametrized through Parameters.Is there a way to parametrized also the Options such as "Include Zeros", "Include Member Descriptions", etc ? I see that at UI level I can only choose between True and False, but I'd like to manage them from my dashboard.Thanks in AdvanceFabioG