Hi all,
I have field in my model that is the file name of an attachment. Field is called FILE_NAME, its datatype is VARCHAR2 (200 bytes), and its value in the database can be something like 'document.docx' etc. Seems to look ok in Framework Manager. But when try to report on it in Query Studio or Report Studio, I cannot filter on that field. Is there anything I can do to it in FM that would help? Or should I try to convince my users to use a different field to filter on, perhaps the related attachment ID.
Firstly I would check what the attributes of the field are in Framework Manager. Is it set as an attribute, etc.? I can imagine that Cognos will give such a long database column some settings that prevent to do heavy activity on it, such as filtering or searching.
Secondly, I wonder why people want to filter on such a secondary attribute. Usually people filter or search on values of core attributes. For me this is not such an attribute. Are they looking for a specific file type for instance? Consider that then maybe you can extract the file type from your file name and put it in a separate column that will be easier to query.
What is the dimension that this field is an attribute from?