Linked Object Wizard in SSAS - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

Linked Object Wizard in SSAS

Author

Topic

ABHISEK.K.S
Starting Member

3 Posts

Posted - 2011-04-06 : 03:46:34

Hi,
I need to merge same named cubes(also same dimension table and fact table, but data's are different) from different server to one main server SSAS database.I tried using LINKED OBJECT WIZARD. while merging, two dimensions table and measures table created, but i need to merge in the one measure and dimensions.

Example:

test-server: cube name : test-model , fact-table name:fact_test,dimension table name: dim-test

test-server: cube name : test-model , fact-table name:fact_test,dimension table name: dim-test.

I need to pull of data's of two test server to main server.

Main server: cube name : test-model , fact-table name :fact_test,dimension table name: dim-test.

After the result of LINKED object wizard merging: datas are not merging in the main server. instead of that, tables are merging with new name

Ex: Dim-test1,fact_test1

while browsing the data's in the cube browser. dim-test1, dim-test , fact_test1,fact_test is coming as different measures and dimensions, but i need it in one dimension and measures.

How to do?

I need to change any options in Linked object wizard?

I am a beginner . please Help..........

Thanks in advance..

ABHISEK

sasmita
Starting Member

1 Post

Posted - 2011-04-06 : 08:03:27

hi,
i need that how to use condition in ssas cube
example

select top(10) vv.EndCustomer as endcustomer,round(avg(vv.GrossMarginQuoted),2) grossmagin,avg(vv.Revenue ) revenue from
(select q1.EndCustomer,
case
when
gm.AdjPrice!=0 then

((SUM(gm.AdjPrice)-SUM(gm.QuoteMfrCost))/SUM(gm.AdjPrice) * 100)
else
0
end as GrossMarginQuoted,
round(SUM(ItemQty*q1.AdjPrice)/1000,2) as Revenue from QuoteLogRPT as q1
left outer join
DimProduct dp on dp.booking_part_no = q1.PartNo

left outer join
GrossMargin gm on gm.PartNo=q1.PartNo and gm.DistributorId=q1.DistributorId
where q1.QuoteLineStatusId=52 and
q1.ModifiedDate>=(select MIN(d1.Dates)from DIMTIME as d1
right outer join CurrentDate as c
on d1.PeriodQuarter=c.PeriodQuarter and d1.PeriodYear=c.PeriodYear and
q1.ModifiedDate <=CAST(GETDATE() as date))
group by q1.EndCustomer,gm.AdjPrice)as vv
group by vv.EndCustomer
order by grossmagin desc

here how i implement groupby and the condition after where clause

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources