Hi Team -
We are looking to have cube based 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 for a cube, also if there is any cognos proven practice for the same.
Thanks in Advance
Pinned topic Cube based Reports & User Preferences
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-02-01T17:45:04Z at 2013-02-01T17:45:04Z by DanielWagemann
DanielWagemann 2700058MAJ850 Posts
Re: Cube based Reports & User Preferences2013-02-01T17:45:04ZThis is the accepted answer. This is the accepted answer.Another thought for both your relational and OLAP scenarios.... Again in theory, you maybe able to get away with a CSVIdenity parameter map for each prompt which is fed off of a Database column.
It maybe easier than the relationship approach and would be consistent for both cubes and relational packages.
The CSVIdentity parameter map would swap out values based on the userid logged on. Keep in mind for OLAP filtering you would most likely want to store the dimensional object reference... Instead of 2004 for a relational year... it would be Cube.[H].[l]->PC.2004 which may complicate things a tiny bit.