Hi all, just wondering if we can create forms (similar to google form) to accept the inputs from user.  As temporary workaround we can use text prompts to input the values or Stored Procedure to get capture prompted inputs and process back to report/dashboard, which I feel a traditional way of achieving it. Is any one explored new method or any recent feature in cognos to support forms. Thanks for your comments.

------------------------------
SWAMY THIPPESWAMY
------------------------------

#CognosAnalyticswithWatson

Hi Swamy,

If you need to accept inputs from users, you just need to create a prompt in your report:
https://www.ibm.com/docs/en/cognos-analytics/11.2.0?topic=reporting-adding-prompts-filter-data

For instance, if you have a Country column, you might want to create a filter with the following expression:
[Country] = ?pCountry? (you will be able to select only one country)
or
[Country] in (?pCountry?) (you will be able to select many countries)

Best regards,

------------------------------
Patrick Neveu
Positive Thinking Company
------------------------------

Thanks Patrick.  Additionally,  We would want to capture this data to db to create report out of it instantaneously. So want to know how do we store these data inputs back to db table other than stored procedure method. 

Regards,

------------------------------
SWAMY THIPPESWAMY
------------------------------

Original Message:
Sent: Tue February 08, 2022 10:26 AM
From: Patrick Neveu
Subject: Creating FORMS to accept input from end user

Hi Swamy,

If you need to accept inputs from users, you just need to create a prompt in your report:
https://www.ibm.com/docs/en/cognos-analytics/11.2.0?topic=reporting-adding-prompts-filter-data

For instance, if you have a Country column, you might want to create a filter with the following expression:
[Country] = ?pCountry? (you will be able to select only one country)
or
[Country] in (?pCountry?) (you will be able to select many countries)

Best regards,

------------------------------
Patrick Neveu
Positive Thinking Company
------------------------------

Hi Swamy,

I think there is nothing out of the box. I don't know what can be done.

Best regards,

------------------------------
Patrick Neveu
Positive Thinking Company
------------------------------

Original Message:
Sent: Tue February 08, 2022 10:54 AM
From: SWAMY THIPPESWAMY
Subject: Creating FORMS to accept input from end user

Thanks Patrick.  Additionally,  We would want to capture this data to db to create report out of it instantaneously. So want to know how do we store these data inputs back to db table other than stored procedure method. 

Regards,

------------------------------
SWAMY THIPPESWAMY
------------------------------


Original Message:
Sent: Tue February 08, 2022 10:26 AM
From: Patrick Neveu
Subject: Creating FORMS to accept input from end user

Hi Swamy,

If you need to accept inputs from users, you just need to create a prompt in your report:
https://www.ibm.com/docs/en/cognos-analytics/11.2.0?topic=reporting-adding-prompts-filter-data

For instance, if you have a Country column, you might want to create a filter with the following expression:
[Country] = ?pCountry? (you will be able to select only one country)
or
[Country] in (?pCountry?) (you will be able to select many countries)

Best regards,

------------------------------
Patrick Neveu
Positive Thinking Company

Original Message:
Sent: 2/8/2022 10:55:00 AM
From: SWAMY THIPPESWAMY
Subject: RE: Creating FORMS to accept input from end user

Thanks Patrick.  Additionally,  We would want to capture this data to db to create report out of it instantaneously. So want to know how do we store these data inputs back to db table other than stored procedure method. 

Regards,

------------------------------
SWAMY THIPPESWAMY
------------------------------

Hi,

you can create such a form like interface by adding a stored procedure from your database to a framework that writes back data again to a table in the database. You can have multiple fields n the table, that are filled by a prompt, a constant (current_date) or for example the username. Here you can find more information on how to set up this functionality: Creating or modifying stored procedure query subjects - IBM Documentation. 
Be aware that you need to set your database access to write as well.

------------------------------
Robert-Peter den Heijer
------------------------------

Hi Robert,

Thanks for the details. I have created SP in SQL Server and imported to FM. It is perfectly working fine as expected.
Post import to FM, have selected Type as "Data Query", added macro prompt to all the input columns and tested with input values which is writing to table. However at Report Studio, have created textbox prompts with same prompt parameters name of FM and then raw table as list on report page. This is not reflecting back to underneath table. Do we have to map textbox prompts back to any of columns on report ?


Thank You!

------------------------------
SWAMY THIPPESWAMY
------------------------------

Original Message:
Sent: Wed February 09, 2022 04:18 AM
From: Analytical Engine
Subject: Creating FORMS to accept input from end user

Hi,

you can create such a form like interface by adding a stored procedure from your database to a framework that writes back data again to a table in the database. You can have multiple fields n the table, that are filled by a prompt, a constant (current_date) or for example the username. Here you can find more information on how to set up this functionality: Creating or modifying stored procedure query subjects - IBM Documentation. 
Be aware that you need to set your database access to write as well.

------------------------------
Robert-Peter den Heijer
------------------------------

Swamy,

In Framework Manager, you can import database stored procedures as a query object that can accept parameters, and can either retrieve or update data based on the nature of the stored procedure.

If you are using data modules, this is not a supported feature:
Framework Manager features not supported by data modules (in Appendix C)

Best regards,

------------------------------
Patrick Neveu
Positive Thinking Company
------------------------------

Hey together,
I recommend to have a look at Apparo FastEdit - available from the IBM Accelerator Cataloge:
https://community.ibm.com/accelerators/catalog/content/Apparo-Fast-Edit
A trial version with a license for one business case it available there. 

For further requests just ask @Jens Bäumler
I tried it once and it works perfectly when you want to setup a 3rd-party software. 

​

------------------------------
Robert Dostal
Team Leader BI
GEMÜ
Ingelfingen
------------------------------

Original Message:
Sent: Wed February 09, 2022 05:53 AM
From: Patrick Neveu
Subject: Creating FORMS to accept input from end user

Swamy,

In Framework Manager, you can import database stored procedures as a query object that can accept parameters, and can either retrieve or update data based on the nature of the stored procedure.

If you are using data modules, this is not a supported feature:
Framework Manager features not supported by data modules (in Appendix C)

Best regards,

------------------------------
Patrick Neveu
Positive Thinking Company
------------------------------

I wrote about this years ago. https://cognospaul.com/2014/01/02/creating-data-entry-page-cognos/

------------------------------
Paul Mendelson
------------------------------

Hi All, Thank you so much for your quick response and guidance. I could able to achieve this by using Stored Procedure and Macro's on Framework Manager. Its working as expected. 

Thank You!!!

------------------------------
SWAMY THIPPESWAMY
------------------------------