How do we implement score carding in Analysis Services?
I believe there are some third party tools that work well with AS on this, but i wanted to know if I needed any specific feature in my data model or cube for this?
do I put in the goals as a dimension in the cube?

Also wanted to know how i can avoid aggregations - i have data in my fact table, that i don't want to aggregate

I am new to AS and this is very urgent. Any help would be more than welcome


thanks

--
Message posted via http://www.sqlmonster.com

You can either put goals and actual in a category dimension but your fact
table will need to have such column with a category identifier, or if you
can create a separate measure gro your goals.

Either way will work with the Microsoft Scorecard addin which can be found
on Microsoft.com
http://www.microsoft.com/downloads/d...DisplayLang=en

Thierry

"tarana halsall via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote