O'Reilly logo

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition by Sherry Li, Tomislav Piasevoli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a reporting dimension

Now that everything is set up, we can enter the metadata in the Excel file, create a dimension in the SSAS database, and add it to the cube.

Getting ready

Open the Metadata.xlsx file that you saved in the previous recipe. It's time to put some data in it.

Add the following data in the corresponding columns:

ID

Name

Description

Parent_ID

S

Sales Indicators

Placeholder

S01

# of Customers

S

S05

# of Orders

Internet Orders + Reseller Orders

S

S06

# of Internet Orders

S05

S07

# of Reseller Orders

S05

S12

Reseller Sales (in 000)

S

S16

Internet Sales (in 000)

S

S18

Product Sales (in 000)

S

I

Internal Indicators

Placeholder

I01

Headcount

Number of employees

I

I02

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required