Knowledge Base Article

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.

Answer There are numerous Enhancement Requests related to this: PF-385, PF-1309   Source: Office Hours 2020-10-08 Partner Enablement
Updated 2 years ago
Version 3.0
Office Hours
Sergey's avatar
Sergey
Icon for OneStream Employee rankOneStream Employee
7 months ago

Hello,

It is now possible to place buttons in Excel which can save and / or refresh the worksheet or workbook. It's called "in-sheet actions", as shown below :

Regards,