Reports: How to share a prompt?
With Reports in PBCS, if I have two grids, how do I share a prompt, so that the user selects a member and it applies to both grids? The member is on the grid. Grid 1 is for reporting, Grid 2 is hidden and I want the prompt the user selects to select the column to also choose the column in the hidden grid.
Currently if I select "Prompt" to select the member, there is no option to use an existing prompt, and if I put the same prompt text I get an error saying it must be unique. I can't see any option for sharing a prompt, but I know it must be possible because the online Reporting documentation says: "If a report has multiple data sources and the POV dimension with the prompt is shared between them, the prompt will display..."