11-07-2022 10:02 AM - last edited on 11-21-2022 11:49 AM by JackLacava
Would it be possible to run a Dashboard or Cube View using a Data Management job, and store the results as Excel and not as a PDF.
Appreciate any suggestion in the right direction.
11-09-2022 07:11 AM
It wouldn't make sense to export an interactive Dashboard (with buttons, popups...) to an Excel file, PDF is a better visual approximation. But beyond that...
What you really want to do is actually exporting data to Excel in Data Management. You can achieve that with an Export Data step (which saves to csv, that Excel is happy to open); but if you really want to pull a Cube View, you can write an Extensibility Business Rule that will call FdxExecuteCubeView or FdxExecuteCubeViewTimePivot to extract the relevant records.
11-10-2022 07:12 AM
Hello Jack, thanks for the response and for your time. The business rules would it be possible to provice a copy or is that something to be obtained from a consulting partner?
thanks - Kumar