topic Re: OLAP cubes filter with a dynamic calculated memeber? in SAS Web Report Studio

OLAP cubes filter with a dynamic calculated memeber?

Yu — Thu, 01 Apr 2010 08:42:04 GMT

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?

Re: OLAP cubes filter with a dynamic calculated memeber?

Jenn2 — Thu, 08 Apr 2010 19:13:05 GMT

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

Re: OLAP cubes filter with a dynamic calculated memeber?

Yu — Fri, 09 Apr 2010 09:49:32 GMT

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

Re: OLAP cubes filter with a dynamic calculated memeber?

julierd — Wed, 05 May 2010 20:46:21 GMT

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?