Cognos SDK resources available for contracts

The BI Centre has Cognos SDK developers that are available for software development projects both onsite and for remote opportunities.

If you would like to discuss your Cognos SDK requirements then contact us today at businessintelligencecentre@gmail.com.

Cognos SDK resources available for contracts

BI Centre offering remote Cognos testing services

The BI Centre is now offering to provide remote Cognos testing services. Now you can leverage our years of Cognos development experience for your next BI initiate.

If you would like to learn more about our remote testing services offering then please email businessintelligencecentre@gmail.com today.

BI Centre offering remote Cognos testing services

Cognos 8 - One Click Dynamic Column Sorting

This technique allows you to dynamically sort a report by column by clicking on the column header. It also enables you to change the sort order by repeating the click.

To create a list report that allows you to dynamically sort the data ascending or descending by pressing each column's header you will need:

A parameter that provides the column used for sorting;
A parameter that provides the sort order (ascending/descending);
A drill through on each column title that will be sorted that passes the full name of that column. Also a pass sort order to change it each time a drill through occurs.

Steps:

Create a new or open an existing list report.
In Query Explorer go to Query1.
Click on the data item that you would like to sort by and press CTRL+C and CTRL+V to duplicate the data item.
Repeat Step 3 for each data item you would like to sort by.
Double-click on the copy of each data item to edit it, adding an apostrophe to the beginning and to the end of the expression so it looks like this: '[Academic Study].[Academic Study].[ACADEMIC_PERIOD]' and press OK.
Repeat Step 5 for each duplicate data item.
From the Toolbox drag a Data Item to the Data Items Pane. In the Expression Editor that pops-up type: if(#prompt('p_Direction','integer','1')#=1) then (#prompt('p_SortColumn','token','[PROGRAM]')#) else ('0') (1 means ascending and -1 means descending. We will have a data item that changes from 1 to -1 and vice-versa at each drill through.) Click OK. (Column that we will sort on will be the value of this parameter.)
Rename the newly created data item to: Sort_item_asc.
Create a copy of Sort_item_asc (using CTRL+C and CTRL+V). Rename the copy to Sort_item_desc.
Double-click Sort_item_desc to edit it and change =1 to = -1. Click OK.
In Page Explorer, click on Page 1 and then click anywhere in the list.
From the Report Studio menu, click on Data and then Advanced Sorting…
In the Grouping & Sorting dialog box that pops up drag Sort_item_asc on top of Detail Sort List.
Drag Sort_item_desc underneath Sort_item_asc in Detail Sort List folder and click on the Sort Order button to change it to descending.
Click OK.
From Query Explorer click Query 1 and add a Data Item from the Toolbox. Type this in the expression editor: -(#prompt('p_Direction','integer','1')#) Click OK. (This data item is the future value of the sort order on the next drill through.)
Rename Data Item1 to Direction.
In the Page Explorer click on Page1.
Click on the header column of the data item you want to sort by (the Properties pane should display List Column Title next to Ancestor Selector).
In the Properties Pane double click Drill Throughs. Click New Drill Through. For Report choose your report, for action choose Run the Report, click to edit parameters, choose Pass data item values as Method and for Value select the COPY of the data item you are sorting by for the p_SortColumn parameter and Choose Direction for the p_Direction parameter.
Click OK and then OK again.
Repeat steps 12 thru 14 for each data item column, but selecting the corresponding duplicate data item as the value for the drill through parameter. (Depending on the column title where the drill through is initiated from – we will assign the according value for the parameter that gives us the column to sort.)
From Run->Run Options…menus deselect Prompt and click OK.
Save the report and run. For each click on the column header the order changes from ascending to descending and vice-versa.

--
BI CENTRE
http://bicentre.blogspot.com

Cognos 8 - One Click Dynamic Column Sorting

This technique allows you to dynamically sort a report by column by clicking on the column header. It also enables you to change the sort order by repeating the click.

To create a list report that allows you to dynamically sort the data ascending or descending by pressing each column's header you will need:

A parameter that provides the column used for sorting;
A parameter that provides the sort order (ascending/descending);
A drill through on each column title that will be sorted that passes the full name of that column. Also a pass sort order to change it each time a drill through occurs.

Steps:

Create a new or open an existing list report.
In Query Explorer go to Query1.
Click on the data item that you would like to sort by and press CTRL+C and CTRL+V to duplicate the data item.
Repeat Step 3 for each data item you would like to sort by.
Double-click on the copy of each data item to edit it, adding an apostrophe to the beginning and to the end of the expression so it looks like this: '[Academic Study].[Academic Study].[ACADEMIC_PERIOD]' and press OK.
Repeat Step 5 for each duplicate data item.
From the Toolbox drag a Data Item to the Data Items Pane. In the Expression Editor that pops-up type: if(#prompt('p_Direction','integer','1')#=1) then (#prompt('p_SortColumn','token','[PROGRAM]')#) else ('0') (1 means ascending and -1 means descending. We will have a data item that changes from 1 to -1 and vice-versa at each drill through.) Click OK. (Column that we will sort on will be the value of this parameter.)
Rename the newly created data item to: Sort_item_asc.
Create a copy of Sort_item_asc (using CTRL+C and CTRL+V). Rename the copy to Sort_item_desc.
Double-click Sort_item_desc to edit it and change =1 to = -1. Click OK.
In Page Explorer, click on Page 1 and then click anywhere in the list.
From the Report Studio menu, click on Data and then Advanced Sorting…
In the Grouping & Sorting dialog box that pops up drag Sort_item_asc on top of Detail Sort List.
Drag Sort_item_desc underneath Sort_item_asc in Detail Sort List folder and click on the Sort Order button to change it to descending.
Click OK.
From Query Explorer click Query 1 and add a Data Item from the Toolbox. Type this in the expression editor: -(#prompt('p_Direction','integer','1')#) Click OK. (This data item is the future value of the sort order on the next drill through.)
Rename Data Item1 to Direction.
In the Page Explorer click on Page1.
Click on the header column of the data item you want to sort by (the Properties pane should display List Column Title next to Ancestor Selector).
In the Properties Pane double click Drill Throughs. Click New Drill Through. For Report choose your report, for action choose Run the Report, click to edit parameters, choose Pass data item values as Method and for Value select the COPY of the data item you are sorting by for the p_SortColumn parameter and Choose Direction for the p_Direction parameter.
Click OK and then OK again.
Repeat steps 12 thru 14 for each data item column, but selecting the corresponding duplicate data item as the value for the drill through parameter. (Depending on the column title where the drill through is initiated from – we will assign the according value for the parameter that gives us the column to sort.)
From Run->Run Options…menus deselect Prompt and click OK.
Save the report and run. For each click on the column header the order changes from ascending to descending and vice-versa.

--
BI CENTRE
http://cognos8help.blogspot.com

How to apply simple conditional formatting in Report Studio?

How to apply simple conditional formatting of a report in Report Studio?

Resolving the problem

Highlight data in a report to better identify exceptional results. For example, to identify sales representatives who have exceeded their quota, create a condition that checks if each representative's sales for the year is greater than their quota for the year. Steps:1.Open the report that you want.
2.From the File menu, click Variables.

3.Create a variable by clicking the add button bellow the Variables box.

4.In the Name box, type a name for the variable.

5.In the Type box, select the type of variable you want to create:

To create a variable that has only two possible values, yes and no, click Boolean.

To create a variable whose values are string-based, click String.

6.Click OK.

7.Click the Edit button below the Expression box.

8.In the Expression Definition box, define the condition.

9.Click OK twice.

10.In the work area, click the column that you want to highlight based on the condition you just created.

11.Click the Condition Explorer button. The Condition Explorer dialog box appears.

12.Click the variable you just created.

13.In the Properties pane, click the Conditional Style property.

14.In the Variable dialog box, click the Variable box.

15.Click the variable you want to assign to the object.

16.In the Values box, select the values you want the condition to support.

Tip: A default value exists for each variable you define, and it is always selected.

17.Open the Condition Explorer dialog box again, and click one of the possible values for the variable other than the default value.

For example, if you created a boolean variable, click the Yes value.

18.In the Properties pane, specify the formatting that you want to highlight the column with when the condition is satisfied.

For example, click the Border property to create a thicker border around the column.

19.Repeat steps 17 to 18 for other possible values defined for the variable.

20.Repeat steps 10 to 19 for other objects that you want to highlight.

Tip: In the Condition Explorer dialog box, click (No variable) to view how the report looks when no variable is applied.

When you run the report, the report objects to which you applied the variable are highlighted when the condition is satisfied. For example, if you created a Boolean variable, the objects are highlighted when the condition is met.

--
BI CENTRE
http://bicentre.blogspot.com

How to apply simple conditional formatting in Report Studio?

How to apply simple conditional formatting of a report in Report Studio?

Resolving the problem

Highlight data in a report to better identify exceptional results. For example, to identify sales representatives who have exceeded their quota, create a condition that checks if each representative's sales for the year is greater than their quota for the year. Steps:1.Open the report that you want.
2.From the File menu, click Variables.

3.Create a variable by clicking the add button bellow the Variables box.

4.In the Name box, type a name for the variable.

5.In the Type box, select the type of variable you want to create:

To create a variable that has only two possible values, yes and no, click Boolean.

To create a variable whose values are string-based, click String.

6.Click OK.

7.Click the Edit button below the Expression box.

8.In the Expression Definition box, define the condition.

9.Click OK twice.

10.In the work area, click the column that you want to highlight based on the condition you just created.

11.Click the Condition Explorer button. The Condition Explorer dialog box appears.

12.Click the variable you just created.

13.In the Properties pane, click the Conditional Style property.

14.In the Variable dialog box, click the Variable box.

15.Click the variable you want to assign to the object.

16.In the Values box, select the values you want the condition to support.

Tip: A default value exists for each variable you define, and it is always selected.

17.Open the Condition Explorer dialog box again, and click one of the possible values for the variable other than the default value.

For example, if you created a boolean variable, click the Yes value.

18.In the Properties pane, specify the formatting that you want to highlight the column with when the condition is satisfied.

For example, click the Border property to create a thicker border around the column.

19.Repeat steps 17 to 18 for other possible values defined for the variable.

20.Repeat steps 10 to 19 for other objects that you want to highlight.

Tip: In the Condition Explorer dialog box, click (No variable) to view how the report looks when no variable is applied.

When you run the report, the report objects to which you applied the variable are highlighted when the condition is satisfied. For example, if you created a Boolean variable, the objects are highlighted when the condition is met.

--
BI CENTRE
http://cognos8help.blogspot.com

Purchase your Section 508 Compliance Support guide now!

Cognos 8 - One Click Dynamic Column Sorting

Cognos 8 - One Click Dynamic Column Sorting

How to apply simple conditional formatting of a report in Report Studio?

Resolving the problem

3.Create a variable by clicking the add button bellow the Variables box.

4.In the Name box, type a name for the variable.

5.In the Type box, select the type of variable you want to create:

To create a variable that has only two possible values, yes and no, click Boolean.

To create a variable whose values are string-based, click String.

6.Click OK.

7.Click the Edit button below the Expression box.

8.In the Expression Definition box, define the condition.

9.Click OK twice.

10.In the work area, click the column that you want to highlight based on the condition you just created.

11.Click the Condition Explorer button. The Condition Explorer dialog box appears.

12.Click the variable you just created.

13.In the Properties pane, click the Conditional Style property.

14.In the Variable dialog box, click the Variable box.

15.Click the variable you want to assign to the object.

16.In the Values box, select the values you want the condition to support.

Tip: A default value exists for each variable you define, and it is always selected.

17.Open the Condition Explorer dialog box again, and click one of the possible values for the variable other than the default value.

For example, if you created a boolean variable, click the Yes value.

18.In the Properties pane, specify the formatting that you want to highlight the column with when the condition is satisfied.

For example, click the Border property to create a thicker border around the column.

19.Repeat steps 17 to 18 for other possible values defined for the variable.

20.Repeat steps 10 to 19 for other objects that you want to highlight.

Tip: In the Condition Explorer dialog box, click (No variable) to view how the report looks when no variable is applied.

When you run the report, the report objects to which you applied the variable are highlighted when the condition is satisfied. For example, if you created a Boolean variable, the objects are highlighted when the condition is met. -- BI CENTREhttp://bicentre.blogspot.com

How to apply simple conditional formatting of a report in Report Studio?

Resolving the problem

3.Create a variable by clicking the add button bellow the Variables box.

4.In the Name box, type a name for the variable.

5.In the Type box, select the type of variable you want to create:

To create a variable that has only two possible values, yes and no, click Boolean.

To create a variable whose values are string-based, click String.

6.Click OK.

7.Click the Edit button below the Expression box.

8.In the Expression Definition box, define the condition.

9.Click OK twice.

10.In the work area, click the column that you want to highlight based on the condition you just created.

11.Click the Condition Explorer button. The Condition Explorer dialog box appears.

12.Click the variable you just created.

13.In the Properties pane, click the Conditional Style property.

14.In the Variable dialog box, click the Variable box.

15.Click the variable you want to assign to the object.

16.In the Values box, select the values you want the condition to support.

Tip: A default value exists for each variable you define, and it is always selected.

17.Open the Condition Explorer dialog box again, and click one of the possible values for the variable other than the default value.

For example, if you created a boolean variable, click the Yes value.

18.In the Properties pane, specify the formatting that you want to highlight the column with when the condition is satisfied.

For example, click the Border property to create a thicker border around the column.

19.Repeat steps 17 to 18 for other possible values defined for the variable.

20.Repeat steps 10 to 19 for other objects that you want to highlight.

Tip: In the Condition Explorer dialog box, click (No variable) to view how the report looks when no variable is applied.

When you run the report, the report objects to which you applied the variable are highlighted when the condition is satisfied. For example, if you created a Boolean variable, the objects are highlighted when the condition is met. -- BI CENTREhttp://cognos8help.blogspot.com

When you run the report, the report objects to which you applied the variable are highlighted when the condition is satisfied. For example, if you created a Boolean variable, the objects are highlighted when the condition is met.

--
BI CENTRE
http://bicentre.blogspot.com

When you run the report, the report objects to which you applied the variable are highlighted when the condition is satisfied. For example, if you created a Boolean variable, the objects are highlighted when the condition is met.

--
BI CENTRE
http://cognos8help.blogspot.com