BookmarkSubscribeRSS Feed
Calcite | Level 5 Yu
Calcite | Level 5
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
can you tell me what version you are using for each of these applicaitons?
Calcite | Level 5 Yu
Calcite | Level 5
SAS OLAP Cube Studio 4.2
SAS Information Map Studio 4.2
SAS Data Integration Studio 4.2
SAS Employee
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?



Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg



Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 3 in conversation