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.