Thresholds: Using the Banded by Stated Score (Advanced)

Not many people know and I got a chance to use it on a project.  But if you have thresholds down to your member level, it would be great to automatically have your banding change with it right?  Well, there is this little known feature, that a lot of people glance over, is “Band by Stated Score (Advanced)” that will allow you to do it.  Here are some simple steps to get started using it.

First and foremost, you need a measure for banding that relates to your members within the fact table.  If you don’t, you could use fixed values to see how it works.

1.  Change your Banding method to “Band by stated Score”

2. Click the Specify Data Mapping button

3. Now map your threshold to the appropriate measure in the cube.

4. Oops, forgot to mention that your banded stated score needs to be returned is a simple decimal.  You can figure our the calculated measure you will need to create in SSAS.   Look at the following example of my banding.  Pretty straight forward.

Now publish it and give it a try! 

Later

Patrick

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