Hello All,

I have a column that exists in multiple tables in databases (Column name : source;   Values: DS1, EDS, EDS2 ). Is there way to create one filter in FM that applies to all the tables having this 'source' column, and be able to use in report prompt?

Thanks.

------------------------------
Sharjeel Ashraf
------------------------------

#CognosAnalyticswithWatson

Hi Sharjeel,

If you have this column in multiple tables (it might be in dimension tables) so you could have a filter in your fact query subject. 

For instance, you add a country_code = ?pcountry? in your filter tab from your fact query subject.

Best regards,



------------------------------
Patrick Neveu
Positive Thinking Company
------------------------------

Thanks Patrick,

But the column exists only in the dimensions and not in the fact tables, and I'm trying to filter all dimensions tables by passing only one parameter. And I looking for a FM solution for reusability? 
Is that possible?

------------------------------
Sharjeel Ashraf
------------------------------

Original Message:
Sent: Fri March 04, 2022 10:19 AM
From: Patrick Neveu
Subject: Single filter in FM on multiple tables

Hi Sharjeel,

If you have this column in multiple tables (it might be in dimension tables) so you could have a filter in your fact query subject.

For instance, you add a country_code = ?pcountry? in your filter tab from your fact query subject.

Best regards,



------------------------------
Patrick Neveu
Positive Thinking Company
------------------------------

Hi, What do you want to achieve by having only one filter? A flexible way to change that filter? One approach could be to read the condition (or part of it) from a FM session parameter and use that in distributed filters.

------------------------------
Philipp Hornung
------------------------------

Original Message:
Sent: Fri March 04, 2022 04:03 PM
From: Sharjeel Ashraf
Subject: Single filter in FM on multiple tables

Thanks Patrick,

But the column exists only in the dimensions and not in the fact tables, and I'm trying to filter all dimensions tables by passing only one parameter. And I looking for a FM solution for reusability?
Is that possible?

------------------------------
Sharjeel Ashraf
------------------------------


Original Message:
Sent: Fri March 04, 2022 10:19 AM
From: Patrick Neveu
Subject: Single filter in FM on multiple tables

Hi Sharjeel,

If you have this column in multiple tables (it might be in dimension tables) so you could have a filter in your fact query subject.

For instance, you add a country_code = ?pcountry? in your filter tab from your fact query subject.

Best regards,



------------------------------
Patrick Neveu
Positive Thinking Company