Friday, February 3, 2012

Cognos 10 Framework Manager Advanced Concepts - Working with Prompts and Session Parameters.

Cognos 10 Framework Manager Advanced Concepts:
Working with Prompts and Session Parameters:

Working with Prompts:
1- Open the framework Manager
2- Right click a Namespace and create a calculation.
3- Create a prompt on Country; use this calculation
#prompt('p_Country','[Database Layer].[Customer Dimension].[Country] ')#
as shown
4- Create a Filter using this Prompt. This prompts can be used on the Reports.
5- Test the query subject.

Now lets see the session parameters.
1- login with your user id.
2- create a session variable
3- define a value for country.
4- use this variable in filter.
So, THATS IT......

1 comment:

  1. I try to view this video but "It is showing as this video is private".

    Winson.

    ReplyDelete