Friday 11 May 2012

Parameter map Example

Parameter maps are basically lookup tables .simple example would be getting the product information based on the environment variable there are some predefined macros that help you get the information about a parameter map

 There are 2 types of session parameters .
 1) Environment (defined by cognos) and
 2) Model (this we can create)

 runlocale and machine are two session parameters that need some more understanding parameter maps and session parameter are defined by using #$ (hash and dollar)

 Session parameters are macros available in either Framework Manager or in Report Studio that can be used to dynamically determine and display information about a user's session. This can be especially handy for general display purposes (such as a person's name) or for security implementation. [edit]Parameters

These are the session parameters available in 8.3. account.defaultName account.personalInfo.businessPhone
account.personalInfo.email
 account.personalInfo.givenName
account.personalInfo.surname
 account.personalInfo.timeZoneID
account.personalInfo.userName

The syntax to use this information in a report (say in a data item) is: #sq($account.defaultName)# Additionally, one of the most useful macros is: #CSVIdentityNameList()# which returns a list of all the groups a user is in (all namespaces). One way to use that to secure data is to put a filter on a query subject in Framework Manager with some data column looking up the person's groups to see if the row should be returned: [AD Security Group] in (#CSVIdentityNameList()#)








No comments:

Post a Comment