1203
Chapter 53: Building Multidimensional Cubes in Analysis Services with MDX
53
Best Practice
Make the data source view the place where metadata lives. If a column needs to be renamed to give
it context at query time, give it a friendly name in the data source view, rather than rename a measure
or dimension attribute — the two names display side-by-side in the data source view and help future
modelers understand how data is used. Use description properties for nonobvious notes, capturing
the results of research required in building and modifying the model.When creating named queries, you must write the code so that the underlying data provider
can interpret it. For instance, if SQL Server is the relational database behind the scenes,
you must write the named query in T-SQL. Figure 53-4 shows a sample completed DSV.FIGURE 53-4
A completed DSV in Analysis Services.c53.indd 1203c53.indd 1203 7/31/2012 10:30:22 AM7/31/2012 10:30:22 AM
http://www.it-ebooks.info