Create a Measure - BI

Question

Create a Measure - BI

Steve Jones - SSC Editor

SSC Guru

Points: 734449
More actions
January 31, 2014 at 9:20 am

#281811

A basic article for users that shows how to create a measure. Not choose, but create with screenshots and code.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Jim Mackenzie Hall of Fame Points: 3728 More actions · Answer 1

Hi Steve,

Would this just need to be creating the measure group in SSDT? If you're creating a warehouse and then populating it with data, before creating a new cube in SSDT it sounds like a bigger article with a number of sections:

1: Creating the data warehouse (creating dimensions and fact tables, assumption would be that the ETL has been taken care of)

2: Creating a new SSAS solution in SSDT

3: Connecting to a data source and adding dimensions and facts to the DSV

4: Creating dimensions

5: Creating measures

6: Creating calculated members

7: Connecting to the cube and querying the new measures using MDX and Excel

Do you have a deadline, or is it just a 'complete when you can' ?

Cheers,

Jim.

SQL SERVER Central Forum Etiquette[/url]

Steve Jones - SSC Editor SSC Guru Points: 734449 More actions · Answer 2

It's a complete when you can.

In terms of content, the whole idea is to focus. Assume that someone has done 1-4, and just focus on the measures. How do you create one in the technical sense. This is probably short.

There are other articles that can be written to cover the other items as well as deciding which measures you need.