Scott Coker ICQ# 11107324
**************************************************
|/_/ |/_/
\__/
~|oo~
|\,,,,.../ y
\ / <----## ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
/... |
\\ `~~||
\\ ||
hh mm It's that time of year again!
**************************************************
The views and opinions expressed by me
do not reflect those of KBSI.
1. MDX: year-to-date/month-to-date problem
I am having trouble subtracting the year-to-date totals at the quarter
through the month levels of a time dimension to
calculate the month-to-date totals.
I am using the previousmember and currentmember functions, but I cannot make
the calculation use the year-to-date
totals only at the first member of the level (January for month, 1 for
quarter). For January, the calculation is taking the YTD amount
for the current year minus the YTD amount from the previous year, obviously
incorrect.
- Thanks, Mike
Parry (MDX novice)
2. Access table record position
3. Date problem- date calculation in between values
7. MSSQL server English-Turkish Date Problem
9. Date problem with SQL Server
10. Date problem
11. Please Help: Need SQL Server ODBC client v3.60.x to correct a date problem
12. BCP date problems with SQL7.0
13. could date problem cause log truncation failures?