by maur » Wed, 15 May 2002 05:45:37
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
mauro
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
reports
- to calculate differences and relations between periods
for ANY member (also calculated) of the measure's
dimension.
[TIME].[CURRENT YEAR]:
StrToMember("[time].&["+format(now(),"yyyy")+"]")
[TIME].[LAST YEAR]:
StrToMember("[time].&["+format(now(),"yyyy")+"]").lag(1)
[TIME].[DIFF YEAR]:
[TIME].[CURRENT YEAR]-[TIME].[LAST YEAR]
QUESTIONS :
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
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