Home > BISM, SQL 12, Tabular Mode > It takes 4 Clicks to Build a Model (Cube) in Denali Tabular Mode

It takes 4 Clicks to Build a Model (Cube) in Denali Tabular Mode

Click 1 – Create a Tabular Project

image

Click 2 – Import Tables (Master / Facts) from DW

image

image

Click 3 – Adding Measure

As you can see I have added 2 Measures –

Sum (TotalProductCost)

Sum of TotalProductCost:=SUM([TotalProductCost])

Sum of SalesAmount:=SUM([SalesAmount])

image

Click 4 – Viewing Cube in Excel

Click on Excel Symbol on Tool Bar, this will open Cube in Pivot Table

(Ensure that Excel is installed in your workstation)

image

In PivotTable – Selected Color (Product – Color) Attribute and two Measures which we had created

image

image

Advertisements
  1. No comments yet.
  1. January 11, 2012 at 9:17 pm
  2. January 16, 2012 at 12:33 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: