The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
prash4030
2 years agoNew Contributor III
Refresh XFGETCELL excel sheet
Hello, Is it possible to refresh XFGETCELL (excel report) automatically through OneStream and save report as offline? i was trying to achieve this by uploading excel report as .xfdoc.xlsx but i want...
Dominic_A
OneStream Employee
2 years agoI have not tried with XFGETCELL formulas.
I know of users with Cube Views in extensible documents to achieve this.
Some Report Books have a loop for e.g. [Member].ChildrenInclusive to have static snapshot reports over multiple tabs.
There could be a dashboard with a parametrized selection prior to the extract, where the selected member name can then be used to name the report.
Related Content
- 9 months ago
- 6 months ago
Re: Does OneStream have the capability to refresh Cube View connections within Excel workbooks via XFDoc or some other type of functionality? Goal is to schedule the refresh & distribution of an Excel workbook via the Book or other functionality, so that both CVs and XFGetCells can be used. Per our prior testing, when using an XFDoc.Xlsx file type, the XFDoc will refresh XFGetCells when retrieved. However, it does not refresh cube view connections embedded in the Excel XFDoc.
7 months ago