Arul's.TEG Blog

Format : Macro- #prompt(‘pmtName’,’datatype’)# Parameter Map- #$parametermap{prompt(‘pmtName’,’datatype’)}# Session Parameter- #$parametermap{$Sessionparameter}# Date Prompt- to_date(#prompt('Start/END Date', 'varchar')#,'yyyy-mm-dd')

Microsoft has a free BI excel plug in that's simple to learn and use but very powerful, it's called power pivot. You can download it from www.powerpivot.com - check it out.

We have seen that cognos macro functions available in framework manager are also available in report studio. Here is a simple list of existing Cognos Macro with description. This list contains functions that can be used within a macro. A macro may contain one or more macro functions. A macro is delimited by a number sign (#) at the beginning and at the end. Everything between the number signs is treated as a macro expression, which is executed at run time. + value1 + value2 Concatenates two strings. Example: # '{' + $runLocale + '}'# Result: {en-us} CAMIDList CAMIDList ( [ separator_string ] ) Returns the pieces of the user's identity (account name, group names, role names) as a list of values separated by commas. Example: #CAMIDList ( )# Result: CAMID("::Everyone"), CAMID(":Authors"), CAMID(":Query Users"), CAMID(":Consumers"), CAMID(":Metrics Authors") CAMIDListForType CAMIDListForType ( identit

To access IBM Business Glossary, you must specify the URI of the Glossary Web page. By default, the Glossary search results in IBM Cognos 8 return all terms that contain the keyword specified in the search. Steps 1. In IBM Cognos Connection, click Launch, IBM Cognos Administration. 2. On the Status tab, click System. 3. Click the arrow next to System to display the Actions menu, and then click Set Properties. 4. Click the Settings tab. 5. For the Environment category, IBM Business Glossary URI, type the following URI: http://server_name:port_number/bg/popup/popupSearch.do For example, type http://myserver:9080/bg/popup/popupSearch.do 6. All terms that contain the keyword specified in the search are returned. 7. Click OK.