Using Analysis for Office version 1.4 (18.104.22.16863 to be precise) and BI 4.1 SP02 patch 6.
Can someone confirm that when using "Add lines using filter by member" option, you cannot use the "Select All" option unless you un-check one or more of the selected values in the prompt panel?
Most of our BEx queries have a combination of mandatory and optional prompts with and without authorization variables and when selecting the list of values i always see a "# Not Assigned" value in the list of prompt values. Not sure if the # value is preventing AFO from selecting all values.BEx analyzer allows you to select all values without any issue so would like to know if this is a defect or "design feature" of Analysis Office.
Any suggestions or workarounds are appreciated!