topic Re: How to use HAVING filter in Information Map Studio in SAS Web Report Studio

How to use HAVING filter in Information Map Studio

Clash — Mon, 30 Jan 2017 12:55:51 GMT

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

Re: How to use HAVING filter in Information Map Studio

LinusH — Mon, 30 Jan 2017 13:25:38 GMT

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.

Re: How to use HAVING filter in Information Map Studio

Clash — Mon, 30 Jan 2017 13:45:28 GMT

Hi Linus!

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

Thanks a lot,

Best regards

/Claes