Re: Single Cube from Multiple sources
- From: Barclay <barclayw@xxxxxxxxx>
- Date: Mon, 20 Aug 2007 13:00:17 -0000
I think your errors are coming from not being able to query one server
from the other (as a linked server).
You can work around this.
1. Don't draw relationships in the DSV between tables that can't be
queried in the same query.
2. Manually add the dimensions to the fact table in the cube using a
"referenced" relationship.
The designer in VS lets you add tables from multiple data sources, and
it lets you draw relationships between them. But when you try to
process the resulting cube, SSAS generates a query that accesses all
related tables, and it must do so from only one server. If you look
at the SQL, you'll see that SSAS is creating a subquery of just the
key of the related table, and joining the subquery to the main table
on the foreign key. I think it calls this "materializing the
relationship." This behavior is actually triggered by a normal
dimension to fact table relationship that you set up in the cube
designer and that is generated by the existence of the lines in the
DSV.
One limitation is that you can't chain together referenced dimensions,
but you get the separation that you're looking for.
On Aug 17, 1:37 am, Satyajit Rout <satyajitr...@xxxxxxxxx> wrote:
Hi,....
Could anybody help me on this urgently ?
Can we build a single msas 2005 cube from multiple datasources ? E.g.
I would like to keep all my dimensions in SQL Server 2005 DB and Fact
table in Oracle source. I am unable to achieve this. I receive
following errors in different oracle provider
.
- References:
- Single Cube from Multiple sources
- From: Satyajit Rout
- Single Cube from Multiple sources
- Prev by Date: Re: Time Dimension Browse problem
- Next by Date: OLAP cube build with Project Server 2007
- Previous by thread: Single Cube from Multiple sources
- Next by thread: List of Analysis Services Servers
- Index(es):
Relevant Pages
|
