I have a web report based on an information map. And the information map is based on the OLAP cube.
It stores the sales record of my company's sales by production month, sale name
I need to add some logic that only select the record from the sales that still working in our company (and we have a termination date to identify whether he still working or not).
So, I assume I created a new calculated member to show the sale still working in our company (by checking the max(month) and the termination date).
But how can I filter the history sale records which only come from these sales?
I'm trying to hunt down an answer for you. Do you only want to see data of sales reps that are still working at the company? If so, this sounds like a condition to apply at cube loading time – a where clause on the input data, so that those data are never loaded in to the cube.