DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) cube.
You need to reuse a Revenue measure group from a different database.
In SQL Server Data Tools (SSDT), which three actions should you perform in sequence? (To
answer, move the appropriate actions from the list of actions to the answer area and arrange
them in the correct order.)
Answer: See the explanation.
Explanation:
Note:
* you can use the Linked Object Wizard to add a measure group from another database
* You can use the Linked Object Wizard to either link to or import cubes, dimensions,
measure groups, calculations, and Key Performance Indicators (KPIs). You can link to or
import these items from another database on the same server or from a database on a
remote server
* The Linked Object Wizard guides you through the following steps:
Selecting the Analysis Services data source from which to link or import objects.
Selecting the objects from which to link or import.
Saving the changes.
* Use the Select Objects page to select the objects that will be linked to or imported.
Dimensions and measure groups (including the associated measures) are linked. Actions,
key performance indicators (KPIs), and calculations are imported.