We would like our user to have a 1 click data extract using an image - I have tried embedding the URL and naming the worksheets, but only the measures appear. Any recommendations on how to accomplish this?
Example - You have Category and then sub Category, sales and profit plus a comments field. When you are looking at category you can drill down to sub categories with X filter based on another dimension. Now I want to click on an image and download the underlying data (columns that I specify) with one click (not using tooltip or the icon in Server).
You might have Categories that include Appliances and Bookcases - I might filter down to Returned Bookcases - now I want to click on an image and see Customer Name, order date, category, item, and Call notes download automatically in a csv based on that filtered view.
The way I would create a 1-click export is to create a custom tabcmd script, save it as an executable, then the user can simply have an icon on their computer that they click for the export.
Here is some more info about tabcmd: