is this possible in ssas

Question

question

yogi asked May 19, '11

is this possible in ssas

I have data in a table like CHILD_ID PARENT_ID 1 0 2 0 3 2 4 1 5 4 6 1 7 4 8 7 '0' is root and '1' is child of '0' and '4' is child of '1' and '7' is child of '4' and so on the parent child relation goes I wanted to have a tree structure (a structure like I can query for all the childs of a parent)of this. I am completely new to ssas please advise. I am using SQL Server 2008 R2

sql-server-2008 ssas

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2011-05-20T00:37:49Z

Pavel Pawlowski answered May 20, '11

SSAS allows you to create a Parent-Child hierarchies in the Dimensions.. So if in your sample the table will represent a hierarchy, yo can then mark the PARENT_ID attribute as ParentKey and start building the Parent-Child hierarchy in the cube. What more, if the design the parent child relationship in the data source view of SSAS, then when using Create New Dimension Wizard, it will automatically detect this and allows you to create the hierarchy automatically. But probably the table is only the hierarchy part of some other table. So you will probably need to join it with the other table containing the rest of the attributes to construct some usable dimension from it.

4

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

yogi commented · May 20, 2011 at 03:41 AM

i am not sure how to do can u explain or give me a link if possible to do the above process

0 ·

Pavel Pawlowski commented · May 20, 2011 at 12:16 PM

I can recommend you reading [Microsoft® SQL Server® 2008 Analysis Services Step by Step (Step By Step (Microsoft))][1]. Another good source for beginners is [ http://www.learnmicrosoftbi.com][2] Related to subject: [Defining a Parent-Child Hierarchy][3] [Defining Parent Attribute Properties in a Parent-Child Hierarchy][4] [1]: http://www.amazon.com/gp/product/0735626200 [2]: http://www.learnmicrosoftbi.com [3]: http://technet.microsoft.com/en-us/library/ms174846.aspx [4]: http://technet.microsoft.com/en-us/library/ms167115.aspx

0 ·

yogi commented · May 26, 2011 at 01:06 AM

thanks after a serious study of the link provided im able to achieve and found a new problem

0 ·

yogi commented · May 26, 2011 at 01:10 AM

pls check the question with label change in ssas hirarchy

0 ·

Answer 2 · 2011-05-19T21:57:14Z

aRookieBIdev answered May 19, '11

Hi , This is more of a design issue and has nothing to do with SSAS.Before building the SSAS cube , you need to create a UDM Unified Dimension Model which is nothing but Fact Tables (For measures) and Dimension Tables (For dimensions) in database. In your case i think the most appropriate will be Star flake schema where you have hierarchies at dimension levels.(as shown in your example) Other design schemas for UDM are star schema (most common )and fact constellation schema. For more information browse for designing database schema for ssas. Thanks, Kannan

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

yogi commented · May 19, 2011 at 11:35 PM

so, can i modify my table using a tool of ssas and store in the format i want

0 ·

question