Skip to main content
Newcomer
Jul 6, 2023 5:40 AM UTC

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

 

    2 replies

    OneStream Employee
    Jul 6, 2023 8:15 AM UTC

    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.

    prash4030Author
    Newcomer
    Jul 13, 2023 4:59 AM UTC

    hi, 

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