How to create Report Model Project for OLAP Cube

Raghava Narayana

Hi ,

Please tell me how to create Data Source and Data Source View in Report Model Project for OLAP Cube.Whats the provider to use while creating Data Source in Report Model Project to make connection to OLAP Cube.

Thanks

Raghava

Naveen J V, Bangalore

Hi Raghava,

• First log on to the reporting service database.
• Right click on the HOME and select New data source
• Under General tab, give name & discription of the new data source.
• Under Connection tab,
  • select Data source type as 'Microsoft SQL Server Analysis Service'
  • Connection string consists of two parts, Data Source & Initial Catalog. Data source is the place where your cube resides and Initial Catalog is the database name.
    • (Provide the sting like this ---->> Data Source=http://Server/olap;Initial Catalog=DB_TEST)
  • Check the Windows Integrated Security radio button.
• Select OK button to create the Data Source.
• After creating the Data source, right click on the created data source, select Generate model.

This is how u can generate report model, which can ve used for generating the user defined reports. Hope this helps.

Regards,

Naveen