Open the System | Administration | Server Settings | Services menu.

When prompted, in Password for root, type password.

In the Service Configuration window, Background Services tab, scroll down to find ntpd, and deselect its checkbox. Scroll down to sendmail and uncheck this as well.

Click on the Save button in the toolbar and close this window.

Now open the System | Administration | Network menu; here, you'll find a couple of lines with two devices named eth0.bak and eth0, select eth0 and click on the Edit button.

In the Ethernet Device window, enable the radio button labeled Statically set IP address.

Ask your network administrator for details here, and fill in the Address, Subnet mask, and Default gateway address fields.

You may need to move up the window to see the bottom; click on OK (the rightmost).

Now go to the Hosts tab, select the line with Vertica and click on Edit.

Change the Address field and write the same IP that you used in step 7, then click on OK.

From the File menu, select Save and click on OK, and then close this window.

Open System | Shutdown and hit Restart.

When the machine reboots, go to System | Administration | Network.

Check that the DNS tab reflects the correct Primary DNS for your network, change it if needed, as shown in the following screen capture:

Reboot the machine. When it restarts open the Applications | Accessories | Terminal menu.

In the Terminal window, type admintools.

In the blue screen that appears, use the arrow keys to select the row Accept and press the Space bar to check it; then press the Enter key.

In the Main Menu tab of this window, select Exit and press Enter.

When you're back to the command prompt, type:

  /opt/vertica/sbin/install_example VMart

The example data installation can take a little while, when it's finished, type the following command:

  /opt/vertica/bin/vsql

This is the Vertica database command-line SQL utility. Now type:

  Select count(*) from store.store_sales_fact;

The result shows a row count of 5 million. Type \q to quit vsql and close the terminal with exit.

Run C:\install\vertica-client-6.1.2-0.32.exe and click your way to the end of the installation accepting the defaults and click on Finish.

Go to Start | All Programs | Administrative Tools | Data Sources (ODBC) to open the 32-bit ODBC Data Source Administrator (if you're on 64-bit Windows, it's in the SysWOW64 folder).

Click on System DSN and hit the Add… button.

Select the Vertica driver and click on Finish, you'll see the following dialog box:

In the Vertica ODBC Data Source Configuration dialog, type these case-sensitive parameters (change the IP according to your network, as per step 7 in the Getting ready section):

Click on OK and then on OK again to close the ODBC Data Source Administrator.

Now open the MicroStrategy Desktop application and log in with Administrator and the corresponding password.

Right-click on MicroStrategy Analytics Modules and select Create New Project….

Click on the Create project button and name it VERTICA, uncheck Enable Change Journal for this project and click on OK.

When the wizard finishes creating the project, click on Select tables from the Warehouse Catalog and hit the button labeled as New….

Click on Next and type HP Vertica in the Name textbox of the Database Instance Definition window.

In this same window, open the Database type combobox and scroll down until you find Vertica 6.0. Click on Next.

In Local system ODBC data sources, pick HP Vertica and type dbadmin in Database login and password in the Password textbox.

Click on Next, on Finish, and then on OK.

When the Warehouse Catalog window appears, pick customer_dimension, product_dimension and store_sales_fact, and move them to the right of the shopping cart. Then select all the three tables in the right side, right-click on them and choose Import Prefix.

Click on Save and Close and then on OK twice to close the Project Creation Assistant.

You can now open the project and update the schema.

Go to the Schema Objects | Attributes folder, and create a new Product attribute with these columns:

Create a new Category attribute with this column:

Set the Product attribute as a child of Category.

Go to the Fact folder and create a new Sales Dollar Amount fact with the sales_dollar_amount column from the stores_sales_fact table.

Go to the Public Objects | Metrics folder and create a new Sales Dollar Amount metric based on the Sales Dollar Amount fact with Sum as aggregation function.

Update the schema.

Go to My Personal Objects | My Reports and create a new report with the Category attribute and the Sales Dollar Amount metric, see image: