Quick View POV - Dragging Blocked second screen
When using a second display monitor connected to my laptop the Drag and Drop of dimensions in Spreadsheet Quickviews does not work - when I place the Onestream applicatrion page on this second monitor. if i switch back to having the OneStream application QV on my laptop screen - i have full functonality on moving dimensions into columns or rows in Qv's Any similiar exeriences with this ? ( audio/visual setting on second displays)?) best regards Chris
Cube View Connection Issue with Preserve Excel Format
Hello, On version 8.5 (could be earlier, but didn't have a need to try) I am trying to create an embedded cube view that retains excel formatting. When I check mark the preserve excel format this works, BUT when I save the report, close it, and reopen it the cube view itself stays a light font vs black. Once I uncheck preserve excel format it reverts back to the expected black font cube view.....Is this a known issue or a way around it?Upload data to OneStream with Excel add-inn
Hi all, I am trying to upload data to the text field Text3 in a UD2 dimension. I have been looking around in the available functions in the OneStream excel add-in, but I am not sure which one is the best for this. I tried the function XFSetCell, however this function saves data to the amount field based on the Parameters supplied. I only need to upload a string of text to the Text 3 field of a UD2 member: Thank you all for your help!
XFGETCELL() with Drilldown - V8
Hi all, I'm 100% certain that I read somewhere that Version 8 would include a new XF function for Excel add-in that would allow us to drilldown on a cell whose data is retrieved via an XF function. However, now that we are upgrading to Version 8, I cannot find any information about that at all. Even a search in the OneStream documentation does not show any XF function that allows this. If anyone has a link or more details about this expanded functionality, would you be kind enough to share that here? Thanks in advance
Excel addin formulas (XFGETCELL) impacted by POV
Hi everyone, we come across an issue with the excel addin formula (XFGETCELL). Although all dimensions are specified in the formula, the result gets impacted by the settings of the Cube POV. Sometimes no values get retrieved, sometimes all cells with formulas show #Name or #Value. Uur expectation is that whatever is set in die Cube POV, the XFGETCELL formula retrieves the data based on the dimensions used in the formula. Does anyone of you have this issue as well? To my mind this is a bug in the excel addin. Regards MartinHeaders in center of excel
Hello, I know you can center columns in a report, but is there a way to do this for cube views exporting to excel? I've only found a workaround where you go to export it to report and then change it to excel, but this won't work for us longterm. Would like to be able to do this - ok with either embedded or just exporting.
