Forum Discussion

Manju's avatar
Manju
New Contributor II
12 days ago

Excel Addin - Calculate

Hi, I am using OneStream version 8.2 and the Excel Add-In with a workbook that contains XFGetCell formulas. The workbook retrieves data successfully, and Refresh Workbook works as expected. However...
Cube View
Excel Add In
Reports
JJones's avatar
JJones
Icon for OneStream Employee rankOneStream Employee
6 days ago

XFGETCELL is a read-only retrieval function. It pulls data from OneStream's cube into Excel cells. It has no ability to write back to OneStream or execute server-side processes like a consolidation.  If you use a quick view to view the same data are you able to run the Consolidate/Translate/Calculate?  A Cube View connection would also provide the ability to execute a consolidation/calculation/Translation as long as the cube view is configured to allow consolidation.