We have this cognos v10.2 with filters and 2 of them are as follows:
[SomeField] in ('ABC';'DEF';'ZYS')
[SomeOtherField] in ('QOR';'MIS';EST';'MS1')
It works fine but every 3 months or so that list might increase or decrease or even change that list. We need to receive that new list from the business so that we cognos developers can make such manual changes.
QUESTION:
- Is there a way to automate this ? Like for example using a Excel Name field from a file that the client would themselves update every 3months and so and that the report would automatically get updated ?
Thank you !