BO session on BW
As we are using only one OLAP connection between BO and BW system for all the reports and dashboards. So whenever we are refreshing the report, in BW system Dialog user session creates because we are using only one communication user for OLAP connection. Due to this sometimes BW system hangs and causing lot of performance issue. Is there any solution to set the session in background in BW system. Please suggest your valuable inputs.
Thanking you in anticipation.