Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to use YTD on a mirror period

Status
Not open for further replies.
tomgao

tomgao

Programmer
Feb 25, 2003
30
0
0
NG
Hi friends

I have a funny situation. I have a period dimension which contains Year, Qtr, Month. I also have another Time dimension which contains Mth1 .. Mth25.

The 2nd Time dimension matches that of the 1st Time dimension ie. Mth25 is 2005.April. and Mth24 is 2005.March and so on...

However I need to calculate YTD when MTH25 is selected from the dimension.

I can't exactly do YTD (Mth25) as Mth25 is not a time dimension. Is there a way to Retrieve the equivalent time dimension in the form of 2005.April from Mth25 so that I can use in YTD Calculation ?

Thanks
Tom
 
Status
Not open for further replies.

Similar threads

Antonius222
  • Locked
  • Question
Must the driver use SQLGetPrivateProfileString?
Replies
0
Views
54
Antonius222
Antonius222
acoronel
  • Locked
  • Question
Error message to use active directory authetication to access SQL database.
Replies
0
Views
115
acoronel
acoronel
isoman4not5
  • Locked
  • Question
Is it possible to derive a recurring date based upon a single date?
Replies
0
Views
116
isoman4not5
isoman4not5
MDGarcia
  • Locked
  • Question
ODBC error: Specified driver could not be loaded due to system error 193
Replies
1
Views
185
k5tm
k5tm
maxzikpi
  • Locked
  • Question
How to Create a cube with a survey result. Pls help!
Replies
4
Views
146
maxzikpi
maxzikpi

Part and Inventory Search

Sponsor

Back
Top