Database Reference
In-Depth Information
Figure 9-17. Adding a new administrator using the security page of the Analysis Server property window
if you cannot connect to the Analysis Server at all, it is possible that you forgot to add your user account
to the list of SSAS administrators at the time you installed SQL Server. if this happens, you may want to
uninstall and reinstall SSAS again. This is often the easiest way to remedy this problem. other options exist,
but research them carefully, as they are complex.
Data Source Views
Microsoft does not allow cubes to be built directly on the data warehouse tables. Instead, Microsoft decided to
use an abstraction layer, which is the essence of a data source view. Therefore, before you can make your cubes,
you need a data source view.
A data source view consists of a set of one or more logical tables with each table representing a saved
SQL select statement. This feature has a number of advantages. It allows you to add or modify the underlying
database design to fit your current needs without breaking the cubes. If the underlying database changes, modify
the data source view to present the database as it was before the change. Additionally, if the data warehouse
is not designed the way you would like it to be, you can modify the data source view to mimic your ideal data
warehouse design.
Here is a common example: a data warehouse starts out containing a single fact table, but over time it has
grown very large. So the decision is made to split the table into sections based on years (Figure 9-18 ). These tables
are then placed on their own hard drives, thus increasing I/O performance in the data warehouse. By changing
the SQL select statement in the data source view, the three tables are still presented to SSAS as a single table. And
all of the cubes based on the earlier version of the FactSales table function as they always have.
 
Search WWH ::




Custom Search