Establishing Connection B/W Mstr & DB

1. We have to create DNS. We can create DNS using Mstr connectivity      wizard (or) odbc data sources.
2. We need login for the database , login credentials must have executable permissions on the particular     database.
3. We have to create database instance, we can create this using database instance wizard / right click on the folder    administration -> configuration managers - > database instances folder
4. Once we have completed, then configure a project and select database instances and add the created database instance wizard    then we will get the tables and data from those connected database.
5. Once we created the DB instance, now we have to specify the DB instance to the particular project. Now right click on any    project and select configuration of the project.
6. Select SQL data sources and add the newly created db instance, so now we are able to use the particular db tables and data .

Difference B/W Report filter, View filter & report limit

Report Filter is applied on objects before report execution.It appears in WHERE CLAUSE & it effects the SQL

View Filter is applied on objects after report execution. It retrieves the results subset of original report, it can be viewed & designed in view mode not in design mode of the report.It does not hit the dwh / db. This is a OLAP feature.

Report limit is a pre-fetch technique applied on db level, When we use the Report limit the HAVING CLAUSE will be generated.report limit specifies a set of  criteria used to restrict the data returned in the report data set after the report metrics are caluculated.