Topic
  • 2 replies
  • Latest Post - ‏2013-02-01T16:25:38Z by Chandu402240
Chandu402240
Chandu402240
29 Posts

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

    Re: User Preferences & Cognos Reports

    ‏2013-01-28T16:31:07Z  
    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

    Re: User Preferences & Cognos Reports

    ‏2013-02-01T16:25:38Z  
    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.
    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