- OneStream Community
- Forums
- Reporting
- Refresh XFGETCELL excel sheet
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Refresh XFGETCELL excel sheet
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Labels:
-
Excel Add In
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Excel XF() functions - problems with Save Offline Copy feature in Reporting
- "Index was out of range" error in Reporting
- Error: Cannot determine the CubeRoot profile that Workflow Profile [...] belongs to. in Reporting
- OneStream Error Processing Dimension in Reporting
- Using Parameter in table view in Rules
