MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition

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