The user requires a static dashboard to be created everyday with (current date-1) data , automatically(i.e.it should be scheduled) and be saved in his local drive. Please tell me different ways to accomplish this task.I guess we have to embed some code in the text component of DB or through action link.Please help me.
Sound like you want a Dashboard with no filters, no drill down actions but with the export function(s). Saving an entire dashboard or a single analysis requires a user action.
As for the data being current date - 1, place that in your analysis filters and nothing needs to be scheduled except the data loads (which I assume already are)