Why Cognos can't find some terms in Business Glossary?
Posted: Thu Jul 19, 2012 11:48 am
We have just hooked Cognos up to Business Glossary and are having a few challenges. Hooking Cognos to Business Glossary was an easy configuration entry change (other posts here describe that process). When you do this, a consumer viewing a report can right click on a report label and then select the 'Glossary' menu option. That performs a search in Business Glossary for that report label as a term and returns a list of relevant terms.
This works well unless the term contains a % sign. Does anyone know if special characters are not allowed in Cognos report labels if they will be used as a search parameter to Business Glossary? What is that list not allowed?
More specifics for those still interested: I have 'Grant %' and 'Grant Funded Amt' as terms in Business Glossary. However, from a report whe I selet Glossary for 'Grant Funded Amt' it works and shows a list of terms. Grant Funded Amt is at the top of that list but Grant % is also within the list (because it does an advanced search - somthing else I'd love to change!). However, when I select Glossary for 'Grant %' directly - a blank screen is returned. When a term is not in the Glossary it will return a screen with a message saying 'no items met the search criteria'. So I think there is something about the percent sign that is messing it up.
Thanks much!
This works well unless the term contains a % sign. Does anyone know if special characters are not allowed in Cognos report labels if they will be used as a search parameter to Business Glossary? What is that list not allowed?
More specifics for those still interested: I have 'Grant %' and 'Grant Funded Amt' as terms in Business Glossary. However, from a report whe I selet Glossary for 'Grant Funded Amt' it works and shows a list of terms. Grant Funded Amt is at the top of that list but Grant % is also within the list (because it does an advanced search - somthing else I'd love to change!). However, when I select Glossary for 'Grant %' directly - a blank screen is returned. When a term is not in the Glossary it will return a screen with a message saying 'no items met the search criteria'. So I think there is something about the percent sign that is messing it up.
Thanks much!