Planning your Cognos 8 environment -- Content Manager

Content Manager, which can be installed in Tier 2 or 3 of Cognos 8, stores information in the content store. To allow fast retrieval, Content Manager builds an in-memory cache to service many requests. This ensures optimal performance and enhances scalability by limiting the number of database reads required to meet user requests.

In the single Content Manager process, multiple threads can concurrently service requests for content. Content Manager creates one or more threads for each user request. Performance depends on the power of the central processor unit (CPU) of the computer on which Content Manager is installed.

 

To increase scalability, use a larger computer capable of managing more concurrent request threads. When scaling up Content Manager, be sure to scale up the content store relational database management system so that it does not impede Content Manager performance.

 

Planning your Cognos 8 environment -- Content Manager

Content Manager, which can be installed in Tier 2 or 3 of Cognos 8, stores information in the content store. To allow fast retrieval, Content Manager builds an in-memory cache to service many requests. This ensures optimal performance and enhances scalability by limiting the number of database reads required to meet user requests.

In the single Content Manager process, multiple threads can concurrently service requests for content. Content Manager creates one or more threads for each user request. Performance depends on the power of the central processor unit (CPU) of the computer on which Content Manager is installed.

 

To increase scalability, use a larger computer capable of managing more concurrent request threads. When scaling up Content Manager, be sure to scale up the content store relational database management system so that it does not impede Content Manager performance.

 

Cognos 8 Report Studio -- Drill Through Report

How to create a Drill Through report

 

Sample Scenario:  You have been asked to create a Drill Through report sample using the Great Outdoors model.  You decide to show this behaviour creating a report that lists product sales by order method for each product line, and allows users to drill through from the sales report to view the product details for any item selected. You need to create two reports: one that contains the details for the item; and another that lists the product sales for the order methods selected by users.

 

1. Open Report Studio and select the GO Sales and Retailers package.
2. Create a new List report.
3. Add the following query items from the Orders and Products query subjects to the report page.
1. • Order method
2. • Product line
3. • Product type
4. • Product name
5. • Description
6. • Introduction date
7. • Product image
4. Group the Order method, Product line, and Product type columns.
5. Click the filters button and add the following filters:
1. [Product name]=?p_ProductName?
2. [Order method] in ?p_OrderMethod?
6. Change the title of the report to Product Details.
7. Save the report as Product Details.
8. From the File menu, click New to create a new List report.
9. Add the following query items from the Orders and Products query subjects.
1. • Order method
2. • Product line
3. • Product type
4. • Product name
5. • Quantity
6. • Revenue
10. Group the Order method, Product line, and Product type columns.
11. Add the following filter to the report:
1. [Order method] in ?p_OrderMethod?
12. Right-click the Product Name column and click Drill Throughs.
13. Click the new drill through button.
14. Under Report, click the ellipsis points (...) and select the Product Details report you created previously.
15. Click Action and click Run the report.
16. Click Format and click HTML.
17. Click the edit button.
18. For the item p_OrderMethod, under Method, select Pass parameter value, and select p_OrderMethod for the Value.
19. For the item p_ProductName, under Method, select Pass data item value, and select Product name for the Value.
20. Click OK twice.
21. Change the title of the report to Product Revenue by Order Method.
22. Save the report as Product Revenue by Order Method.
23. Click the run report button.  When the report is run, you are prompted to select one or more order methods. When you click OK, the list will show the product names as clickable links. When a product is clicked, the second report will run, showing the order methods and product selected in the first report.

 

 

 

Cognos 8 Report Studio -- Drill Through Report

How to create a Drill Through report

 

Sample Scenario:  You have been asked to create a Drill Through report sample using the Great Outdoors model.  You decide to show this behaviour creating a report that lists product sales by order method for each product line, and allows users to drill through from the sales report to view the product details for any item selected. You need to create two reports: one that contains the details for the item; and another that lists the product sales for the order methods selected by users.

 

1. Open Report Studio and select the GO Sales and Retailers package.
2. Create a new List report.
3. Add the following query items from the Orders and Products query subjects to the report page.
1. • Order method
2. • Product line
3. • Product type
4. • Product name
5. • Description
6. • Introduction date
7. • Product image
4. Group the Order method, Product line, and Product type columns.
5. Click the filters button and add the following filters:
1. [Product name]=?p_ProductName?
2. [Order method] in ?p_OrderMethod?
6. Change the title of the report to Product Details.
7. Save the report as Product Details.
8. From the File menu, click New to create a new List report.
9. Add the following query items from the Orders and Products query subjects.
1. • Order method
2. • Product line
3. • Product type
4. • Product name
5. • Quantity
6. • Revenue
10. Group the Order method, Product line, and Product type columns.
11. Add the following filter to the report:
1. [Order method] in ?p_OrderMethod?
12. Right-click the Product Name column and click Drill Throughs.
13. Click the new drill through button.
14. Under Report, click the ellipsis points (...) and select the Product Details report you created previously.
15. Click Action and click Run the report.
16. Click Format and click HTML.
17. Click the edit button.
18. For the item p_OrderMethod, under Method, select Pass parameter value, and select p_OrderMethod for the Value.
19. For the item p_ProductName, under Method, select Pass data item value, and select Product name for the Value.
20. Click OK twice.
21. Change the title of the report to Product Revenue by Order Method.
22. Save the report as Product Revenue by Order Method.
23. Click the run report button.  When the report is run, you are prompted to select one or more order methods. When you click OK, the list will show the product names as clickable links. When a product is clicked, the second report will run, showing the order methods and product selected in the first report.

 

 

 

Cognos SDK Guide by BI Centre -- update for Cognos SDK.cs Authentication

If you are following the posts for the sample Cognos SDK solution then you won’t want to miss the last few posts that talk about the CognosSDK.cs class file.  Follow the link below to take you to the Cognos SDK discussion about authenticating a user session.

 

http://bicentresdkguide.blogspot.com/2007/12/cognossdkcs-authentication.html