Recent Discussions
Task Manager - Frequency not working
I have my task manager set up by Weeks: Therefore, I've been using Frequency ranges as 1-52 or 1,2,3 etc. as from the Task Manager guide. Let's say I want to make only 1 task group start on W1-W3. I input that into the task group and individual tasks but still it doesn't show up. However, if I don't put any frequency range, it shows up for all weeks I publish. I just want it to show up for 1 week. BCA #1 doesn't show up at all in any charts but BCA #2 shows up in all weeks published. I've also set up my Close Dates but it still doesn't work: Any pointers or tips? Thank youCurtis4 hours agoNew Contributor4Views0likes0CommentsCube View Time Out issue
Hello Team, I'm experiencing performance challenges with a CubeView that contains: 4 row dimensions (all using .base members) Multiple time period columns Dynamic calculations that are causing significant retrieval delays Current Challenge: The CubeView needs to be executed and its data exported externally, but the dynamic calculations are making the retrieval process extremely time-consuming. Attempted Solution: I've already tried converting the dynamic calculations to stored values using finance rules, but this approach has proven ineffective - it's still taking excessive time and not producing the desired results. Request: Could you suggest any alternative approaches or optimization strategies to improve the performance of this data retrieval and export process? Thank you for your assistance.MLN2 days agoNew Contributor27Views0likes2CommentsDisable dashboard for UX but run in desktop.
I have a dashboard that I want to run whenever I log into the desktop app, and it works just as expected, but it tries to run in the web browser UX and does not work right. How can I disable the dashboard from running in UX, but stay running for the desktop app?skyzak222 days agoNew Contributor10Views0likes0CommentsExcel XF() functions - problems with Save Offline Copy feature
All, Does anyone out there have users with massive (thousands of rows and dozens of columns) XFGetCell() workbooks that are seeing issues with the "Save Offline Copy" feature? (and yes, I know.. they should not be creating these massive workbooks in the first place - that's not what XF() is meant to do) Here are the symptoms we're having: Regardless of what the seconds setting is (and I'm not even sure this setting applies to anything other than CV connections or quick views) and for some of these users, it's set to the max allowable, the 'save offline copy' often just spins and spins and never completes or eventually the user just has to 'kill' Excel and try again. Happens at different times so no idea what server activity might be going on at the same time. Save Offline Copy appears to finish but the saved file now contains "#REFRESH" rather than the values Unable to keep Formatting (this has to be set to False) - loses things like superscript or subscript fonts. I have a feeling this has something to do with the built-in behavior with this addin that it wants to refresh everything before saving the offline copy and I suspect it doesn't get to finish that before the save starts to run, but I have no proof of this. Coupled with this is the fact that many of the cells containing the XF() function ALSO contain vlookup() functions which doesn't help I'm sure. We have raised a ticket with OS but it's hard to provide them with a replicated sample given the size of these workbooks. I'm just wondering if anyone else has seen this and what workarounds or resolutions you may have discovered and might be willing to share. Much thanks in advance for any tips.Solvedkmd2 days agoContributor II4.2KViews1like5CommentsXFGETCELL #REFRESH
Certain users aren't able to refresh sheet containing XFGETCELL. Only shows #REFRESH. In OneStream task activity, it shows that the task has failed with an error message "Summary: Error processing dimension. The item was not found. Dim, OneStream.Shared.Common.DimPk, 0, -1." This should not be related to access since I was able to refresh sheet using another profile with the same roles.bjornliow3 days agoNew Contributor III12Views1like0CommentsReport Books - Dashboard Chart
Hello, I have an automated report book and would like to expand the functionality to include charts (in addition to the existing cubeviews). I was able to add the chart, but I'm struggling with trying to control the formatting. I would like to modify the header and have the chart fill the page (too much white space). See below. Thanks! Is there a way to format the chart output, in particular I would like to enlarge the chart image and have it stretched across the page?CAIGuySeanF6 days agoContributor8Views0likes0CommentsGuided reporting
Dear all, Could you please advise why user doesn't see Guided reporting section in Dashboards (OnePlace). As administrator I see Guided reporting and user has been included in security group that can view reporting group and reports inside of this group in Guided reporting section.Irina7 days agoContributor10Views0likes0CommentsSave Offline Copy
I'm getting the below error message regarding location when trying to save a file with multiple XFGetCell formulas offline. I've updated my preferences that an earlier question showed as a solution and refreshed the workbook (again) before attempting to save...but am unable to save the file without the formulas. I've tried directly to my desktop, various folders, where downloads go.... I can't find an acceptable location. Any help would be appreciated.amwitmer7 days agoNew Contributor132Views0likes4CommentsUsing "ColumnDisplayType" property in grid view component
The ColumnDisplayType property has two options: WorkflowStatusImage & OneStreamClientImage. I am looking to leverage one of the two options, but have found minimal documentation on them. What I have found, is that the WorkFlowStatusImage is related to values in a Status column like "2" equals a green circle, "10" equals a red circle. This uses the XFClientImageTypes library. I am not sure how to leverage this library and populate my SQL table/grid view with one of these status images/icons. Any assistance is appreciated. I have the status column value equal to "2" or "10" but I can't get the icon/image to display on my grid view component.SolvedDRider7 days agoOneStream Employee38Views0likes1Comment