Loading...

IBM Cognos BI - Dynamically Change Columns in a Report with One Prompt Selection

45,432 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on May 11, 2011

Learn how to use a prompt macro, case statements, a prompt control with static choices, and conditional formatting to dynamically control which columns are displayed in a Cognos report and how. Learn more about report authoring in this white paper: http://bit.ly/U3L6uk Also, check out the IBM reports web page at: http://www-01.ibm.com/software/analyt.... And finally, The syntax used in this technique is:
Prompt Macro Syntax

#prompt('Report Type', 'token', '[Sales].[Order Method].[Order Method]')#

Case Statements Syntax

Details Column

Case

When (?Report Type? = '[Sales].[Order Method].[Order Method]') then ([Sales].[Products].[Product Line])

When (?Report Type? = '[Sales].[Products].[Product Line]') then ([Sales].[Products].[Product Type])

Else ([Sales].[Products].[Product Description])

End

Measure Column

Case

When (?Report Type? = '[Sales].[Order Method].[Order Method]') then ([Sales].[Sales].[Quantity])

When (?Report Type? = '[Sales].[Products].[Product Line]') then ([Sales].[Sales].[Revenue])

Else ([Sales Target].[Sales Target].[Sales Target])

End

For more IBM Cognos Proven Practices content, please visit http://www.ibm.com/developerworks/dat...

Loading...

When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...