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's avatar
prash4030
New Contributor III
2 years ago

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 the output as paste special values. thank you

 

Excel Add In

2 Replies

  • Dominic_A's avatar
    Dominic_A
    Icon for OneStream Employee rankOneStream Employee
    2 years ago

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

  • prash4030's avatar
    prash4030
    New Contributor III
    2 years ago

    hi, 

    thanks for your reply. Yes, we've used cube views in extensible document but i'm specifically trying XFGETCELL to work. 

Related Content