Hi folks - I'm completely new to SAS
I am working with SAS 2000, within the Analysis Manager
Lets say I'm only working with 1 dimension and 1 measure
I would like one of my dimensions to be based on a logical evaluatio
of data (i.e. if field A = 'X', then 'GOOD' else 'BAD'). This woul
create two distinct possible values for this dimension
This could be done in an underlying view, but I'm hoping it can b
done in the cube
I've experimented with calculated members, and custom rollups an
haven't gotten anything to work..
THANKS

You description is a little vague, but I think you are on the right
track with views. It's extremely common to use views over the top of
underlying data to facilitate the OLAP process. Some might even call
it a "best practice". The common nature of this approach in Analysis
Services 2000 is probably what lead microsoft to create the semantic
layer known as the Universal Data Model (UDM) in 2005.

Typically I recommend using a view with a CASE statement in it to return the
"Good" and "Bad" values.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"akinator" <akandl (AT) yahoo-dot-com (DOT) no-spam.invalid> wrote

Thanks guys - I appreciate the responses