Database Reference
In-Depth Information
Note
Note that every object (cube, dimension, attribute, measure, and so on)
within the Analysis Services project has an ID (identifier) and name. The
object ID defaults to its name at the time of object creation. You cannot
change the object's identifier without dropping and recreating the object.
This might not sound like a big deal, but keep in mind that all the XMLA
commands refer to the object's identifier. For example, if you have a di-
mension that you happen to initially name "my snazzy dimension," then
this would be the string you will see anytime you process the dimension,
even if you later rename the dimension to "employees". Having non-de-
scriptive identifiers makes debugging difficult, so get in the habit of nam-
ing objects appropriately when creating them.
12. After you complete the cube wizard, the SSDT cube design window should
resemble the following screenshot. As you can see, the cube designer has
multiple tabs on the top ribbon; each of these has a specific purpose you will
learn about. The data source view window includes the tables you used to
create the cube. The Measures and Dimensions windows include the listing
of measures and dimensions respectively.
Search WWH ::




Custom Search