Hi,

I want to define a product dimension, with an all level, a product group
level and a product level. the tricky thing is, a product can belong to
multiple product groups. the dimension should look like

all products
product group 1
product code 1
product code 2
product code 3
product group 2
product code 1
product code 2
product group 3
product code 3

How could this be done in AS2000?

TIA,

Max

It is not possible in AS2000 since it doesn't support multiple-parent
hierarchy and you will double count the same products in the product level.

"Max McNamara" wrote:

You can use "unary operators" to avoid duplicate rollup.

Below is the threads to discuss the similiar things.

http://groups.google.co.kr/group/mic...39ca429508cdb6

http://groups.google.co.kr/group/mic...343d7d6cac6622

Ohjoo

"Max McNamara" <anonymous (AT) microsoft (DOT) com> wrote

If you are a subscriber of sql magazine, next article written by Russ
Whitney will be helpful.

http://www.sqlmag.com/Articles/Print...rticleID=41215




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

Even if it does not solve your problem (you declared AS2000 as a
prerequisite), SSAS2005 has a solution with many-to-many dimension
relationships.
I described exactly this scenario in this paper:
http://www.sqlbi.eu/manytomany.aspx

Not working with AS2000, some MDX formula is required to make it
working, but it's not a trivial task especially if you have other
calculated members crossing from other dimensions...

Marco Russo
http://www.sqlbi.eu
http://www.sqljunkies.com/weblog/sqlbi

Max McNamara wrote:

thanks to all,

it seems that we have to upgrade to AS2005


"Max McNamara" <anonymous (AT) microsoft (DOT) com> schrieb im Newsbeitrag
news:%23I5x%23Ag9GHA.788 (AT) TK2MSFTNGP05 (DOT) phx.gbl...