- When selecting the values in the report it show the error below?
- OS: Unix
- SQL Server
- Open the Open iT Analysis Server webpage and go to ‘Administration’ tab.
- Copy the values of ‘data source=’ and ‘initial catalog=’ from the connection string of Olap Server Connection.
- Open the excel file and go to ‘Data’ tab then connections.
- Click on the ‘Properties’ of the connection name then go to ‘Definition’ tab.
- Change the values of ‘data source=’ and ‘initial catalog=’ to the connection you have copied from your connection string of Olap Server Connection.
- Click ‘Ok’ to save connection then data will automatically refresh.