Mean MDX

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

Hi all,

I have a single cube with a single measure (count), I also have several
dimensions.

I need to calculate the mean of the total count for a dimension by another
dimension.

I am unsure how to go about calculating a count of my dimension.

I am using SQL2005.

Thanks for your help.


.

Relevant Pages

  • OLAP Distinct Count question
    ... Can I create multiple distinct count measures based on the same measure ... field in the fact table for different dimension attributes in a single cube? ... I need the distinct count measures on two dimension ... Therefore at row grouping 1 will show the correct distinct ...
    (microsoft.public.sqlserver.olap)
  • Re: Mean MDX
    ... The count of the members of my dimension changes depending upon another ... This will filter the data to all customers that have been to our store ... I have a single cube with a single measure, ...
    (microsoft.public.sqlserver.olap)
  • Re: Disable Aggregate Functions for a Specific Measure Along a Specific Dimension in AS 2000?
    ... I had read documentation that had said that IIF ... there is no way to cache any aggregation ... It can be applied in the Cube Editor without modifying shared dimension ... calculating and caching a non-sensical aggregated measure. ...
    (microsoft.public.sqlserver.olap)
  • Re: Calculated Member Basics (Newbie Question)
    ... calculating the ranges on import is the best way to go. ... With this logic encoded into the dimension table you are ... > calculated dimension of age range ... > age range category when I built my data source. ...
    (microsoft.public.sqlserver.olap)
  • RE: Error Designing Caluclated Member
    ... I am back on this issue ...I have added the dimension Calendar ... District, Branch, Building (and the building property Headcount)). ... Now all levels are calculating the total sum of the headcount ... > Thanks Peter, ...
    (microsoft.public.sqlserver.olap)