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
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
2 replies Latest Post - 2013-02-01T16:25:38Z by Chandu402240
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 PostsACCEPTED ANSWER
Re: User Preferences & Cognos Reports2013-01-28T16:31:07Z in response to Chandu402240Although 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 PostsACCEPTED ANSWER
Re: User Preferences & Cognos Reports2013-02-01T16:25:38Z in response to DanielWagemannThanks.. this helps. Also i have same query on Cube packages i.e. we use the cube package in Report Studio, so is there a way to model this in cubes?
Please let me know if you need any additional details.