Forum Discussion

Clarke_Hair's avatar
Clarke_Hair
Contributor
2 years ago

Data Mgt job that runs a Dashboard or Book and saves output to Application File storage

We have created a book that when run outputs an Excel file that is 67 tabs.  It can take 20+ minutes to run on our desktop Clients and many times will time out if we are at home vs. in the office.  Anybody ever created something that would allow this book to run on the server and save the output to the Application Folder.  That would allow it to run using the Server resources and only impact our laptops when downloading the file, which should be manageable. 

Data Management
  • ckattookaran's avatar
    ckattookaran
    2 years ago

    I've done it using Dashboard, extender rules, parcel service, and task scheduler. Yes, it is possible.

  • db_pdx's avatar
    db_pdx
    2 years ago

    Do the reports use parameters?  If so, you'll likely need to specify them in the last lines of the Export File definition.  

  • db_pdx's avatar
    db_pdx
    Valued Contributor
    2 years ago

    Hi Clarke: you're on the right track and also have almost answered the question yourself! 🙂  You can use a Data Management Step > Export File to run the Report Book and save the output to the Application File Share.  Check the design and reference guide "Presenting Data Using Books" and "Application Tools > Export File"

    • Clarke_Hair's avatar
      Clarke_Hair
      Contributor
      2 years ago

      Thanks for pointing me to the Doc's  What it said do, is what I had been doing but nothing was getting created and was running way too fast.  Can you look at the below and let me know if you see anything that looks wrong.

      When I run it, it takes about 10 seconds to finish and i can't find any file so assume something is wrong on the setup.

       

      • db_pdx's avatar
        db_pdx
        Valued Contributor
        2 years ago

        Check under: File Share > Applications > YourApplicationName > DataManagement > Export > YourUserName

        That is where I found mine.

  • ckattookaran's avatar
    ckattookaran
    VIP
    2 years ago

    I've done it using Dashboard, extender rules, parcel service, and task scheduler. Yes, it is possible.

    • adriaans's avatar
      adriaans
      New Contributor II
      5 months ago

      Any experience running a data management step for a file extract (book) where there's a dependent parameter in the underlying cube views? It pulls all the standard parameters, but I haven't been able to get the dependent parameter to pull.