Post reply

DOUBT:Linkmember Function

  • May 31, 2010 at 4:05 pm

    #235724

    HI to everyone, i am working on SSRS, and i want to build an MDX query for the month parameter from my Date Dimension : this looks like this

    Id Fecha Orden Pago

    >Año (year: )

    >Mes (Month : 1,2,3,4,5.....12)

    > N mes (Name: January, february,.....December)

    When i use the month as paramater SSRS automaticly build a mdx query. In my proyect when this happen the mdx create three fields ParameterCaption , ParameterValue, ParameterLevel (Example: 1, Enero(January),1 ... respectively ). But i Want to build a custom mdx query where instead of the number in the ParameterCaption i want the name of the month. I am trying this query

    ----------

    WITH MEMBER [Measures].[ParameterCaption] AS LinkMember([Id Fecha Orden Pago].[N Mes].CURRENTMEMBER, [Id Fecha Orden Pago].[N Mes] ) MEMBER [Measures].[ParameterValue] AS [Id Fecha Orden Pago].[Mes].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Id Fecha Orden Pago].[Mes].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Id Fecha Orden Pago].[Mes].ALLMEMBERS ON ROWS FROM ( SELECT ( { [Id Fecha Orden Pago].[Año].&[2009] } ) ON COLUMNS FROM ( SELECT ( { [DIM Programa Fomento].[Nombre Programa Fomento].&[TRANSFERENCIA TECNOLOGICA] } ) ON COLUMNS FROM [CUB_DGM_TestEnamiDW]))

    --------

    but I only have this result:

    I am very new on this but i try and try and dont get the result, i hope the linkmember will be the solution

    thanks in advance Ds

    pd: I already have created another dataset than brings the name of the month and the number of the month and works but is not the solution that i am looking for

  • June 9, 2010 at 2:55 pm

    #1178292

    Have you tried using the MEMBER_CAPTION property to get the month name?

    WITH MEMBER [Measures].[ParameterCaption] AS LinkMember([Id Fecha Orden Pago].[N Mes].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Id Fecha Orden Pago].[Mes].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Id Fecha Orden Pago].[Mes].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Id Fecha Orden Pago].[Mes].ALLMEMBERS ON ROWS FROM ( SELECT ( { [Id Fecha Orden Pago].[Año].&[2009] } ) ON COLUMNS FROM ( SELECT ( { [DIM Programa Fomento].[Nombre Programa Fomento].&[TRANSFERENCIA TECNOLOGICA] } ) ON COLUMNS FROM [CUB_DGM_TestEnamiDW]))

    Is your hierarchy set up with the name for the Month attributed mapped to the Month column?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply