Identifying the Most Commonly Referenced Business Terms
Hey all,
We’re looking to prioritize the definition of assets based on the frequency of their use in other assets. For example, we’d like to prioritize the definition of business terms most commonly referenced in our policies.
Manually, we can use the References tab on the side bar for any given asset to see from what it’s referenced. But the ability to easily produce a report with the top most-referenced business terms has escaped us. Here’s what I’ve looked at so far:
- the references tab gives us exactly the sort of results we want, but there doesn’t seem to be a way to export that, let alone do it automatically.
- the REST searchApiis something we could use, but found that it struggles with hyphens and spaces in the search terms. “Full-Time Student” gives anything with any three of those.
- we’ve considered dynamically creating a ViewConfig for each business term and running it through the Output Module. This seems to be the best option so far, but it seems to be a lot of work to have to run that 2000 odd times.
- the only other option we’ve considered is extracting the key attributetypes from all referencing attributes, exporting the text to an external file, and then finding the an appropriate set of common n-grams using some natural language processing. (The benefit here is that we might identify business terms that we don’t yet have in Collibra)
Is there any easier way that I’m missing?
Tom Friesen
Posted 3 years ago · Edited 1 year ago·Last reply 3 years ago
1 comment
uditgupta1
·3 years ago · Edited@tom.friesen Instead of relying solely on Collibra’s built-in functionality, you could consider leveraging Collibra’s API capabilities along with some custom scripting or programming. Here’s a potential workflow you can follow:
/referenceableAssets/{assetId}/incomingReferencesendpoint.By following this approach, you can programmatically retrieve the references and store them in a structured format for analysis. This gives you more flexibility in generating reports or identifying patterns across different assets.