07-06-2023 01:40 AM
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
07-06-2023 04:15 AM
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.
07-13-2023 12:59 AM
hi,
thanks for your reply. Yes, we've used cube views in extensible document but i'm specifically trying XFGETCELL to work.