All our users run queries from web browser but occassionally download the results to excel and email them to other users. In cases where the results have hierarchies, indent symbol is downloaded to excel too and when the file is re-opened in excel, prompt to login to BW server pops up. We found out that this pop up is purely to get the symbol. Users cannot get around this popup unless they login. Not all users have login to BW yet and hence a major issue.
I did find an option in Excel in "Save as" functionality where a checkbox can be unchecked that says "Download images from web if not stored in Excel". When the file is saved with this option, popup to login to BW no longer shows up.
Is this the only option? Any settings in BW to not download this symbol when saving to Excel?
BTW: CSV format works great, but its tough to convince the users to use this all the time.
To correct the problem with Excel Download you will have to make the BW Mime service anonymous. You can do this from transaction SICF and setting a user name and password for the mime service under the following path default_host/sap/bw/mime. Please see the attached screenshot for the same (MimeLogon.png). This will not have any security impact as only mime objects (CSS, JS, Images etc.) will be accessed using this service. Make sure the anonymous user ID is a service user and not a dialog user (dialog users can cause problems).
See OSS note 487456 for step by step.