How can i this - sometimes i need include invoice numbers in reports
(fact table size 2475797, distinct invoice numbers 177014). Nonempty
crossjoin - products,customers and invoices( invoice_status,invoice
number with auto grouping parent) is very slow

One might argue that invoice detail like this isn't best suited for OLAP.
When clients say they want things like order numbers or invoice numbers in a
cube, I try my best to discourage it, since invoice and order numbers are
usually detail attributes that don't really aid in analysis. If you have an
invoice number dimension (a dimension with invoice number as the lowest
level), or you have a member property for it, I'm afraid you'll be paying a
performance price either way. The more appropriate way to handle this would
be via SQL reporting, if it's an option.

"Bartosz Gorzynski" wrote:

This is not a sweet spot for traditional OLAP; but if the brave new
world of AS 2005 UDM is an option, then you might want to watch this
webcast on Aug.15:

http://www.microsoft.com/events/Even...ource=MSCOMMed
ia&Params=%7eCMTYDataSvcParams%5e%7earg+Name%3d%22 ID%22+Value%3d%2210322
76878%22%2f%5e%7earg+Name%3d%22ProviderID%22+Value %3d%22A6B43178-497C-42
25-BA42-DF595171F04C%22%2f%5e%7earg+Name%3d%22lang%22+Valu e%3d%22en%22%2
f%5e%7earg+Name%3d%22cr%22+Value%3d%22US%22%2f%5e% 7esParams%5e%7e%2fsPar
ams%5e%7e%2fCMTYDataSvcParams%5e
Analysis Services (Level 300)

Summary

See how you can use Microsoft SQL Server 2005 Analysis Services with the
Unified Dimensional Model (UDM) to develop a wide range of reporting
applications that use a variety of delivery mechanisms. Join this
webcast and learn about the different approaches available for
distributing information to the spectrum of users throughout an
enterprise, including Microsoft SQL Server 2005 Reporting Services,
Microsoft Office, and Microsoft SharePoint Portal Server. Regardless of
your end users' skill level, they can benefit from the data integrity
inherent in the UDM while accessing information through the delivery
mechanism best suited to their needs. See how to give them access
through highly formatted reports, flexible slice and dice, key
performance indicators, or a dashboard interface.*
*
Presenters: Thierry D'hers, Lead Program Manager, and Marin Bezic,
Development Manager, *Microsoft Corporation

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***