Enhancing the Basic Cube with The Cube Editor
We will now expand our
cube to include data from the individual tables associated with the dimensions
we have already selected for our minimal cube, as well as making other
enhancements to flesh out our cube model for financial reporting.
From the Analysis Manager
console, expand the Analysis Servers folder (as appropriate), then expand the
Analysis Server name (shown as MOTHER), to see the underlying databases,
as illustrated below.
29: Expand the Analysis Server
NOTE: Factors specific to our individual environments, such as the
presence of additional Analysis Servers, as well as other databases, will mean
the appearance of varying objects here.
- Expand the FinRep_DB database to see the
underlying folders, as displayed in Illustration 30 below.
30: Expand the FinRep_DB Database
We will now extend our
cube to include data from the respective dimension tables, among other
enhancements. First, we will add the dimension tables we require to the
existing core cube, and derive more useful dimension data thereby, using the
From the cube tree, click the
new Fin_Rptg cube to select it.
Right click Fin_Rptg cube, and
select Edit, as shown below, from the context menu that appears.
Select Edit to Call the Cube Editor
Cube Editor appears to display the initial expense_fact table
presented in the data tab, just as we left it above.
Click Insert from the Main
Click Tables from the menu that
appears, as shown.
Insert à Tables from the Main Menu
Table dialog appears.
Select the store table by
clicking / highlighting it.
section of the dialog becomes populated with the columns of the store
table. The Select Table dialog now appears as shown in Illustration 33.
The Select Table Dialog, Store Table Selected
Click the Add button (once