Hi, is it possible to create a prompt that select custom parameters?
e.g. set('something', 'something else', 'something other') = ?pPrompt?
CM
what exactly are you trying to do? in any case you might want to check prompt and promptmany macro
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
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
QuoteIs 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
Hi!
Quote from: CognosMarson on 06 Jan 2020 01:56:56 PM
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?