Database Reference
In-Depth Information
Figure 10-46. Browsing a processed dimension
The computer reconnection button : This button is important because it allows you to
reconnect to your analysis server computer. Remember that when you browse the
dimension, you are browsing on the server and not from the XML files within Visual
Studio. This is why you have to deploy and process the dimension before it can be
browsed. The Browser tab caches the results of your dimensional query and may not
show you the actual contents on the SSAS server unless you either refresh or reconnect.
The page refresh button : This button is your standard refresh button. Its function is similar
to the reconnect button, but in our experience, the reconnect button is much more likely
to give you a clean refresh than this page refresh button. Therefore, we recommend
clicking the middle button whenever you deploy a processor dimension.
Note the Hierarchy dropdown box. Remember that each attribute forms its own attribute hierarchy, so
unless you have hidden that attribute hierarchy, you will see it listed within the dropdown box. Because we hid
the Author attribute, in Exercise 10-1, it does not display in the dropdown box of Figure 10-46 . You will, however,
see any user-defined hierarchies that you may have created. Selecting these hierarchies allows you to browse
them in a treeview just like you would a simple attribute hierarchy. And although we cannot browse the Author
attribute by itself, we can see its data using the AuthorsByState user-defined hierarchy.
As the developer, you will test each dimension using a browser to verify its construction. If you find anything
that looks incorrect, you fix it by accessing the appropriate dimension designer tab, make any changes, then
redeploy and process. Afterward, use the reconnect (center) button to see the changes you have made.
Now that we have discussed how to deploy and process dimensions, let's do so to the dimensions we have
created so far in the next exercise.
eXerCISe 10-3: DepLOYING, prOCeSSING,
aND BrOWSING the DIMeNSIONS
In this exercise, you will deploy, process, and browse the dimensions in your ssAs project. Let's start by
configuring the project deployment settings.
Configure Your Project Deployment Settings
Before we can deploy the project we need to configure the deployment options.
1.
Right-click the PubsBICubes project icon in solution Explorer and select show
Properties from the context menu.
Search WWH ::




Custom Search