Pipeline function

[Gideon]

Hi,

I am not really a Cognos expert but it is not to hard to find your way around the tool.

But I am stuck, if anyone could help me that will be great!

We rewrote a view into a pipeline function, now the problem is that we have variables that we need to assign against the pipeline parameters.

Here is my code:

SELECT column_name                                             
  FROM TABLE(my_pipeline_function(#prompt('from_year','string')#,
                                                    #prompt('to_year','string')#,
                                                    #prompt('make','string')#,
                                                    #prompt('model_code','string')#,
                                                    #prompt('order_type','string')#,
                                                    #prompt('lease_type','string')#,
                                                    #prompt('parent_customer','string')#,
                                                    #prompt('customer','string')#,
                                                    #prompt('sls','string')#,
                                                    #prompt('csr','string'),
                                                    #prompt('unit_no','string')#))   

My parameter page comes up, but when I submit the report cognos generates it's own prompt page. Is there a way to assign my parameters to the Cognos prompts?

Thanks in advance,
Gideon 

[cognostechie]

I know Cognos is easy for a lot of people's abilities but no point mentioning that as long as you are asking questions. There is nobody who knows 100% and that's a fact. No embarrasment in asking questions.

Since you said your Parameter page comes up and then Cognos generates it's own Prompt page,
I presume you are talking about running the report in Report Studio.

If you created a Prompt Page and created Prompts there, associate those Prompts with the Parameters created by the Modelling tool (I presume you put that SQL in FM). When you insert Cognos Prompts in a SQL, it will create Parameters with the names you provide in the first portion of the Prompt (In your case, from_year, to_year etc).

In your Prompt Page, click on the Prompt, on the lower left corner, there is a property called 'Parameter'. You can change it to point it to the prompt name. That way, Report Studio will not generate it's own Prompt Page.

By the way, if you are doing this in Report Studio, this is the wrong forum for this question.

[Gideon]

Thanks for the help and the quick response.

Please advise what forum I can use for Report Studio?

ps. was not aware that Cognos Developers are so sensitive :-*

[MFGF]

Please advise what forum I can use for Report Studio?

http://www.cognoise.com/community/index.php/board,72.0.html