Hi !

Does anyone know a tool to graphically create parent-child-dimensions based
on an RDBMS, so that I can process them in analysis server ?

TIA
Kalle

AS includes that kind of wizard when creating a dimmension. Is that what u r
looking 4?

--
ALEJANDRO LEGUIZAMO
Colombia - SQL Server MVP


"Kalle" <KHeuwes (AT) zeb (DOT) de> wrote

Hola, Alejandro !

Thank You for Your reply.

I'm looking for a tool, to create the relationships by drag and drop.

Example:
I have a product dimension with the following products.

ID NAME
10 Drinks
20 Food
11 Water
12 Beer
21 Bread
22 Meat

To create the hierarchy I want to drag "Water" on "Drinks" and the tool
creates a record in a relational table like this:

ID PARENTID NAME
10 10 Drinks
11 10 Water

Thank You
Kalle

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Havent heard of a tool....you need to do it with sql - this is one the
"cleansing" types you need to perform before putting it into AS. There are
different approaches

1) snowflaking (sql server bi accelerator) - here you'll have a table for
each level in your dimension and in AS you link these tables together in
dimension editor (i prefer this)
2) parent-child - as you're mentioning - you need to do something in sql
with these as well (could be tables or could be views)

But as I interpret you're structure x0 = headline...so 10 (father) is a
headline and 20 is a headline / father - so heres a quick version for
solving number 2:

select id, id as fatherid, name from products
where right(id,1)='0'
union all
select id, left(id,1)+'0' as fatherid, name from products
where right(id,1)<>'0'

You can create a view with this statement by adding create view (viewname)
as before the select-statement.

\Michael

"Kalle Heuwes" <karlheinz.heuwes (AT) web (DOT) de> skrev i en meddelelse
news:uVA$749OEHA.628 (AT) TK2MSFTNGP11 (DOT) phx.gbl...