Re: UDM approach/concept in real

Marcel,

the actual UDM is not able to do this kind of integration. UDM today is
the model defined in Analysis Services, that you query with MDX only
(you could use also SQL via OLE/DB provider for Analysis Services, but
it is somewhat limited).

Today the best way to get your consolidation is to build a rock solid
data warehouse with all your data, and build a UDM on this.

This post is, of course, not very marketing-oriented... :-)

Marco Russo
http://www.sqlbi.eu
http://www.sqljunkies.com/weblog/sqlbi


Marcel Sottnik wrote:
Hi NG

Everyone talks about UDM and consolidating heterogenous datasources (OLTP, OLAP, flatfiles) into one cube and one
dimensional model. However, I didn't find any example of such an implementation. Could someone provide us with something
like that?

BG
Marcel

.

Relevant Pages

  • Re: UDM approach/concept in real
    ... The reason for my suggestion is that UDM (and Analysis Services) are ... Marco Russo wrote: ... Anyway, the reason, I chose SQL 2005 for our DWH was exactly, the possibiliy to "unite" multiple different datasources ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: UDM approach/concept in real
    ... In the M$'s own famous document from MSDN propagating new UDM concept is clearly stated, that this is possible with current implementation of AS. ... the model defined in Analysis Services, that you query with MDX only ... data warehouse with all your data, and build a UDM on this. ... Everyone talks about UDM and consolidating heterogenous datasources into one cube and one ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: OLTP vs OLAP (Data Warehouse) as a DataSource in Analysis Services 2005
    ... "SQL Server 2005 Analysis Services can create UDM cubes without the ... intermediate step of building a star schema data warehouse. ... in a star or snowflake schema, but can connect to any data source ...
    (comp.databases.ms-sqlserver)
Loading