Recent Discussions
Display Parameters of Embedded Cube View
OneStream Community, I am having difficulty applying visible parameters after embedding a Cube View in Excel. When I embed the Cube View and select "Use Display Value" the parameters appear but the parameter member list drop down is misaligned to the applicable parameter. Additionally, when the Cube View connection is removed and re-embedded without selecting "Use Display Value" on refresh the cube view shows an object reference error, but then after selecting ok the cube view will render with no issue. Has anyone come across this?
Create Excel Book
Hi, I am trying to create a OneStream Book that contains data in Excel format instead of PDF from a dashboard component. Currently, the book uses a dashboard report component to generate a .xfDoc.pdfBook containing the data, which Parcel Service then attaches to a list of emails and dispatches in a zipped folder. I attempted to create a book that retrieves the data from the same dashboard component but in .xfDoc.xlBook format. However, every time I run the Parcel Service to dispatch the file in Excel format, the Excel file is blank. Could you please advise if there is a way to obtain the same data in the Excel attachment as we have in the PDF attachment? Thank you
Quickview Template Formatting Error
I have created a quick view template file, but each time I launch it, the font gets changed to a light gray. This obviously makes it difficult to see and I need to reformat it afterwards. Here is a sample: My QV has "preserve excel formatting" enabled, so I am uncertain what is causing a formatting override. I have tried different primary styles, but it does not stop the format from overriding after closing and reloading the spreadsheet. Here are my options: Has anyone else experienced the same issue or have any insight into how I may fix it?
Round up cell value to integer for calculation
Hi All, I am trying to get a decimal value rounded up to integer for calculation (Not for display). The current cube view cell value is 0.75. I can make it displayed as 1. but, when I put it in GetDataCell function for division, it actually went back to use the value 0.75 to calculate the division. I tried using a dynamic calc with Math.ceiling function, not working. Please help. Thank you.Any way to zoom a Gantt View Component?
I have managed to build a Gantt View and the associated DataSet qute successfully. However, since I am looking at data that spans a few years, I'd really like to zoom the Gantt View in so that I can see the related tasks (spanning that time) without having to scroll a metre to the right..... There are no obvious Formatting options on the component itself, and the related objects only have the "ParameterValue" property which look vaguely useful, but I think that is only to pass info back with the DataSet once constructed, and not to pass any scaling/formatiing info to the Gantt View component. ChatGPT (don't judge me....) tells me that the underlying control (ComponentOne GanttView) has options aailable to set the zoom levels (e.g. TimeScaleUnit = "Year"), but these are not exposed to the object model or on the component, since I cannot create a GanttView object in the BR (as it's done by the component). I have looked in the Task Manager code and there is nothing that does any zooming - maybe it doesn't matter as Task Manager is really only looking over a month or so, so zooming is not an issue. Any thoughts/suggestions? Gantt View looks great, but if your time period extends much past 3 months then it's not really that useful as a component to display time-series events without an ability to zoom/compress the timescale on opening. The Zoom slider available in the GUI does not scale enough even as a manual option. (Is the object model accessible in more detail from Dynamic Dashboards? sameburn - you're my only hope...) SteveRefreshing an emailed spreadsheet
We just upgraded from 8.4 to 9.0, and almost certain before we could email a spreadsheet with XF functions and immediately refresh the spreadsheet with button in the ribbon when already logged in. Now the Refresh Sheet button is grayed out, and now you have to "save as" the spreadsheet then refresh because the spreadsheet is in "read only" mode. I'm trying to decide if it changed with the upgrade, or if one of the Preferences settings affect this, or if we are just not remembering correctly. Any ideas or are we just wrong?Try Not to Export Transparent Row to Excel
Hi All, in my dashboard, I have a row which I need to use value for a GetDataCell function in a different row. I made that row background and text all "Transparent" in report and Excel format. It is not showing in the dashboard, but it still got exported to Excel. What should I do so it won't be exported to Excel file? Please help. Thank you.
Cube Views - Nested Dimensions - Fill in all rows
Hi Everyone, I have received a request from the business regarding a cube view report where they wish all the rows to be populated with the dimension member. For example in the screenshot below, they would wish to see "Entity 1" populated for all the lines in the second column of Largest Clients. I am not sure if that is feasible unless someone has found a way. Thank you in advacne for your response. RegardsOneStream Power BI Connector - Optimal Performance
Hi All, Has anyone used the OneStream Power BI Connector to pull millions of records and found the fastest way to do it? I’ve been asked to use the .TreeDescendantsInclusive member expansion in the Get Cube Data function for a few dimension members, but this is making my query run very slowly. I was previously just using the .Base member expansion and could pull about 5 million rows in 20 minutes. To avoid the 2 million row limit, I created an M Query that loops through specific dimensions and splits the calls into smaller queries. This included several historical periods, and doing an incremental refresh for 1–2 periods didn’t take long. Here’s a screenshot of part of my new query using .TreeDescendantsInclusive. My issues now are: The queries eventually fail because one of them hits the 2 million row limit, because I cannot easily loop through some of the new expanded dimensions It takes an extremely long time to query and load data into their Power BI data model as I am now pulling an estimated 30 - 40 million rows at once Is there a way to optimize what I have so that it doesn't take a long time to query data, or is this just how the connector works? Thanks!
