Please suggest a best way i can send a huge data dump with some fileds filtered for one cube to .txt to mail on regular basis. (no reportinging used)
It should also be send when there is a change in status with daily refresh (from of an object in infocube.)
I assumed it can be done thru OHD for taking the data dump.
or creating APD with filtering some values if required. But how can I give the data when data is refreshed/status changed.
Any suggestions please on this.