Topic
IC4NOTICE: 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.
2 replies Latest Post - ‏2013-02-01T16:25:38Z by Chandu402240
Chandu402240
Chandu402240
29 Posts
ACCEPTED ANSWER

Pinned topic User Preferences & Cognos Reports

‏2013-01-28T16:09:34Z |
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

Sarath K
Updated on 2013-02-01T16:25:38Z at 2013-02-01T16:25:38Z by Chandu402240
  • DanielWagemann
    DanielWagemann
    850 Posts
    ACCEPTED ANSWER

    Re: User Preferences & Cognos Reports

    ‏2013-01-28T16:31:07Z  in response to Chandu402240
    Although I have not tried it, you could try this within Framework Manager using security filter macros and join relationships.

    Table Product_line
    ProductLine_Code
    1
    2
    3
    4
    5
    6

    Table User_Table
    User ProductLine_Code
    user1 1
    user1 2
    user2 1
    user3 4
    user3 5
    user4 6
    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
      Chandu402240
      29 Posts
      ACCEPTED ANSWER

      Re: User Preferences & Cognos Reports

      ‏2013-02-01T16:25:38Z  in response to DanielWagemann
      Thanks.. 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.

      Thanks