| title | Data sources from existing objects (Data Source Wizard) (Analysis Services) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 06/13/2017 | |
| ms.prod | sql-server-2014 | |
| ms.reviewer | ||
| ms.technology | analysis-services | |
| ms.topic | conceptual | |
| f1_keywords |
|
|
| ms.assetid | e6ef6dea-9db8-45c4-8959-f9febd7caf7b | |
| author | minewiskan | |
| ms.author | owend | |
| manager | craigg |
Use the Data sources from existing objects page to specify an existing data source or project on which to base the new data source.
Create a data source based on an existing data source in your solution
Select to base the new data source on an existing data source in the solution. When a project that uses the new data source is built, refreshed, or deployed, the new data source acquires the settings from the data source you specify when you select this option.
Data source
Select a data source on which you want to base the new data source from the list of data sources, which is grouped by project.
Create a data source based on an Analysis Services project
Select to create a new data source that references another [!INCLUDEmsCoName] [!INCLUDEssNoVersion] [!INCLUDEssASnoversion] project in the current solution. The new data source acquires settings from the TargetServer and TargetDatabase properties of the selected project. When a project that uses the new data source is built, refreshed, or deployed, the new data source acquires settings from the data source you specify when you select this option.
Project
Select the project that you want to reference in the new data source.
Data Source Wizard F1 Help (Analysis Services)
Data Sources in Multidimensional Models
Data Sources Supported (SSAS Multidimensional)