dbTalk Databases Forums  

Attribute members grouping in MSAS 2005 problem

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Attribute members grouping in MSAS 2005 problem in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
svega
 
Posts: n/a

Default Attribute members grouping in MSAS 2005 problem - 12-14-2006 , 12:56 PM






Hi,

I am trying to use attribute members grouping and getting an error. I have a
natural hierarchy that looks like:

Sector
Industry
Exposure
Position

The Position level has many members that I would like to place in buckets of
equal size. However when I set the DiscretizationMethod of Position
attribute to Automatic and try to deploy the database I get an error: "Error
in the metadata manager. The 'Position' discretisized attribute cannot have
related attributes". The error is only reported during deployment. It's a
natural hierarchy with attribute relations defined so that Position
attribute relates to Exposure attribute and so on. It's a 64-bit instance of
MSAS 2005 with SP2 CTP applied. If discreditized attributes cannot have
related attributes then how does one place them into a natural hierarchy? Or
maybe I am doing something wrong? I hope someone can shed some light on this
issue.

Thanks in advance,

Alex



Reply With Quote
  #2  
Old   
Ohjoo Kwon
 
Posts: n/a

Default Re: Attribute members grouping in MSAS 2005 problem - 12-14-2006 , 11:39 PM






I understand it's not logical to use the attribute hierarchy as a user
hierarchy level
when AS cannot determine which Exposure member a certain Position group
belongs to.

For example, two position members in the same group can have different
Exposure members as a parent member.

How about adding a dummy attribute to group Position members explicitly
instead?

Ohjoo

"svega" <krichev (AT) bellatlantic (DOT) net> wrote

Quote:
Hi,

I am trying to use attribute members grouping and getting an error. I have
a natural hierarchy that looks like:

Sector
Industry
Exposure
Position

The Position level has many members that I would like to place in buckets
of equal size. However when I set the DiscretizationMethod of Position
attribute to Automatic and try to deploy the database I get an error:
"Error in the metadata manager. The 'Position' discretisized attribute
cannot have related attributes". The error is only reported during
deployment. It's a natural hierarchy with attribute relations defined so
that Position attribute relates to Exposure attribute and so on. It's a
64-bit instance of MSAS 2005 with SP2 CTP applied. If discreditized
attributes cannot have related attributes then how does one place them
into a natural hierarchy? Or maybe I am doing something wrong? I hope
someone can shed some light on this issue.

Thanks in advance,

Alex




Reply With Quote
  #3  
Old   
svega
 
Posts: n/a

Default Re: Attribute members grouping in MSAS 2005 problem - 12-15-2006 , 10:25 AM



I totally agree with this. There does not appear to be a way for AS to
figure the relationship. However coming from AS2000 world I was looking for
something similar in AS2005. Thanks for the suggestion. It looks like
explicit grouping is the only way to go.



Alex



"Ohjoo Kwon" <ojkwon (AT) olap (DOT) co.kr> wrote

Quote:
I understand it's not logical to use the attribute hierarchy as a user
hierarchy level
when AS cannot determine which Exposure member a certain Position group
belongs to.

For example, two position members in the same group can have different
Exposure members as a parent member.

How about adding a dummy attribute to group Position members explicitly
instead?

Ohjoo

"svega" <krichev (AT) bellatlantic (DOT) net> wrote in message
news:O4u3AC7HHHA.1280 (AT) TK2MSFTNGP04 (DOT) phx.gbl...
Hi,

I am trying to use attribute members grouping and getting an error. I
have a natural hierarchy that looks like:

Sector
Industry
Exposure
Position

The Position level has many members that I would like to place in buckets
of equal size. However when I set the DiscretizationMethod of Position
attribute to Automatic and try to deploy the database I get an error:
"Error in the metadata manager. The 'Position' discretisized attribute
cannot have related attributes". The error is only reported during
deployment. It's a natural hierarchy with attribute relations defined so
that Position attribute relates to Exposure attribute and so on. It's a
64-bit instance of MSAS 2005 with SP2 CTP applied. If discreditized
attributes cannot have related attributes then how does one place them
into a natural hierarchy? Or maybe I am doing something wrong? I hope
someone can shed some light on this issue.

Thanks in advance,

Alex






Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.