How to merge column headers in Cube View 8.4 - MergeAndCenterColumnHeaders not working
Hi, I'm using OneStream 8.2 and trying to merge 3 column headers (Forecast, Budget, Var) under one "|!Entity_Selection!|" header. I've tried Setting MergeAndCenterColumnHeaders = True in Column properties The merged header is not appearing. Has anyone successfully merged column headers in version 8.4? What am I missing? Thanks! Output required:
Top-side Entries
I'm having an issue with specific top-side entries not being captured by cube views, dashboards, and even business rules. The entries were posted to the Adj workflow with entity member filter: E#Root.WfProfileEntities. Could it have something to do with the entity member filter assigned to the journals?
Genesis cannot start: "Value cannot be null."
Hi What to do when I get this error messages in Genesis: Unable to open dashboard 'OpenPlace_(Designer)'. Error processing DataSet 'GetWFSteps'. Error executing Workspace Assembly Service class 'Workspace.Gen.CubeViewCharts_x2x.MUAssemblyFactory'.Value cannot be null. (Parameter 'reader'). How to reset? The problem happens when working with Block: Cube View Charts. It will not read my cube view and give the following comment: Value cannot be null. An error messages that is difficult to work with, as it does not say where the problem is. But this second, as I cannot get into the genesis instance.Print to pdf - Gray/blue grid lines
How do we remove the gray/blue gridlines from the Excel export and when printing to PDF? The screenshots below have no formatting. The cube view exports directly to PDF with no gridlines, but when exporting to Excel and printing to PDF, the gridlines appear. Thanks.
Export Cube View to Report Format?
Does anyone know if there is an api to export a cubeview to a report format, similar to how BRApi.CubeViews.Process.ExportCubeViewGridsToExcelFile can be used to export a cubeview to Excel via code? I want to get rid of the menu options so users can not use the normal save button but instead a custom dashboard save button. However, I need to find a way to replicate the export options that will also be removed. Thanks.
Actuals Adjustment
How to Add Adjustments with Add Back Category and Free-Form Add Back Name to Actuals in OneStream? Hi Everyone, I’m working with Actuals data structured like the attached screenshot and want to add adjustments linked to this data. Key points: Adjustments must tie to Actuals by Company, Account, and Month Each adjustment includes: An Add Back Category An Add Back Name, which is free-form text and can vary monthly I want to maintain monthly detail and enable reporting and drill-down by both Add Back Category and Add Back Name My questions: What’s the best approach to model and load adjustments with both a Add Back Category and a free-form Add Back Name in OneStream? Should Add Back Name be a UD member with auto-create, a text attribute, or something else? How to avoid member explosion or reporting complexity given the free-form nature of Add Back Name? How can I ensure adjustments roll up correctly and maintain data integrity? Any recommendations for validation, governance, and reporting for this kind of adjustment detail? Thanks in advance for your insights!
Error exporting Cube View to Excel/PDF when using CVRC
Hi, I’ve created a cube view containing a Row Override GetDataCell CVRC formula that is throwing an error when exported to Excel or PDF. I believe it’s because I’m using CVRC which requires the use of an index which Excel/PDF don't know how to handle. I’ve tried simple GetDataCell formulas and they all export fine. I’ve read that this can happen when Excel doesn’t know how to handle the index but the formula doesn’t calculate without the index. Has anyone experienced this and how did you resolve it? Would it work if the calculation was done via business rule instead? Below are screenshots from the desktop app and Excel, as well as the row override formula
