calculated member in time dimension

calculated member in time dimension

Post by maur » Wed, 15 May 2002 05:45:37

Hello community,

my regular time dimension need
some calculated member at year level (i.e. aggregate
(jan:month (x-1)), month x, aggregate(month (x+1):dec)).

Is it possible to define a "calculated member parent"
making it possible to define the calculated member at
year "level" rather than attaching it under an actual year
(i.e. [time].[year].&[2001] ) ?

thanks in advance



1. calculated members of time dimension

I have made calculated members of the time dimension for
current year, current qtr, current period, current week
and so on.
I want to:
- use them as a quick way of selecting current periods in
- to calculate differences and relations between periods
for ANY member (also calculated) of the measure's


1. Which solve-order number should i give my calc members
in the time dim.
2. Which solve-order number should I give my calculated
measures, ex Profit and Sales Average from the Sales cube
in the Foodmart2000 db.
3. Is there a better way of doing this, f ex so that I can
select a period, not only the current, and get
differencies och relations ?

2. Is it possible for multiple connections (with the same user id) to UDB PE V8.1?

3. Creating an MDX Calculated Member as an Average over Time Dimension

4. SQL 2000 Performance

5. Where are the ORDERS, SUPPLIERS tables ?

6. MDX-syntax to check which time dimension to use in a calculated member

7. Calculated member w/2 time dimensions

8. Analysis Services, Dimension Member ordering, Calculated Members

9. Adding Calculated Member to a Parent Member in the dimension through code

10. Selecting parent member for calculated member in dimension with alternative hieararchies