Reporting

Hi,I am working on the cubeview below, where I have 2 dynamic calc accounts. On some of the cells their value is greyed out. The dimension on column is UD4. Can somebody help me understand why some of the values are greyed out? Thank you  

Hi,A user is facing two issues with Excel add-in.  XFGetCell and XFSetCell formulas with XFGetMemmber Property are used (XFGetMember function only at the top of the page). There are 15 sheets in the Workbook page.Has anyone experienced issues described below?  What is the likely solution?  Is it V8.4.1 specific issue? Thanks in advance for any help/pointers.Two issues:(1) Retrieval formula dont work and have to keep refreshing the whole workbook/worksheet. When refresh one worksheet, the rest will went error. When refresh another sheet, previous sheet went error.(2) When trying to save an offline version of retrieval file but error keeps pop up as attached.

Hi Everyone, I recently developed Flux reports for my organization, I'm encountering following issues. When I type comment on the 'Comment' column, if the comments is of say 100 words, the red line which I marked in the screenshot keeps moving to the right. refer screenshot below. How can I fix this issue? I use, V#Annotation for Comment column.2. When multiple users, try to update the comments, the comment from the last save is only visible. Could you please advise how can i overcome this? thanks in advance  

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?    

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?

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.

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 - may

This is the note in the release note version 8.4. 'Use of Cube View Member Filter Where Clause with HasChildren=True is only supportedon dimensions assigned to the Default Scenario Type. (PF-21833)' Can someone point to where I can look to see if the dimension assigned to the Default Scenario Type? Trung    

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?

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.

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. Regards  

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 dimensionsIt takes an extremely long time to query and load data into their Power BI data model as I am now pulling an est

Hello fellow admins, I'm wondering if anyone out there has found a way to successfully include one of the Application Reports dashboards (the one I'm trying to grab is the "grp_PR_TransRuleChangeAudit_RPTA" dashboard). It's recognized but I'm getting a couple of strange parameters (like... height of report parameter).  No matter what I input in the parameters, it's not grabbing an actual report dashboard and just leaves a blank space.  I would really like to use the map audit dashboard in my guided reporting if I can. Would love to hear from anyone who has found a way to use these standard reports dashboards in this way. Thanks

Hello,Would it be possible to extract information from Task Manager to create a separate dashboard? Currently, I have tasks grouped in the following example: Task GroupTaskCategory 1Category 2Accounts ReceivableClose AR Module - KoreaKoreaAPACAccounts ReceivableClose AR Module - JapanJapanAPACAccounts ReceivableClose AR Module - ItalyItalyEMEAAccounts ReceivableClose AR Module - SpainSpainEMEAAccounts PayableClose AP Module - KoreaJapanAPACAccounts PayableClose AP Module - JapanKoreaAPAC Currently, the OOB dashboard in Task Manager only allows view of single filter. This will take time for users to update the filter for each of the region/country. We are looking to have a dashboard which show the progress at Global level but also has the flexibility to further drill down to region and country level progress % by the task group. The dashboard should be able to show the progress of multiple countries/regions in a single view for quick reference, instead of manually updating category filt

Sceanrio and Time parameter are missing in report in v9 where as i can see them in v7.4 for same dashboard. does anyone had this issue in v9? 

Hi all, Not sure if I'm in the right spot to post this question but here goes. I recently downloaded a word document off the OneStream site (I think from Knowledge Base) called "Optimizing Excel for Quick Views and XFGETCELL()". In that document there was a recommendation to change the default value from 2 to 4 in the Environment / Configuration Tab/ MultithreadingSettings property / "NumThreadsForGetDataCells" and "NumThreadsForSetDataCells".Has anyone else tried this yet and did you realize any performance improvement in large Excel XFGETCELL() workbooks?On a related note, does anyone have any other recommendations for optimization of Excel beyond the usual that has been presented here (i.e. Manual Calculation = on, Various preference settings, Refreshing in the Spreadsheet tool instead of in Excel, etc. etc.). I feel like we've tried everything suggested at this point, except for the NumThreadsForGetDataCells configuration. Thanks in advance for any advice.

Hi All, I have the following use case whereby in my parameter, I have a member list of C#Local,C#USD,C#JPY,C#|WFText2| whereby WFText2 will be currencies/consolidation members eg. CNY,EUR,SGD,USD,JPYIs there a way to filter the member list to remove duplicates such that if WFText2 is USD, the memberlist will return C#Local,C#USD,C#JPY instead of C#Local,C#USD,C#JPY,C#USDAny help is appreciated, thanks! 

Has anyone ever come accross and issue where you've built out a quick view in excel to either faciliate reporting or to input values into a planning scenario and you open the workbook to refresh the quick views and they are all #refresh with the links broken?  The quickview POV is greyed out as if its no longer there. I've tried refreshing the page, workbook/closed excel and restarted... Any solutions or troubleshooting would be appreciated!!!!

Good morning/afternoon/evening to you, I currently have a Report Component that is setup into 3 columns.The right column has 7 text boxes, with the gap being equal. The properties doesn't have any padding on it:         However, when I run the report preview, there is a gap                  

Hi,  Does anyone have a solution to see calculations (sum, avg, count) when cube view cells are selected? This is similar to Excel where the calculations on the selections on rendered on the page on the bottom right.

Hello OS Community, We are building Power BI dashboards using the new Power BI connector for OneStream. We can successfully retrieve OneStream data through the connector in Power BI Desktop. However, after publishing the .pbix file to the Power BI Service, we are unable to refresh or schedule a refresh from the service. We reached out to Microsoft, and they indicated that this is a third-party connector (Power Query OneStream connector - Power Query | Microsoft Learn) and redirected us back to OneStream. We also contacted OneStream support but have not been able to resolve the issue. I’m curious if anyone has had a similar experience and found a resolution. Below is the error we received: "Unable to update connection credentials. Failed to login with OAuth token, please update the credential manually and retry.Details: [DataSource.Error] Unable to connect to the remote server Please have this information handy if you choose to create a support ticket. Session Id: 0bd10fb7-cdd7-451

Hi everyone,I was wondering if anyone knows a way to open a table as a spreadsheet in a dashboard, allowing the user to create, remove, and edit the rows as a traditional spreadsheet.I already use the SQL table editor for updating tables, but it's not very user friendly, especially when the user has to add many rows.Any help is appreaciated!

 

Dear community,When opening a cube view in PDF, the row height isn't automatically equal to the row header height. As a result, the color in background within the cells isn't extended properly:    A workaround is to set a row height, but the problem becomes when we have an header description that would be bigger. How do you handle this at your customers please?Thanks,Florence

I am creating a cube view.  Currently, it is showing monthly view and annual total for Workflow year, but future years (2027 and 2028) are not showing annual total only. What should change to show both monthly breakdown and annual total for outer years (2027 and 2028)? T#|WFYear|.Months, T#|WFYear|, XFBR(Year_ParmSelect, SelectYearsRPT, YearsReport = |!ProcessYears!|, CurrScenario = |WFScenario|, wfYear= |WFYear|)