Custom parameters

[CognosMarson]

Hi, is it possible to create a prompt that select custom parameters?

e.g. set('something', 'something else', 'something other') = ?pPrompt?

CM

[Francis aka khayman]

what exactly are you trying to do? in any case you might want to check prompt and promptmany macro

[CognosMarson]

I am trying to build a crosstable with dynamic columns, rows and measure, where you choose in a promt what to view.


e.g.
#case prompt('pColumns', 'token')
when 'ytd' then '[ytd]'
when 'r12' then '[rolling 12 months]'
else '[ytd]'
end
#


Is there a way to make up the parameters to choose from or do they have to be "precreated" in the cube?

/CM

[Francis aka khayman]

i'm sure you have a good reason behind this. but if you can, it is much easier if you have several crosstabs. the prompt then displays the crosstab based on the chosen values

[Andrei I]

Is there a way to make up the parameters to choose from or do they have to be "precreated" in the cube?

They have to exist in your Query

[Christian85]

Hi!

Is there a way to make up the parameters to choose from or do they have to be "precreated" in the cube?

As far as I understood your question: You could simply create static choices for your prompt?