Newbie MDX Question - How do I "freeze" or lock a value?

Hello,

I have a fact table that contains employee records by Fiscal Year and month.
In order to do some of my calculations (turnover), I need to get the
headcount at the beginning of the year and at the end of the year - that
works, sort of.

I need that same headcount (as the start and the end of the year) to be used
for each of the months in the year. The problem is that the headcount does
change because employees are added or subtracted as the year goes on. I
thought of adding in the employees, with their starting headcount to each
month and only giving them a BeginningHeadcount value and keeping their
other values as zero. That way I could calculate on them but not effect any
other calculation. My fear is that I am going to run into problems doing
this - such as an inaccurate fact table.

My hope is that there is a formula or method to get the value and apply it
appropriately. Is there a way?

I am very familair with relational databases, SQL and general programming,
but this data warehouseing and MDX is all brand new to me (but very cool).

Thanks for the help.

-Gummy

p.s. I am using Analysis Services 2005.


.

Relevant Pages

  • Re: Newbie MDX Question - How do I "freeze" or lock a value?
    ... Kimball's method) to do this kind of calculations. ... I need that same headcount to be used ... change because employees are added or subtracted as the year goes on. ... but this data warehouseing and MDX is all brand new to me. ...
    (microsoft.public.sqlserver.olap)
  • Re: Newbie MDX Question - How do I "freeze" or lock a value?
    ... The beginning headcount only appears in the first month and the ... Kimball's method) to do this kind of calculations. ... change because employees are added or subtracted as the year goes on. ... this - such as an inaccurate fact table. ...
    (microsoft.public.sqlserver.olap)
  • Counting .5 in a pivot table
    ... I have a pivot table of employees. ... are counted as .5 headcount. ...
    (microsoft.public.excel.worksheet.functions)
  • Publishing a pivot table on the web
    ... calculations, sick days, pay and so on for all my employees for the ... such as pay pr hour for other employees. ... Additionaly I would like to publish a calculated field containing ... To do this only with calculations and not with pivot tables is very ...
    (microsoft.public.excel)
  • Re: Expressing fractions
    ... zero-point-six-five meters ... > Seventy-five percent of my employees are women. ... The Annual Percentage Rate and some other approximations are ... approximate interest calculations are still in use today. ...
    (sci.lang)