Hello Experts,
I have a dimOrganization database table. And I want to create a parent child relationship on SSAS.
Here is my table structure:
CREATE TABLE [dbo].[DimOrganization](
[OrganizationKey] [int] IDENTITY(1,1) NOT NULL,
[ParentOrganizationKey] [int] NULL,
[OrganizationName] [nvarchar](50) NULL
) ON [PRIMARY]
GO
And the dataset is like this:
INSERT INTO DimOrganization VALUES ('','RP')
go
INSERT INTO DimOrganization VALUES (1,'DC')
go
INSERT INTO DimOrganization VALUES (2,'KAR')
go
INSERT INTO DimOrganization VALUES (3,'KARD')
go
INSERT INTO DimOrganization VALUES (3,'KARB')
go
INSERT INTO DimOrganization VALUES (1,'EKO')
go
INSERT INTO DimOrganization VALUES (6,'EKOD')
go
INSERT INTO DimOrganization VALUES (6,'EKOD')
go
My only purpose is get a result in SSAS such as:
-->RP
--------> DC
-------------------->KAR
---------------------------->KARD
---------------------------->KARB
-------------------->EKO
---------------------------->EKOD
---------------------------->EKOB
Thanks and Regards