SQL Server Analysis Services 2005/2008 articles,blogs,scripts,FAQs,tools,books

Strategy Companion
We have 91 guests online
  • Home
  • Newsletter
  • Books
  • Tags
  • Polls
  • Advertise
  • Contact Us
  • PowerPivot

Current Tags: distinct countremove tag


Available Tags: 2005, article, design, faq, mdx, must read, paper, performance, tip
TitleSectionDate
An Alternative to a physical Distinct Count MeasureArticles6/12/2008
Counting distinct values in MDXArticles15/6/2008
Analysis Services Distinct Count OptimizationPapers19/4/2008
Break distinct count measures into separate measure groupsTips19/6/2007
Distinct Counts in Analysis Services 2005 (by William Pearson)Articles12/6/2007
Optimizing your distinct count calculation in Analysis Services (By Denny Lee)Articles19/5/2007
How do you create distinct count measure in the separate measure group from the same fact tableFAQ4/5/2007

Main Menu

  • Home
  • SSAS News
  • SSAS Papers
  • SSAS Articles
  • SSAS Webcasts
  • SSAS/MDX FAQ
  • SSAS Scripts
  • SSAS Cheat Sheets
  • SSAS Tips
  • SSAS Books
  • ---
  • SSAS Client Tools
  • SSAS Tools
  • ---
  • SSAS Implementations
  • SSAS Jobs
  • SSAS Consultants
  • SSAS Authors
  • ---
  • SSAS Forums
  • SSAS Blogs
  • Vidas Matelis Blog
  • SSAS Newsletters
  • Message to authors
Strategy Companion
 
Subscribe to our free monthly newsletter. Get all the latest news about Analysis Services. Examples here.
RSSNews
RSSArticles
Book
blank

Featured articles

  • SSAS 2008 Changes
  • "Must Read" articles

Login Form



  • Forgot your password?
  • Forgot your username?
  • Create an account

Forum posts

  • Finding rolling costs for 13 months
  • Re:Access Parent Child hierarchy and other members
  • Access Parent Child hierarchy and other members
  • ADOMD.NET Connection Error
  • Running same XMLA against multiple dbs in instance
More...
Strategy Companion
blank
ESS BI
blank
SQL Sentry Performance Solution
blank

Quick Poll - Please vote

What is the most important feature for you in the BIDS Helper utility?
 
Read more about BIDS Helper here

Jobs

  • Data Visualization Specialist - Oslo, Norway
  • BI Architect opportunity, NJ, long term consulting

SSAS Random Tip

If you want to browse the cube and validate dimensions, hierarchies and calculations using the data from only one partition, here is what you can do.  Deploy the new cube solution, run a process structure for the cube and then process only one of the partitions.  Process Structure will process all the dimensions plus mark all the measure groups as processed.  That way, you can start browsing your cube with all the dimensions and one small partition processed.

From Nicholas Dritsas blog.

2007-2008 VidasSoft Systems Inc.
larger smaller reset fixed-width fluid-width