using SQL 2005 Analyst Services to build cubes...
my issue involves creating a group category.
I have a dimension which list different States,,Co, AZ, ect.
I also have categories listed in the table as,,West, East, North,,,Happy state, Sad State,
ect....States can have more than one category or group...
How do I create a group in my dimsension or setup my dimsension in order that it will allow me
to display the sites in different categories at the same time.