Hi. In views, when designing a benchmark tab, I want to link both the PE and KPI lists to the chosen dimension.
I select a dimension in a first dropdown (eg. Company Code) , then select the different company codes I'm trying to compare (in a different pair of dropdowns), but these components (Process Explorer, KPIs, etc..) do not update. In analysis I'd need to create a component filter, but how to proceed working on views?
You need to add filter condition in the yaml editor of process explorer or kpi list of views to show only for selection in drop down.
for example:
filters:
- pql: FILTER "${dd_variable ==
'Company Code'?'case_table':dd_variable
=='User'?'activity_table''}"."${dd_variable}"
= '${process 1}'
here company code is coming from case table, user is coming form activity table so when they select company code in main dropdown it will be updated in dd_variable and values related to company code are shoun in drop down 1 and this selection is stored in process 1 variable and using this we filter components.
The above condition works lie a if else condition and it finally becomes something like FILTER 'case_table'.'Company code' = '00001'
Hope this is clear, any doubds please comment
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
