Excel Addin - Calculate
Hi, I am using OneStream version 8.2 and the Excel Add-In with a workbook that contains XFGetCell formulas. The workbook retrieves data successfully, and Refresh Workbook works as expected. However, the Calculate, Translate, and Consolidate buttons in the OneStream ribbon are disabled (grayed out). I am logged in successfully and can retrieve data through XFGetCell formulas, but I cannot perform any processing actions from Excel. Could anyone help me understand: What conditions must be met in OneStream 8.2 for the Calculate, Translate, and Consolidate buttons to become enabled? Is there any way to trigger Calculate, Translate, or Consolidate from Excel when working with XFGetCell-based templates? Thank you!
Updated Golfstream app?
Hi, is there a way to download an updated GolfStream version? I like to use it to reference different formulas, dashboards, features etc. but things break every time we upgrade our version....Rather than filing a ticket and modifying rules manually behind the scenes, I think it would be helpful to have an updated one issued by OneStream. I reviewed this forum and checked the Solution Exchange to no avail. Sometimes I just need help "getting started" with an idea that I've seen in a demo or solution and using Golfstream is a solid reference.
Read only option for cube views
Hi , We have DEV and PROD environment and we want users to have read-only option to cube views in PROD environment. If we restrict the cube view group maintenance, users could execute the cube view but not see how it defined. All options are greyed out like shown in below picture. Is it possible to have Read-only option for cube view in production?
MergeAndCenterColumnHeaders in Cube Views
Hi, Anyone on Version 8 who's actually tried to use this 'enhancement' feature in Cube Views? We requested this on Ideastream a long time ago with a lot of support. I can see this command is now available in the header format dialog; however, it would appear that the only thing it does is change the header from left justified to center view. There does not seem to be a way to actually 'merge' column headers, despite the fact that it's called "MergeAndCenter". Even the system documentation appears to confirm this behavior. Someone please tell me I'm missing something here and it actually is possible to merge column headers, because we really really wanted this feature. Thanks
Balance Sheet report: displaying two CubeViews in a two-column layout
Hi everyone, I'm building a Balance Sheet report in the Text Editor. For various reasons, I have two separate CubeViews: one for Assets and another for Liabilities & Equity. I've placed both CubeViews inside a table within the Text Editor (one per cell, side by side), trying to display them in the classic balance sheet layout — Assets on the left, Liabilities & Equity on the right. However, I'm having trouble getting them to render correctly next to each other. Has anyone done this before? Is a two-cell table in the Text Editor the right approach, or is there a better/recommended way to place two CubeViews side by side in a single report? Any tips or examples would be greatly appreciated. Thanks!
ShowCurrency=True in excel export?
Hi, I can figure out how to solve problem with cell format in column ShowCurrency=True (in Cube View) to work in Excel export? Any ideas how to fix this? I want to have it both in Excel and PDF export. In Excel formatting I cannot see any settings that I can use. Maybe some kind of combination in ExcelNumberFormat that can be used? Currency is depended on accounts etc. Thanks for your help, Pia
