sqlplsqlcognos-10cognos-bicognos-8

Is it possible to pass parameter in the cognos by SQL?


I am having SQL query as "select * from all_objects where owner = : owner;". Can it be possible to create prompt with this query in cognos 10.2.2.Please suggest me.


Solution

  • You can use a prompt macro. The SQL with the macro would look something like this:

    SELECT * FROM all_objects WHERE owner = #sq(prompt('owner','string',''))#
    

    The third parameter of the prompt() function specifies a default value. If you supply one, the prompt becomes optional.