SQL AS 2005 Roll up rule

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi. I am working on this SQL Analysis Services 2005 project. I created
my fact table, cube, dimensions and measures. One thing I can't seem
to figure out is to prevent a measure from rolling up to a certain
level. One example is percentage. It does not make sense to roll up to
the percentage totals on that column. But it makes sense to show the
percentage result at the most granular level. Another example is total
accounts receivable by location. This measure fluctuates every month
and it does not make sense to roll up the sum of every month's AR all
the way to the year level, but it makes sense to roll it up to the
location level for a specific month.

Any help would be greatly appreciated.

Thanks

.

Relevant Pages

  • Re: an interesting question. Please answer. Thanks.
    ... a 3 dimensional maneuver through 3 dimensional space. ... By keeping positive g on the airplane AND the controls perfectly coordinated with no slip or skid as the roll is flown, it is possible to keep the water inside the glass on the glare shield. ... That is simply an unloaded roll through 3 dimensions and would of course spill the tea all over the cockpit :-) ...
    (rec.aviation.student)
  • RE: Computing Full Time Equivalent Staffing
    ... I may not appreciate the fine points of what you are trying to accomplish, ... > I am using Project to coordinate a staff of 50 people spread across 15 ... > each task then roll that up to a total number for the entire team. ... > the task totals to a team total. ...
    (microsoft.public.project)
  • Computing Full Time Equivalent Staffing
    ... I am using Project to coordinate a staff of 50 people spread across 15 ... I do this by exporting my data to excel then ... each task then roll that up to a total number for the entire team. ... the task totals to a team total. ...
    (microsoft.public.project)
  • Re: Possible Quick Printer II paper leads...
    ... > under consumables at the bottom. ... roll and a fine bladed hacksaw plus a little care and patience sorted that ... The dimensions of the central tube might be relevant too. ...
    (comp.sys.tandy)
  • Re: HELP!! - Beginner OLAP Modeling problem
    ... What is the size of the fact table, and of the dimensions? ... you could roll up the service level from the individual fact records (if ...
    (microsoft.public.sqlserver.olap)