What is Analysis service repository?

What is Analysis service repository?

Every Analysis server has a repository to store metadata for the objects like cubes, data sources etc. It’s by default stored in a MS Access database which can be also migrated to a SQL Server database.

What is Analysis service repository?

Each server running analysis service has a repository to store objects of the computer running Analysis Services an Analysis service repository stores the information about the cubes, dimensions and other objects of the analysis server. By default the repository is an .mdb database on the server computer where the analysis service is installed..
SQL Server - What is SQL service broker?
What is SQL service broker? - SQL service broker provides asynchronous queuing functionality to SQL server.......
What is user defined datatypes and when you should go for them?
What is user defined datatypes? - User defined datatypes is created by using base SQL Server data type by providing......
What is bit datatype?
A bit datatype is an integer data type which can store either a 0 or 1 or null......
Post your comment