Re: Newbie MDX Question - How do I "freeze" or lock a value?
- From: "Marco Russo" <marco.russo@xxxxxxxxx>
- Date: 15 Jan 2007 00:32:26 -0800
I suggest you to consider the use of snapshot tables (refer to
Kimball's method) to do this kind of calculations.
While with MDX can be possible to get the right measure, it could have
performance issues if you have large volumes of data and if users want
to use that measure intensively.
Marco Russo
http://www.sqlbi.eu
http://www.sqljunkies.com/weblog/sqlbi
Gummy wrote:
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.
.
- Follow-Ups:
- References:
- Prev by Date: Newbie MDX Question - How do I "freeze" or lock a value?
- Next by Date: calculation the median
- Previous by thread: Newbie MDX Question - How do I "freeze" or lock a value?
- Next by thread: Re: Newbie MDX Question - How do I "freeze" or lock a value?
- Index(es):
Relevant Pages
|
