Constructing a MUN from a prompt macro

[Corrigon]

Hi there. I am trying to use a prompt to construct an MUN. Prompt name is pBU. The MUN format is as below:

[GL Cube].[GLM Hierarchy - Set 2].[Consolidation 2]->:[M8].[[GLM Hierarchy - Set 2]].[Consolidation 2]].&[140A70]]]

I am trying to create a prompt for the 3-digit code in the last part of the MUN. The following is what I came up with, but I keep getting parsing errors:

#'[GL Cube].[GLM Hierarchy - Set 2].[Consolidation 2]->:[M8].[[GLM Hierarchy - Set 2]].[Consolidation 2]].&['+prompt('pBU', 'token')+'A70]]]'#

Can anyone please provide the correct syntax for this expression?

Thanks in advance,
Dave

[MFGF]

Hi there. I am trying to use a prompt to construct an MUN. Prompt name is pBU. The MUN format is as below:

[GL Cube].[GLM Hierarchy - Set 2].[Consolidation 2]->:[M8].[[GLM Hierarchy - Set 2]].[Consolidation 2]].&[140A70]]]

I am trying to create a prompt for the 3-digit code in the last part of the MUN. The following is what I came up with, but I keep getting parsing errors:

#'[GL Cube].[GLM Hierarchy - Set 2].[Consolidation 2]->:[M8].[[GLM Hierarchy - Set 2]].[Consolidation 2]].&['+prompt('pBU', 'token')+'A70]]]'#

Can anyone please provide the correct syntax for this expression?

Thanks in advance,
Dave

Hi,

Does your MUN really have multiple brackets as above (ie [[ and ]]). This looks very odd to me. Have you tried right-clicking on the relevant member in the package tree and looking at the Properties page to check the MUN is correct?

As a sanity check, enclose the expression in an sq() function and display it in your report to see what is being generated

ie

#sq('[GL Cube].[GLM Hierarchy - Set 2].[Consolidation 2]->:[M8].[[GLM Hierarchy - Set 2]].[Consolidation 2]].&['+prompt('pBU', 'token')+'A70]]]')#

You can then compare this with the MUN you see in the Properties pane.

Cheers!

MF.

[Corrigon]

Hi MFGF, thanks so much for your reply.

It was while working through your suggestions that I realised I had TWO prompts call 'pBU'. I'd foolishly created the new one using the same prompt name as an existing prompt. So my original syntax on the expression was fine - I was just putting two sets of prompt information into it!

Thanks for your help, this is resolved now.