November 19, 2009 at 12:10 pm
I am new to SSAS, I am trying to create my first cube, I have the data in a single table. I need to create the fact and dimension tables based on that table. All the aggrgations have already been done in that table that's provided to me.
I need to get the following output when browsing the cube, also attached the sample data below:
Date filters: MOnth,year
ResellerName
Regionname
Performance RegionAverage
Productivity
Membership 400670
Service
Complaints 0 2
CustSatisfaction 0 4
CREATE TABLE #Temp
(
month_year VARCHAR(100),
Resellername VARCHAR(100),
Regionname VARCHAR(100),
Performance numeric(12, 4),
RegionAverage numeric(12, 4),
Area VARCHAR(100),
Title VARCHAR(100)
)
INSERT INTO #Temp (
month_year,
Resellername,
Regionname,
Performance,
RegionAverage,
Area,
Title
)
SELECT '2009-01-01 00:00:00.000', 'Reseller1','Region1',400,670,'Productivity','Membership'
UNION ALL
SELECT '2009-10-01 00:00:00.000', 'Reseller2','Region2',0,2,'Service','Complaints'
UNION ALL
SELECT '2009-10-01 00:00:00.000', 'Reseller2','Region2',0,4,'Service','CustSatisfaction'
SELECT * FROM #Temp
--DROP TABLE #Temp
November 19, 2009 at 1:42 pm
Mh-397891 (11/19/2009)
I am new to SSAS, I am trying to create my first cube, I have the data in a single table. I need to create the fact and dimension tables based on that table. All the aggrgations have already been done in that table that's provided to me.I need to get the following output when browsing the cube, also attached the sample data below:
Date filters: MOnth,year
ResellerName
Regionname
Performance RegionAverage
Productivity
Membership 400670
Service
Complaints 0 2
CustSatisfaction 0 4
The display seems to be weird what you wanted to show, can you put that in a excel and take a screen shot of that and attach here.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 19, 2009 at 2:20 pm
Here is the attachment that will be the output upon browsing the cube. Thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply