Good day forum I have a question I'm not an expert in Analysys Service I made a multidimensional data cube that is processed daily, from a data source data warehouse SQL server, in the fact table I have a partition that only took me to the cube the registers with status = 0, will bring a moment (the next month) that data in the cube have to be deleted (they will expire), that data in the data warehouse will change its flag to status = 2 and when the cube is processed I have than to identify them in the cube and eliminate them.
Do you know if you can remove information from a cube when it is processed?
Thanks for the support!