When creating a page, we select multiple members in hiearchy in the background (not a slicer) and then try to drill to detail and receive an error that multiple members are selected.
Error
"This function is not available because there are multiple selections on the "Reason for Extension" dimension, which is in the background. Please choose a single member on the Reason for Extension dimension and try again."
We are looking to only show the data for the members we select and do not necessarily need them placed in the page itself to view as a row or column. Reason being why we want it in the background but not sliced.
Also on a side note: We did notice that the hierarchy has a member that is listed as "item" and the programmer indicated these are the blank fields. If he was to remove these would it only affect that specific hierarchy or would it remove all those records for the entire cube. Thus not having that data reporting out in other pages.
Any thoughts?