US and Worldwide: +1 (866) 660-7555
Results 1 to 3 of 3

Thread: Help on MDX query

  1. #1
    Join Date
    Mar 2010
    Posts
    173

    Default Help on MDX query

    Hi I have the following query:

    Code:
    select NON EMPTY {[Measures].[count_X]} ON 0,
    NON EMPTY {[DIM_DAYS].Children} ON 1 
    from [Cube]
    with the result set:

    Code:
    Axis #0:
    {[DIM_STATO_RECORD].[A], [DIM_LOCALITA.LOCALITA].[PI], [DIM_ANNO_PRATICA].[2013]}
    Axis #1:
    {[Measures].[COUNT_PRATICHE]}
    Axis #2:
    {[DIM_TEMPO_RILASCIO].[#null]}
    {[DIM_TEMPO_RILASCIO].[0]}
    {[DIM_TEMPO_RILASCIO].[1]}
    {[DIM_TEMPO_RILASCIO].[2]}
    {[DIM_TEMPO_RILASCIO].[3]}
    {[DIM_TEMPO_RILASCIO].[4]}
    {[DIM_TEMPO_RILASCIO].[5]}
    {[DIM_TEMPO_RILASCIO].[6]}
    {[DIM_TEMPO_RILASCIO].[7]}
    {[DIM_TEMPO_RILASCIO].[8]}
    {[DIM_TEMPO_RILASCIO].[9]}
    {[DIM_TEMPO_RILASCIO].[10]}
    {[DIM_TEMPO_RILASCIO].[11]}
    {[DIM_TEMPO_RILASCIO].[12]}
    {[DIM_TEMPO_RILASCIO].[13]}
    {[DIM_TEMPO_RILASCIO].[14]}
    {[DIM_TEMPO_RILASCIO].[15]}
    {[DIM_TEMPO_RILASCIO].[16]}
    {[DIM_TEMPO_RILASCIO].[17]}
    {[DIM_TEMPO_RILASCIO].[18]}
    {[DIM_TEMPO_RILASCIO].[19]}
    {[DIM_TEMPO_RILASCIO].[20]}
    {[DIM_TEMPO_RILASCIO].[21]}
    {[DIM_TEMPO_RILASCIO].[22]}
    {[DIM_TEMPO_RILASCIO].[23]}
    {[DIM_TEMPO_RILASCIO].[24]}
    {[DIM_TEMPO_RILASCIO].[25]}
    {[DIM_TEMPO_RILASCIO].[26]}
    {[DIM_TEMPO_RILASCIO].[27]}
    {[DIM_TEMPO_RILASCIO].[28]}
    {[DIM_TEMPO_RILASCIO].[29]}
    {[DIM_TEMPO_RILASCIO].[30]}
    {[DIM_TEMPO_RILASCIO].[31]}
    {[DIM_TEMPO_RILASCIO].[32]}
    {[DIM_TEMPO_RILASCIO].[33]}
    {[DIM_TEMPO_RILASCIO].[34]}
    {[DIM_TEMPO_RILASCIO].[35]}
    {[DIM_TEMPO_RILASCIO].[36]}
    {[DIM_TEMPO_RILASCIO].[37]}
    {[DIM_TEMPO_RILASCIO].[38]}
    {[DIM_TEMPO_RILASCIO].[39]}
    {[DIM_TEMPO_RILASCIO].[40]}
    {[DIM_TEMPO_RILASCIO].[41]}
    {[DIM_TEMPO_RILASCIO].[42]}
    {[DIM_TEMPO_RILASCIO].[43]}
    {[DIM_TEMPO_RILASCIO].[44]}
    {[DIM_TEMPO_RILASCIO].[45]}
    {[DIM_TEMPO_RILASCIO].[46]}
    {[DIM_TEMPO_RILASCIO].[47]}
    {[DIM_TEMPO_RILASCIO].[49]}
    {[DIM_TEMPO_RILASCIO].[50]}
    {[DIM_TEMPO_RILASCIO].[51]}
    {[DIM_TEMPO_RILASCIO].[52]}
    {[DIM_TEMPO_RILASCIO].[53]}
    {[DIM_TEMPO_RILASCIO].[54]}
    {[DIM_TEMPO_RILASCIO].[56]}
    {[DIM_TEMPO_RILASCIO].[57]}
    {[DIM_TEMPO_RILASCIO].[58]}
    {[DIM_TEMPO_RILASCIO].[59]}
    {[DIM_TEMPO_RILASCIO].[60]}
    {[DIM_TEMPO_RILASCIO].[61]}
    {[DIM_TEMPO_RILASCIO].[62]}
    {[DIM_TEMPO_RILASCIO].[63]}
    {[DIM_TEMPO_RILASCIO].[64]}
    {[DIM_TEMPO_RILASCIO].[65]}
    {[DIM_TEMPO_RILASCIO].[70]}
    {[DIM_TEMPO_RILASCIO].[71]}
    {[DIM_TEMPO_RILASCIO].[72]}
    {[DIM_TEMPO_RILASCIO].[73]}
    {[DIM_TEMPO_RILASCIO].[74]}
    {[DIM_TEMPO_RILASCIO].[75]}
    {[DIM_TEMPO_RILASCIO].[76]}
    {[DIM_TEMPO_RILASCIO].[77]}
    {[DIM_TEMPO_RILASCIO].[78]}
    {[DIM_TEMPO_RILASCIO].[79]}
    {[DIM_TEMPO_RILASCIO].[80]}
    {[DIM_TEMPO_RILASCIO].[81]}
    {[DIM_TEMPO_RILASCIO].[82]}
    {[DIM_TEMPO_RILASCIO].[83]}
    {[DIM_TEMPO_RILASCIO].[84]}
    {[DIM_TEMPO_RILASCIO].[85]}
    {[DIM_TEMPO_RILASCIO].[86]}
    {[DIM_TEMPO_RILASCIO].[87]}
    {[DIM_TEMPO_RILASCIO].[90]}
    {[DIM_TEMPO_RILASCIO].[91]}
    {[DIM_TEMPO_RILASCIO].[92]}
    {[DIM_TEMPO_RILASCIO].[95]}
    {[DIM_TEMPO_RILASCIO].[97]}
    {[DIM_TEMPO_RILASCIO].[98]}
    {[DIM_TEMPO_RILASCIO].[99]}
    {[DIM_TEMPO_RILASCIO].[101]}
    {[DIM_TEMPO_RILASCIO].[104]}
    {[DIM_TEMPO_RILASCIO].[105]}
    {[DIM_TEMPO_RILASCIO].[106]}
    {[DIM_TEMPO_RILASCIO].[107]}
    {[DIM_TEMPO_RILASCIO].[111]}
    {[DIM_TEMPO_RILASCIO].[112]}
    {[DIM_TEMPO_RILASCIO].[114]}
    {[DIM_TEMPO_RILASCIO].[120]}
    {[DIM_TEMPO_RILASCIO].[124]}
    {[DIM_TEMPO_RILASCIO].[132]}
    {[DIM_TEMPO_RILASCIO].[133]}
    {[DIM_TEMPO_RILASCIO].[134]}
    {[DIM_TEMPO_RILASCIO].[135]}
    {[DIM_TEMPO_RILASCIO].[137]}
    {[DIM_TEMPO_RILASCIO].[142]}
    {[DIM_TEMPO_RILASCIO].[147]}
    {[DIM_TEMPO_RILASCIO].[149]}
    {[DIM_TEMPO_RILASCIO].[173]}
    Row #0: 468
    Row #1: 69
    Row #2: 70
    Row #3: 53
    Row #4: 90
    Row #5: 77
    Row #6: 78
    Row #7: 119
    Row #8: 159
    Row #9: 155
    Row #10: 86
    Row #11: 47
    Row #12: 66
    Row #13: 34
    Row #14: 61
    Row #15: 42
    Row #16: 46
    Row #17: 30
    Row #18: 24
    Row #19: 21
    Row #20: 9
    Row #21: 29
    Row #22: 27
    Row #23: 35
    Row #24: 34
    Row #25: 21
    Row #26: 18
    Row #27: 22
    Row #28: 44
    Row #29: 36
    Row #30: 35
    Row #31: 28
    Row #32: 12
    Row #33: 8
    Row #34: 18
    Row #35: 16
    Row #36: 41
    Row #37: 17
    Row #38: 17
    Row #39: 18
    Row #40: 7
    Row #41: 12
    Row #42: 12
    Row #43: 27
    Row #44: 19
    Row #45: 9
    Row #46: 16
    Row #47: 6
    Row #48: 2
    Row #49: 5
    Row #50: 5
    Row #51: 5
    Row #52: 1
    Row #53: 1
    Row #54: 5
    Row #55: 4
    Row #56: 5
    Row #57: 3
    Row #58: 1
    Row #59: 1
    Row #60: 4
    Row #61: 7
    Row #62: 2
    Row #63: 3
    Row #64: 1
    Row #65: 6
    Row #66: 2
    Row #67: 1
    Row #68: 1
    Row #69: 1
    Row #70: 1
    Row #71: 3
    Row #72: 3
    Row #73: 1
    Row #74: 2
    Row #75: 1
    Row #76: 1
    Row #77: 2
    Row #78: 3
    Row #79: 3
    Row #80: 2
    Row #81: 1
    Row #82: 2
    Row #83: 3
    Row #84: 1
    Row #85: 1
    Row #86: 1
    Row #87: 3
    Row #88: 1
    Row #89: 1
    Row #90: 1
    Row #91: 2
    Row #92: 1
    Row #93: 1
    Row #94: 1
    Row #95: 2
    Row #96: 1
    Row #97: 1
    Row #98: 2
    Row #99: 1
    Row #100: 1
    Row #101: 1
    Row #102: 1
    Row #103: 2
    Row #104: 1
    Row #105: 1
    Row #106: 1
    Row #107: 1
    Row #108: 1
    I'd like to:
    1) change the #null label with NOT SPECIFIED
    2) make ranges for the days as [1 - 30] [31 - 60]

    Could someone help me

  2. #2
    Join Date
    Jan 2013
    Posts
    471

    Default

    You can change the #null label by setting the mondrian property "mondrian.olap.NullMemberRepresentation" to whatever you'd prefer.

    Not sure what your asking for (2). You can get a range of members with the colon operator, e.g. { [DIM_TEMPO_RILASCIO].[1] : [DIM_TEMPO_RILASCIO].[30] }

  3. #3
    Join Date
    Mar 2010
    Posts
    173

    Default

    Thanks!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •