Hi

We are currently looking into the feasibility of moving some of our Essbase
cubes to analysis services. One thing I'm not sure how to do is the Essbase
time balance attribute.

One of our measures is start and end head count. If we look at the YEAR
and MONTH the numbers need to look something like this :-

YEAR MONTH START HEAD COUNT END HEAD COUNT

2004 JAN 750 1400
2004 FEB 1400 800
2004 MARCH 800 1200

If we look at the YEAR and QUARTER we want the start headcount number to be
the start number in January, the end headcount number needs to be the end
headcount number in March.

YEAR QUARTER START HEAD COUNT END HEAD COUNT
2004 1 750
1200


I have no idea how to do something like that in Analysis services. Any
ideas?

(Hope I didn't confuse anybody)
Thanks
Paul

Hi Paul,

Read this whitepaper:
OLAP Services: Semiadditive Measures and Inventory Snapshots
http://msdn.microsoft.com/library/de...l/semiadd2.asp

Best Regards

Zoltan

Paul írta:

Doable. The OpeningPeriod and ClosingPeriod functions could be used -- they
work within year, quarter or month scope. Headcount is a semi-additive
measure, which adds a (common, solvable) twist to the problem.

public @ the domain below
www.tomchester.net

"Paul" <pe (AT) nospam (DOT) com> wrote