I'm trying to pivot multiple columns in a table. After I configure the pivot DataStream item with all of the categories, how do I get two lines under the "Maps to Column?"
The pictures show it but I can only drag one DataStream item to one DataSource.
http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_ds.8.4.0.doc/ug_ds_id22317Example3CreateMultiplePivotValues.html
(http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_ds.8.4.0.doc/ug_ds_id22317Example3CreateMultiplePivotValues.html)
(http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/topic/com.ibm.swg.im.cognos.ug_ds.8.4.0.doc/images/pivot_mapping_5.gif)
Is there a trick like ctrl-shift or something?
HELP!
Hold down the <ctrl> button while you press MAP or while you drag or double-click the datastreasm item on the right. This will add to the existing mapping rather than replacing it.
Cheers!
MF.