Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gwilson67

    AND type in (N'U'))

    U type stands for user created object. Greg http://www.freewebstore.org/tsqlcoderepository Powerful tool for SQL Server development
  2. gwilson67

    Question about indexing

    That wouldn't be a good choice for an index because it has a high number of duplicates. Greg http://www.freewebstore.org/tsqlcoderepository Powerful tool for SQL Server development
  3. gwilson67

    Limiting dimensional data that is only relative to the fact data?

    LC, What I would do to limit dimension data to ONLY data that is in the fact table is to create a partition filter. In your example, you used Store 1 -3 in dimension and just store 1 in fact table. In the Partition filter for the cube, you would type in where database.dbo.store.storename =...
  4. gwilson67

    Book recommendations

    Hello, A few good books to get started with Olap are: 1) Analysis Server Step by Step 2) Fast Track To MDX I recommend both of these books to the students that I teach.

Part and Inventory Search

Back
Top