Skip to main content
K
kumar
Newcomer
November 7, 2022

Running Dashboard using Data Management Job

  • November 7, 2022
  • 1 reply
  • 0 views

Hi; 

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. 

 

thanks

Kumar

1 reply

J
OneStream Employee
JackLacavaOneStream Employee
OneStream Employee
November 9, 2022

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.

K
kumarAuthor
Newcomer
November 10, 2022

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 

Terms & ConditionsAccessibility statement