Interactive Filter on Business Unit Name

[claudio_palmeri]

I have created a dashboard to display several reports related to my Business Applications. The reports display data from the Business Applications [cmdb_ci_business_app] and Mapped Application Service [cmdb_ci_service_discovered] tables.

I am now attempting to create an Interactive Filter to display the list of Business Unit names, so that the reports/dashboard is automatically refreshed with the subset of data based on the Business Unit selected.

I have created a custom Interactive Filter with the following settings:

• Filter Based On: Choice List
• UI Control Type: Select Single Input
• Table: Business Application [cmdb_ci_business_app]
• Field: Business Unit (also tried with Business Unit Name)

When I save the filter, I receive a "Selected field is not a choice list" just below the Filter attribute.

What am I doing wrong? In comparison, if I select the Field "Business Criticality" it works well.

Thank you!

[JagjeetSingh]

Okay. Lets start from the basics for me to understand this.

What are the table names you are using for reporting.

[claudio_palmeri]

Nevermind - I found the issue.

All my entries in Mapped Application Service [cmdb_ci_service_discovered] had the 'Department' value as (empty), so the system could not dot-walk back to the Business Unit name.

Once the Department is populated in Mapped Application Service [cmdb_ci_service_discovered], all reports update correctly with the one filter.

Thank you, Jagjeet.

[JagjeetSingh]

Wonderful! I'd appreciate if you can mark my answer correct if it applicable.