Create Hierarchy between Business units in EA workspace dashboard

[Shivambitanwar1]

New to Platform analytics dashboard. Create a new filter referencing to busines unit table in EA workspace, In data to filter added Business application.Business unit

I want the selected business unit in filter to be searched in Business application Bu.parent field or Business application. business unit field.

Where can I add this OR filtering condition .?

What I have done so far is - I set the value of selected business unit

Then created a data resource for look up records.

Where do I go from here? How do I call my data resource to filter underlying business application

I also created an indicator with breakdown mapping for business unit, apparently scripted breakdowns does not work in UI Builder. my breakdown is returning list of child bu sys ids. is there a way to use these breakdown mapping to filter out underlying widgets in EA workspace.

Tagging you because I saw an article that helped me get this far. 

@Adam Stout  @nageswariM 

#

[ankitbanerj]

Hi @Shivambitanwar1 ,
check this out

Best regards,
Ankit B

If this solution worked for you, kindly mark it as Accepted Solution and give it a Helpful rating to support the community.

[Shivambitanwar1]

Hi Ankit, I am building my query in Client script in Ui builder and manipulating the query to an encoded query to fetch more results . But somehow its messing with the other filters.

function handler({ api, event, helpers, imports }) {

const mergePARFiltersV2 = imports["global.mergePARFilters"]().v2;

// 1. Read what the filter UI produced (so UI chips continue to show correct selection)

const { payload: { appliedFilters } } = event;

// 2. Extract the selected BU value

const businessUnit = event.payload.appliedFilters[0].values[0];

console.log('Selected BU = ' + businessUnit);

api.setState("parFilters", ({ currentValue }) => {

const customFilter = businessUnit ? [{

type: "query",

apply_to: ["cmdb_ci_business_app"], // only apply to BA table

"extraValues": {},

"include_unmatched_or_empty": false,

encoded_query:

"business_unit=" + businessUnit +

"^ORbusiness_unit.parent=" + businessUnit +

"^ORbusiness_unit.parent.parent=" + businessUnit

}] : [];

const { parFilters, encodedQueries } = mergePARFiltersV2(

currentValue,

customFilter

);

// Optional but good hygiene

api.setState("encodedQueries", encodedQueries);

console.log("parFilters = ", JSON.stringify(appliedFilters));

return parFilters;

});

}

I dont see if my filters get applied