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......
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......
I try to view this video but "It is showing as this video is private".
ReplyDeleteWinson.