Hi
I am configuring SCSM report on SQL SSRS server. For the multimart Data Source I selected Microsoft Analysis Services - as data source type and connection string given as below :
<root><source id='DWDataMart' connectionString='Data Source=db;Initial Catalog=DWDataMart;Integrated Security=True' /><source id='OMDataMart' connectionString='Data Source=db;Initial Catalog=OMDWDataMart;Integrated Security=True' /><source id='CMDataMart' connectionString='Data Source=db;Initial Catalog=CMDWDataMart;Integrated Security=True' /></root>
But get this error when testing connection : A semicolon was expected at index 30 in the connection string.
Also see attached screen shot. Any clues to help me? thanks