Traditional web-based reporting with SAS BI tools

OLAP cubes filter with a dynamic calculated memeber?

Reply
Occasional Contributor Yu
Occasional Contributor
Posts: 5

OLAP cubes filter with a dynamic calculated memeber?

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?
SAS Employee
Posts: 110

Re: OLAP cubes filter with a dynamic calculated memeber?

Yu,
can you tell me what version you are using for each of these applicaitons?
Occasional Contributor Yu
Occasional Contributor
Posts: 5

Re: OLAP cubes filter with a dynamic calculated memeber?

SAS OLAP Cube Studio 4.2
SAS Information Map Studio 4.2
SAS Data Integration Studio 4.2
SAS Employee
Posts: 11

Re: OLAP cubes filter with a dynamic calculated memeber?

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?
Ask a Question
Discussion stats
  • 3 replies
  • 250 views
  • 0 likes
  • 3 in conversation