Using Java Script for List and Crosstab :
http://www.ibm.com/developerworks/data/library/cognos/page242.html
Without JavaScript :
http://www.ibm.com/developerworks/data/library/cognos/page242.html
Without JavaScript :
Monday 26 September 2011
Wednesday 7 September 2011
Write Back to database through cognos 8 series interface !!!
Problem Description :
There are requirements from the client to have the facility to write back to the database specially to capture user input in the form of comments from cognos Report studio .
There is no direct facility to capture user input in cognos 8 series and the solution is a work around for write back in cognos with limited scope.
In Cognos 10 adding user comment is a new inbuilt feature , so this description is helpful for Cognos 8 users.
For Cognos 10:
http://www.citagus.com/citagus/blog/collaboration-in-cognos-10-comments-in-saved-report-output/
Solution Description :
The solution is designed for Cognos Report studio with Oracle Database . It uses stored procedure ( containg input parameters to capture users comment and uniquley identify the record ) returns the resultset in the form of cursor.
The created stored procedure and the table to be updated is imported in frame work manager . The package is published and two reports are bulit using them .
The first report say "Report_1" is designed ( the source of this report is table which is to update ) with a drill through to second report say "Report_2" ( the source is Stored Procedure which updates the table ) .
In the drill through column of the first report we will pass the dataitem value to identify the unique record and give the option of "Do not pass the parameter" for the comment section. Due to above setting the procedure which accepts the parameter of uniquely identifying the record and comment parameter will wait till the user gives the input in the comment section .
Once the user gives the comment input through the pop-up screen which appears due to the drill through facility and clicks ok , the input is updated in the table through stored procedure and the output result set is returned in the form of cursor.
Solution Tools and Database used:
Oracle 11i , Cognos 8.4.1
Solution Screenshot:
Acheivement :
A Technical solution design paper was published by me on this topic.
The solution was well appreciated by the client and also, by the technical experts.
Solution Details :
Will be shared on email on demand.
Leave your comment with email id to view its solution.
There are requirements from the client to have the facility to write back to the database specially to capture user input in the form of comments from cognos Report studio .
There is no direct facility to capture user input in cognos 8 series and the solution is a work around for write back in cognos with limited scope.
In Cognos 10 adding user comment is a new inbuilt feature , so this description is helpful for Cognos 8 users.
For Cognos 10:
http://www.citagus.com/citagus/blog/collaboration-in-cognos-10-comments-in-saved-report-output/
Solution Description :
The solution is designed for Cognos Report studio with Oracle Database . It uses stored procedure ( containg input parameters to capture users comment and uniquley identify the record ) returns the resultset in the form of cursor.
The created stored procedure and the table to be updated is imported in frame work manager . The package is published and two reports are bulit using them .
The first report say "Report_1" is designed ( the source of this report is table which is to update ) with a drill through to second report say "Report_2" ( the source is Stored Procedure which updates the table ) .
In the drill through column of the first report we will pass the dataitem value to identify the unique record and give the option of "Do not pass the parameter" for the comment section. Due to above setting the procedure which accepts the parameter of uniquely identifying the record and comment parameter will wait till the user gives the input in the comment section .
Once the user gives the comment input through the pop-up screen which appears due to the drill through facility and clicks ok , the input is updated in the table through stored procedure and the output result set is returned in the form of cursor.
Solution Tools and Database used:
Oracle 11i , Cognos 8.4.1
Solution Screenshot:
Acheivement :
A Technical solution design paper was published by me on this topic.
The solution was well appreciated by the client and also, by the technical experts.
Solution Details :
Will be shared on email on demand.
Leave your comment with email id to view its solution.
Tuesday 6 September 2011
Bursting Cognos Reports
Example - Burst a Report
You are a report author at The Great Outdoors Company, which sells sporting equipment. You are requested to create a report that lists product sales for each sales representative. The report is to be emailed to each sales representative, but they only need to see the data that pertains to them. You create a list report that you burst to each sales representative.
Steps
1. Open Report Studio with the GO Data Warehouse (query) package.
2. In the Welcome dialog box, click Create a new report or template.
3. In the New dialog box, click List and click OK.
4. In the Insertable Objects pane, on the Source tab
· Expand Employee by organization and add Employee name.
· Expand Product and add Product line, Product type, and Product name.
· Expand Sales fact and add Quantity and Revenue.
5. Group the Employee name, Product line, and Product type columns.
6. Click the Employee name column, click the headers and footers button , and then click Create Header.
Employee name appears as a header in the list. You no longer need to keep the data item as a list column.
7. In the list, click Employee name and click the delete button .
8. Click Revenue, and then click the aggregate button and click Total.
9. Pause the pointer over the query explorer button and click Query1.
10. In the Insertable Objects pane, on the Source tab, drag Email from the Employee by organization folder to the Data Items pane.
11. From the File menu, click Burst Options.
12. Select the Make report available for bursting check box.
13. Under Burst Groups, in the Query box, click Query1.
14. In the Label box, click Employee name.
15. Click the edit button .
16. In the Data Items box, drag Employee name to the Groups folder and click OK.
17. Under Burst Recipient, in the Query box, click Query1.
18. In the Data Item box, click Email.
19. In the Type box, click Email addresses.
20. Save the report.
21. Locate the report in IBM Cognos Connection.
22. Under Actions, click Run with options .
23. Click advanced options on the right of the screen.
24. Under Time and mode, click Run in the background.
25. Select the Burst the report check box.
26. Select the Send the report by email check box.
27. Run the report.
When sales representatives access their email accounts, they will see reports with only the data that is meant for them.
Monday 5 September 2011
Subscribe to:
Posts (Atom)