SAP Disclosure Management - Pass parameter to MDX Query?

[Former Member]

Hello experts,

We've created the following MDX query in a BriefingBook:

WITH

MEMBER [Indicador].[H1].[Fondo Publico K_0001] AS IIF( IsEmpty( [Indicador].[H1].[K_0001] ), 0, [Indicador].[H1].[K_0001] )
MEMBER [Indicador].[H1].[Fondo Privado K_0002] AS IIF( IsEmpty( [Indicador].[H1].[K_0002] ), 0, [Indicador].[H1].[K_0002] )


SELECT 
{[Indicador].[H1].[Fondo Publico K_0001],[Indicador].[H1].[Fondo Privado K_0002]} ON COLUMNS,
DESCENDANTS([Cuenta].[BG00000],0,AFTER) ON ROWS
 FROM [Notas_SIC]
 WHERE ([Auditoria].[AUD_INPUT],[Concepto].[CONCEPTO_NA],[Entidad].[CCB],
 [Interco].[I_NONE],[Moneda].[COP], [Tiempo].[2014.12],[Version].[REAL],
 [Measures].[SIGNEDDATA])

We need to pass 2014.12 as a parameter. For SQL we can use @var_name, but in MDX we've no clue of how pass it so far. Any suggestions?

Thanks in advance.

[Marc_Kuipers]

Hello Andres

Does this link help? https://msdn.microsoft.com/en-us/library/ms145518.aspx

Marc

[Former Member]

Hello Marc,

I tried something like [Tiempo].CurrentMember = @var

It shows in SSMS and SAP DM the same message:

The query contains the var parameter, which is not declared.

I can't call a DECLARE instruction, since this is pure MDX.

Maybe another way to call it with @ ?