Hello all;
I am trying to make a multiple report drill through and I ran into a small hiccup.....
I am drilling through to about five different reports using the same hierarchy but because some of the reports are in different cubes one of the report has a different MUN than the others. I thought that a quick fix would be to change them all to pass member captions - which worked; but then this takes away the drill through capability; which is what the end user really wants. So then I tried to have two prompts and basically paste one into another and pass whichever one was needed the string or mun to the correct report. This worked as well but for that report that has to take the string; I cannot enable drill through on it. I tried using a data item in the report and casting there?? But I am not good with that functions? If anyone has any insight I would GREATLY appreciate it:)