COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: damzI on 08 Aug 2016 05:03:47 PM

Title: Using a Common Filter for Multiple Data Sources in Transformer
Post by: damzI on 08 Aug 2016 05:03:47 PM
I am using a prompt macro in 5 of the data sources (report studio reports) in Transformer. All the data sources use the exact same prompt with the same prompt value.
The users want to be able to select a prompt value once and then build the cube. How can use one prompt parameter to populate multiple data sources in Cognos Transformer.