Hi Team -
We are looking to have cognos Reports which will be using user set preferences for filtering data. Mainly these preferences will be stored in db and then when user login after few days reports will be filtered.
As cognos cannot write data to db, we are planning to have separate page in .Net where users can modify and store the preferences.
Let me know if this is possible and thoughts for the same, also if there is any cognos proven practice for the same.
Thanks in Advance
Pinned topic User Preferences & Cognos Reports
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-02-01T16:25:38Z at 2013-02-01T16:25:38Z by Chandu402240
DanielWagemann 2700058MAJ850 Posts
Re: User Preferences & Cognos Reports2013-01-28T16:31:07ZThis is the accepted answer. This is the accepted answer.Although I have not tried it, you could try this within Framework Manager using security filter macros and join relationships.
Filter the User_Table using a the account_info macro value and join the Product
Then create a query subject which pulls the ProductLien_Code from the user table and the rest of the product information from the Product table. In theory, only the values assigned to the user should show up.
Also, you could write a data update stored procedure and create a form style report to update the filter values. You may no need .Net in the mix.
Again the above is in theory, but is seems right in my head.
Chandu402240 27000495P829 Posts
Re: User Preferences & Cognos Reports2013-02-01T16:25:38ZThis is the accepted answer. This is the accepted answer.
- DanielWagemann 2700058MAJ
Please let me know if you need any additional details.