Recent Discussions
Format Cube View based on third Header Override expansion
I am using header overrides on my columns to create three column expansion levels. I need to add conditional formatting based upon the header display text of "HPU" in this third expansion so that only sections with "HPU" in the header are set to three decimal places. I do not want to build every HPU column separate from the others, as this would require the build of 108 columns, instead of 12 columns. The system will not let me call that third expansion level in my conditional formula. Any help would be greatly appreciated!In Sheet Action Buttons Disappearing/Greyed Out
Good afternoon, I was wondering if anyone has had the issue of In-Sheet Action Buttons turning grey and not working within the excel add in. The environment is 8.5.1, using the 64 bit version of excel, and has the updated excel add in. When using the in sheet actions within the spreadsheet tool, there are no issues with the Buttons and the DM steps run as expected. When opening up in Excel, the first button is greyed out and does not initiate any tasks, while the green button still works. If anyone has any resolutions, I would appreciate it. Thanks, Ben
get partner currency in a cube view or FX formula?
hi all, good day; we are using plug accounts and IC matching accounts property, we see the IC matching report but I would like to know if it's possible to get the partner currency in a cube view or though a fx formula in Excel? I konw that this is a derivated data, but would like to know if its available on any dimension or fx formula Thanks in advance and kind Regards. Mario Guerrero
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.Dashboard MAP - Grouping Pinpoints
Hi, wondering if there's any way to group all the coordinates pin point on a map. Similar to this: I'm running a Dashboard Dataset Rule and using a Map Component within workspaces. The issue is that the location text gets jumbled when zoomed out: This is the excerpt of the code, but mainly lets it pinpoint the location on the map Dim pin As New XFMapPinPoint(LCLat, LCLong, MemberInfo.Member.Description, XFIMageFileSourceType.ClientImage, "StatusBlueBall", 0, 0, MemberInfo.Member.Name, XFImageFileSourceType.ClientImage, "StatusGreenCheckMark") 'MemberInfo.Member.Name 'MemberInfo.Member.Description collection.AddPinPoint(pin) End If Next Return Collection.CreateDataSet(si) End If Thank you! Carbon
If Statement in Report Book
I’m working on a loop over Entity.children and trying to implement a condition where, if a particular entity x is selected, then entities y and z should be excluded from the loop. I attempted to write an if statement to handle this, but it doesn’t seem to be working as expected. Here's the logic I tried to implement:
Execute Excel book and save excel file in shared folder
Hi everyone, I have a book having a simple CV with an Excel output. When the book is "processed and open", normally it opens an excel file in the local machine. Is there a way so that the output file is saved as an excel on a shared OS folder? Thank you. Best regards, CarlosApplication Reports & Parcel Service
Hi all, We have an interest in being able to provide the Map Changes Audit Report (out of the standard Application Reports dashboard) to a group of users via the Parcel Service function. I've been able to narrow down the application report itself to an "RPT" component but not sure where to go from there. Has anyone out there managed to set this up and if so, would you mind providing a high level view of the steps involved? Thanks very much in advance, KimOpen the Workflow Multi-Period Processing page from a dashboard button
Hi all, is there a way to open the "Workflow Multi-Period Processing" page from a dashboard button? we were able to open the pages for specific time (YYYYMM) and the different steps Import, forms, Adj. But what about the Multi-Period processing which is exeucted at the year level (e.g. 2025)? Which is the Workflow name to use in the Change POV and Workflow button POV Action? here is how we set the button Can anyone help? Thanks and regards MassimoMicrosoft excel is waiting for another application to complete an OLE action
Hi, We are transitioning over to OneStream version 9.0.1. As part of the transition, we are running validations on the data we have copied over from our previous environments. We are running reports like quickviews & XFGETCELLs to retrieve data. However, after clicking on Refresh Sheet/Workbook, we are prompted with the error message: Microsoft excel is waiting for another application to complete an OLE action Does anyone have a solution to this resolve this issue? This is holding us back with our validations, ultimately affecting our go-live date if this issue persists. We would not feel confident going live if this Microsoft Excel error continues to impact our user base from running their reports. For additional context: Microsoft Excel is 64-bit version Excel Add-in version 9.0.1 is installed. Tested on multiple reports along with recreating reports Tested with multiple users/devices
