OLAP cubes filter with a dynamic calculated memeber?

[Yu]

Dear all,

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?

[Jenn2]

Yu,
can you tell me what version you are using for each of these applicaitons?

[Yu]

SAS OLAP Cube Studio 4.2
SAS Information Map Studio 4.2
SAS Data Integration Studio 4.2

[julierd]

Hi Yu,

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.

Does that make sense?