After migrating from OneStream version 6.8 to 7.4, it looks like the Excel data groupings disappear after refresh.
Does anyone know if this is an issue with the Add-in itself or do OneStream/Quick view settings need to be changed? thank you
Has this issue been resolved with the 8.2 upgrade? We just upgraded to 8.2 and it seems it is still an issue
In the Quick View settings, at the top are two settings: "Insert or Delete Rows (Columns) When Resizing Cube View content". Try turning both to False and see if that fixes your issue.
OSS confirmed there is bug open on this issue: PF-28727 - Refresh quick view shows losing the existing grouping for rows and column Here are some potential workarounds you can try meanwhile: 1) Highlight the data section of the quick view and "convert to XFGetCells" for the data section in the excel add in, then refresh the file, the row and column will keep group format. 2) After creating the quick view in excel add in, create a new sheet and link to original QA. Apply the necessary formatting and grouping the new sheet.
i will have the user try these options. Your suggestion is good, but doesn't work - must be due to the bug.
Thank you
Hi BrittaniaH,
I've done a quick test on my version 8.2.0 and the groupings still disappear on refresh.
I've also had a look to the release notes of the 8.2.2 (and lower) and I could not find any reference to bug PF-28727 so I'd say this is still to be addressed.
