August 3, 2009 at 6:54 am
hi,
I want to creat ea recursive hierarchy in my dimension table:
IDCREDITLIBELLECREDITIDCREDITP
1travaux 10
2autre 10
3etudiant NULL
4conso NULL
5open NULL
6creditAuto11
7consoAuto 11
8invest NULL
10habitat NULL
11auto NULL
But I don't know how to do in SSAS 2008? I start with "add new dimension" I select key column and name column but there is nothing to say a relation parent children in that application??
August 3, 2009 at 7:24 am
Have you kept running through the wizard? From memory the P/C 'question' screen is at least 5-7 screens in to the wizard.
Steve.
August 4, 2009 at 11:23 am
You need to go into the data source view and define the relationship between the two columns within the table. Once you do this the wizard will pickup on the fact that it is a parent-child relationship.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply