Autoexist in AS 2005 cubes
- From: "Thomas Ivarsson" <TI@xxxxxxxxxx>
- Date: Wed, 14 Dec 2005 22:46:40 +0100
With Autoexist I thought that AS 2005 would finally work as a relational
database "inner join" between dimension tables and fact-tables. My thought
was that if I put a customer dimension, with 3000 members, together with a
product dimension, with 2000 members, on the row axis, I would only see the
valid combinations of Customers and Products, actually bought, in a sales
AS-2005 cube. Not a relational crossjoin between Customers and Products.
After reading comments from Chris Webb I realize that this is not correct,
or?
What You actually mean(MS) is that this is only valid for a single dimension
and the "attribute hierarchies" and "user hierarchies" within that
dimension?
If this is correct I cannot get this to fit with the talk of the UDM as a
source for all types of reporting and analysis. I will still have to use
TSQL and reporting services to get only the real combination of Customers,
Products and Facts that have occurred in Sales?
Regards
Thomas Ivarsson
.
- Follow-Ups:
- Re: Autoexist in AS 2005 cubes
- From: Akshai Mirchandani [MS]
- Re: Autoexist in AS 2005 cubes
- Prev by Date: Re: XMLA/ASSL help AS2005
- Next by Date: Re: AS 2005 HTTP access with Basic Authentication
- Previous by thread: Re: Partition disk layout
- Next by thread: Re: Autoexist in AS 2005 cubes
- Index(es):
Relevant Pages
|
