#prompt function cannot be planned error

[fml55555]

Hi Gurus,

I am trying to build a prompt for a particular dimension. I am using the #prompt macro

1.
#prompt('parametername','?','','','[Dimension].[Hierarcy].[level])#

?- I do not know what to use here (Caption, String or Mmun)
The level whcih I am trying to access has many queryitems but  mun is not one of them(I do see it in the Framework manager but not in Report studio  :o)

I have tried using the following syntax (completely made up was just trying to experiment) in a data item

[Dimension].[Hierarcy].[level].[#prompt('parametername','?','','','[Dimension].[Hierarcy].[level].[queryitem]','')#

get the same error again the same error (query could not be planned by the query service).

I have successfully used the same macro (1.) for another dimension (date). But for some reason it fails for this other dimension. The dimension contains details about a broker (Name, address and many many other things)

I have also tried using the key as well, but the result is the same. Where am I going wrong?

[MFGF]

Hi Gurus,

I am trying to build a prompt for a particular dimension. I am using the #prompt macro

1.
#prompt('parametername','?','','','[Dimension].[Hierarcy].[level])#

?- I do not know what to use here (Caption, String or Mmun)
The level whcih I am trying to access has many queryitems but  mun is not one of them(I do see it in the Framework manager but not in Report studio  :o)

I have tried using the following syntax (completely made up was just trying to experiment) in a data item

[Dimension].[Hierarcy].[level].[#prompt('parametername','?','','','[Dimension].[Hierarcy].[level].[queryitem]','')#

get the same error again the same error (query could not be planned by the query service).

I have successfully used the same macro (1.) for another dimension (date). But for some reason it fails for this other dimension. The dimension contains details about a broker (Name, address and many many other things)

I have also tried using the key as well, but the result is the same. Where am I going wrong?

Hi,

Let's take a step back from this for a second. What are you trying to achieve? It looks like you have a dimensional package? What are you trying to prompt for - a member? A set of members? Is this for use as a displayed item in a report object (eg in rows or columns of a crosstab)? Is it just to drive the measure values maybe? Why are you trying to use a macro - is there a specific reason?

MF.

[fml55555]

Hey MFGF,

Thanks a lot for the reply. I am trying to get one specific member from hierarchy (lets say branch). The hierarchy has several query subjects.

There are 3 to 4 Query subjects about the names of branches (Long name, name, medium name etc.). All these have the same portions of the same name i.e. (Long name has the full name, short name has part of the name etc)

I want to prompt the long name and use the value provided in a tuple to generate the sales for a perticular branch. I have been able to generate the prompt, but when I use it in tuple, the sales part appears blank. The prompt goes like this

#prompt('longname','string','','','[Dimension].[Hierarchy].[Level].[long name(this is the query subject]). This is in a data item DM1. Later. I USE THE dm1 to create a calculated member cm1

member([DM1],'abc','[Dimension].[Hierarchy].[Level]')

Then I use cam in a tuple with some other measures

Tuple1

sales month region cm1

I have cheacked the tuple without cm1 and it works fine. What am I doing wrong? :(

[MFGF]

Hey MFGF,

Thanks a lot for the reply. I am trying to get one specific member from hierarchy (lets say branch). The hierarchy has several query subjects.

There are 3 to 4 Query subjects about the names of branches (Long name, name, medium name etc.). All these have the same portions of the same name i.e. (Long name has the full name, short name has part of the name etc)

I want to prompt the long name and use the value provided in a tuple to generate the sales for a perticular branch. I have been able to generate the prompt, but when I use it in tuple, the sales part appears blank. The prompt goes like this

#prompt('longname','string','','','[Dimension].[Hierarchy].[Level].[long name(this is the query subject]). This is in a data item DM1. Later. I USE THE dm1 to create a calculated member cm1

member([DM1],'abc','[Dimension].[Hierarchy].[Level]')

Then I use cam in a tuple with some other measures

Tuple1

sales month region cm1

I have cheacked the tuple without cm1 and it works fine. What am I doing wrong? :(

What kind of prompt? A tree prompt? Value prompt? Something else?

Why not just add a calculated item to your crosstab with the expression [Level] -> ?parameter?

You can then create a value prompt for this parameter with a use value of the level and a display value of the long name. Does this give you what you need?

MF.


Sent from my iPad using Tapatalk HD

[fml55555]

It does. Thanks a lot for the help MFGF.