Databases Reference
In-Depth Information
1. Create a data source to the relational database Dimension and Cell
security relational data source.
2. Create a data source view that includes all the tables from the data
source. Remove the security table from the DSV because this is
primarily used only for defining dynamic dimension security. Create
the joins between the tables as shown in
Figure 19-26
. Browse the
tables Poll Questions, Poll Options, and Results so that you get a
good understanding of the scenario. You will notice there are 25 Poll
questions with responses from each employee stored in the Results
table. Create a calculated column in the employee table so that you
have a column called Full name — this will contain a string concaten-
ation of Firstname and LastName. Enter the name for the calculation
as Name and enter [First Name] + [Last Name] in the expression.
Figure 19-26
3. Run the intellicube wizard to create the cube. You will now have the
UDM as shown in
Figure 19-27
.
Search WWH ::
Custom Search