 | |
Time Range Dimension
microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Time Range Dimension -
03-23-2005
, 10:10 AM
#2
| |||
| |||
|
|
Hello, I have a cube with a time-dimension, now i need a second time-dimension how range the date like this( fist dim is 2004, the seconddim is all Month between may and november) have anyone a solution? regards martin |
#3
| |||
| |||
|
|
WITH MEMBER SecondDim.Range AS 'Aggregate({May:November})' SELECT ..... FROM Cube WHERE ([2004], SecondDim.Range) Ohjoo Kwon "Martin Jau" <no (AT) Spam (DOT) com> wrote in message news:ugv2GL8LFHA.2888 (AT) TK2MSFTNGP12 (DOT) phx.gbl... Hello, I have a cube with a time-dimension, now i need a second time-dimension how range the date like this( fist dim is 2004, the seconddim is all Month between may and november) have anyone a solution? regards martin |
#4
| |||
| |||
|
|
Hello, is it possible to make a dimension that show only month from year begin to end of the month without years. like this January 01.01. - 31.01 February 01.01. -31.02 March 01.01 - 31.03 April 01.01 - 31-04 ... regards martin "Ohjoo Kwon" <ojkwon (AT) olap (DOT) co.kr> schrieb im Newsbeitrag news:uoaKqW8LFHA.3812 (AT) TK2MSFTNGP10 (DOT) phx.gbl... WITH MEMBER SecondDim.Range AS 'Aggregate({May:November})' SELECT ..... FROM Cube WHERE ([2004], SecondDim.Range) Ohjoo Kwon "Martin Jau" <no (AT) Spam (DOT) com> wrote in message news:ugv2GL8LFHA.2888 (AT) TK2MSFTNGP12 (DOT) phx.gbl... Hello, I have a cube with a time-dimension, now i need a second time-dimension how range the date like this( fist dim is 2004, the seconddim is all Month between may and november) have anyone a solution? regards martin |
#5
| |||
| |||
|
|
Do you mean YTD? Ohjoo "Martin Jau" <no (AT) Spam (DOT) com> wrote in message news:Oo3rT8DMFHA.3080 (AT) TK2MSFTNGP10 (DOT) phx.gbl... Hello, is it possible to make a dimension that show only month from year begin to end of the month without years. like this January 01.01. - 31.01 February 01.01. -31.02 March 01.01 - 31.03 April 01.01 - 31-04 ... regards martin "Ohjoo Kwon" <ojkwon (AT) olap (DOT) co.kr> schrieb im Newsbeitrag news:uoaKqW8LFHA.3812 (AT) TK2MSFTNGP10 (DOT) phx.gbl... WITH MEMBER SecondDim.Range AS 'Aggregate({May:November})' SELECT ..... FROM Cube WHERE ([2004], SecondDim.Range) Ohjoo Kwon "Martin Jau" <no (AT) Spam (DOT) com> wrote in message news:ugv2GL8LFHA.2888 (AT) TK2MSFTNGP12 (DOT) phx.gbl... Hello, I have a cube with a time-dimension, now i need a second time-dimension how range the date like this( fist dim is 2004, the seconddim is all Month between may and november) have anyone a solution? regards martin |
#6
| |||
| |||
|
|
Hello Ohjoo, no sorry this is a german dateformat. now in US dateformat (i hope so) like this mm.dd - mm. dd January 01/01. - 01/31 February 01/01. - 02/31 March 01/01 - 03/31 April 01/01 - 04/31 ... regards martin "Ohjoo Kwon" <ojkwon (AT) olap (DOT) co.kr> schrieb im Newsbeitrag news:%23gUHiDEMFHA.3540 (AT) tk2msftngp13 (DOT) phx.gbl... Do you mean YTD? Ohjoo "Martin Jau" <no (AT) Spam (DOT) com> wrote in message news:Oo3rT8DMFHA.3080 (AT) TK2MSFTNGP10 (DOT) phx.gbl... Hello, is it possible to make a dimension that show only month from year begin to end of the month without years. like this January 01.01. - 31.01 February 01.01. -31.02 March 01.01 - 31.03 April 01.01 - 31-04 ... regards martin "Ohjoo Kwon" <ojkwon (AT) olap (DOT) co.kr> schrieb im Newsbeitrag news:uoaKqW8LFHA.3812 (AT) TK2MSFTNGP10 (DOT) phx.gbl... WITH MEMBER SecondDim.Range AS 'Aggregate({May:November})' SELECT ..... FROM Cube WHERE ([2004], SecondDim.Range) Ohjoo Kwon "Martin Jau" <no (AT) Spam (DOT) com> wrote in message news:ugv2GL8LFHA.2888 (AT) TK2MSFTNGP12 (DOT) phx.gbl... Hello, I have a cube with a time-dimension, now i need a second time-dimension how range the date like this( fist dim is 2004, the seconddim is all Month between may and november) have anyone a solution? regards martin |
#7
| |||
| |||
|
|
I don't still understand what you mean fully. For example, what do you mean by "01/01 - 04/31"? Do you mean accumulated sum of measures from 01/01 to 04/31? Ohjoo "Martin Jau" <no (AT) Spam (DOT) com> wrote in message news:OUGoQHEMFHA.3340 (AT) TK2MSFTNGP14 (DOT) phx.gbl... Hello Ohjoo, no sorry this is a german dateformat. now in US dateformat (i hope so) like this mm.dd - mm. dd January 01/01. - 01/31 February 01/01. - 02/31 March 01/01 - 03/31 April 01/01 - 04/31 ... regards martin "Ohjoo Kwon" <ojkwon (AT) olap (DOT) co.kr> schrieb im Newsbeitrag news:%23gUHiDEMFHA.3540 (AT) tk2msftngp13 (DOT) phx.gbl... Do you mean YTD? Ohjoo "Martin Jau" <no (AT) Spam (DOT) com> wrote in message news:Oo3rT8DMFHA.3080 (AT) TK2MSFTNGP10 (DOT) phx.gbl... Hello, is it possible to make a dimension that show only month from year begin to end of the month without years. like this January 01.01. - 31.01 February 01.01. -31.02 March 01.01 - 31.03 April 01.01 - 31-04 ... regards martin "Ohjoo Kwon" <ojkwon (AT) olap (DOT) co.kr> schrieb im Newsbeitrag news:uoaKqW8LFHA.3812 (AT) TK2MSFTNGP10 (DOT) phx.gbl... WITH MEMBER SecondDim.Range AS 'Aggregate({May:November})' SELECT ..... FROM Cube WHERE ([2004], SecondDim.Range) Ohjoo Kwon "Martin Jau" <no (AT) Spam (DOT) com> wrote in message news:ugv2GL8LFHA.2888 (AT) TK2MSFTNGP12 (DOT) phx.gbl... Hello, I have a cube with a time-dimension, now i need a second time-dimension how range the date like this( fist dim is 2004, the seconddim is all Month between may and november) have anyone a solution? regards martin |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.