There is a requirement, where there are custom fields provided in a web-gui. A user can define what these custom fields are, and also provide values for the same.
For example, for Personal Information, you can have 10 custom fields provided, such as Custom Field 1, Custom Field 2....Custom Field 10. These all are like text box prompts on a GUI page.
There is another GUI interface (text box prompt) where user can define what Custom Field 1 ..10 should be.
User 1 logs in GUI 1, and defines the Custom Field 1 as "Age".
User then logs onto the Personal Information GUI , and sees that Custom Field 1 has been updated as Age, and enters the number in the text box.
What is needed: The Cognos report displays the Custom fields as columns in a list report. These are retrieved from the database as provided.
Q? Is there a way to automatically update the field name or list column name in the report automatically as updated in the GUI interface? I am guessing no, since the data updated in the Web GUI interface will first need to be stored in the database, and only then retrieved via FM.
Any thoughts/ suggestions..