Creating Parent Child Hierarchies

Hi
I have the following in my cube
Location Dimension containing LocationID and LocationName attributes.
Customer Dimension containing CustomerID,CustomerName....,LocationID
The LocationID in the Location Dimension and Customer Dimension are related to each other.
I want to create a hierarchy with the LocationName in the First Level and the CustomerName in the second level. How to I accomplish this? As i said I already have a relationship defined between the two tables.

Thanks and Regards
Guruprasad Karnik

This is not a recursive hierarchy from what you are describing.

You can find a recursive hierarchy in the employee table in the Adventure works sample data base that is a part of the SQL server 2005 installation. You use parent-child hierarchies with this type of primary key-foreign key relationship in the same table.

If you download the performance guide for SSAS2005 (see the first post in this forum) and have a look at page 82 and further(Referenced relationsships), you will find a lot of helpful information.

HTH

Thomas Ivarsson

Creating Dimension Template...

Hello,

I need to create a dimension that has pre-defined multiple hierarchies, attributes, and the data source table the dimension will be based on would be different for each customer. (The structure of the data source table would be the same though, just the underlying data would be different)

Thus, I thought about using the dimension template. However, the steps in the dimension template wizard is quite confusing to me. Does any know where to find a good document explanning how to create a dimension template? I read through the MSDN library about creating the template, but it's not too helpful either.

Please let me know if I am heading to the wrong direction, or if there is another good way to do this..... Any help is appreciated.

Thanks,

Hsiao-I

A dimension template is just a regular dimension XML file saved in the following location:

C:\Program Files\Microsoft SQL Server\90\Tools\Templates\olap\1033\Dimension Templates

So all you need to do is create a dimension either using the dimension wizard or manually in the dimenison editor, then go to the file system look for the .DIM XML file correpsonding to this dimension in the project folder where you created your project.

Then just copy this .DIM file to the path above and this dimenison will appear as a template in the dimension wizard.

Now the dimenison template only contains metadata information (so things like attributes, hierarchies...), it doesn't contain dimension members since these come from the underlying data source.

Let me know if this helps.