Traditional web-based reporting with SAS BI tools

How to use HAVING filter in Information Map Studio

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 13
Accepted Solution

How to use HAVING filter in Information Map Studio

Hi!

 

I have a very simple information map containing 4 tables, relations are defined. 

How do I create a filter for one of my tables, based on HAVING where clause? What I want is a query that only returns the rows with highest number for my column, example "having my_key_sk EQ max(my_key_sk)"

Thanks for any help pointing me in the right directions,

 

Regards,

Claes Wedberg


Accepted Solutions
Solution
‎02-05-2017 10:15 AM
Super User
Posts: 5,378

Re: How to use HAVING filter in Information Map Studio

Aggregate filters can be a performance killer, so I would suggest create a new table using this having clause.

If that's not appropriate:

If you are not able to create it in the UI, you could probably create a view on top of the table, and use that instead.

Data never sleeps

View solution in original post


All Replies
Solution
‎02-05-2017 10:15 AM
Super User
Posts: 5,378

Re: How to use HAVING filter in Information Map Studio

Aggregate filters can be a performance killer, so I would suggest create a new table using this having clause.

If that's not appropriate:

If you are not able to create it in the UI, you could probably create a view on top of the table, and use that instead.

Data never sleeps
Occasional Contributor
Posts: 13

Re: How to use HAVING filter in Information Map Studio

Hi Linus!

Shure thing, I created a view and it works great!

Thanks a lot, 

 

Best regards

/Claes

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 242 views
  • 1 like
  • 2 in conversation