Is it possible to delete records from Executive Query cubes, either via DMT or some other means? We are trying to snapshot information (projected sales, open operations, etc.) to track trending and to help pinpoint shifts in these areas. Creating the executive queries is not an issue, but I only need to keep a couple weeks of data. Some of these sets of daily results are over 15,000+ records so this could grow pretty quickly.
Any help or advise is greatly appreciated.