Relationship not Working when applying view as role function

[Anonymous]

Hi Again Experts,

Good day!

I have a problem with my dashboard and I think it's due to their relationship. When I applied the view as role function, the last dashboard which is reporting is not working. I did try to create a relationship but still doesn't work. I want to have a relationship between the Hierarchy and the reporting data. Here is an example of their data as attached. I know I need to create one relationship with unique values but I can't make it as it has more than one.

Could you please help me to create a measure where I could create a relationship where the view as role function will work?

Hierarchy:

Employee Data As Of	Employee No	HR_Data_First Name	HR_Data_Last Name	Full Name	Status	Var Plan ID	Var Plan Desc	Country
2019-03-03	0009444	Alex	Van Halen	Alex Van Halen	Active	LXK01320	OEM Account Manager	United States

Reporting data:

Empl_ID	Name	Element	Country	Plan ID	Var Plan Desc	Job Type	Sales Plan Eff Dt	Job Data Chg Dt	Level	Business Area
0009444	Alex Van Halen	Total Revenue	United States	LXK01320	OEM Account Manager	OEM Account Manager	2018-01-01	2019-02-15	OEM	Channel
0009444	Alex Van Halen	Supplies Revenue	United States	LXK01320	OEM Account Manager	OEM Account Manager	2018-01-01	2019-02-15	OEM	Channel

Please advise.

Thanks

[Anonymous · Accepted solution]

Hi @Anonymous ,

How did you setup your relationship? Have you turn on 'apply security filter on both direction' option? It will affect security filter effect.

Regards,

Xiaoxin Sheng

[Anonymous]

Thank you! I just delete one relationship and it's working.

Thanks