Sunday, August 29, 2010

Cognos Certification Dumps


We are providing latest cognos certification dumps for cognos8 as well as 10 .Below the list of the certification test

For cognos 10

Test COG-180 - IBM Cognos BI Professional
Test COG-612 - IBM Cognos 10 BI Author
Test COG-622 - IBM Cognos 10 BI Administrator
Test COG-625 - IBM Cognos 10 BI Data Warehouse Developer
Test COG-632 - IBM Cognos 10 BI Metadata Model Developer
Test COG-635 - IBM Cognos 10 BI OLAP Developer
Test COG-642 - IBM Cognos 10 BI Scorecard Developer
Test COG-645 - IBM Cognos 10 BI Multidimensional Author
Test COG-700 - IBM Cognos 10 Planning Application Consultant
Test COG-480 - IBM Cognos Planning Professional
Test COG-300 - IBM Cognos TM1 Analyst
Test COG-310 - IBM Cognos TM1 Developer

For cognos8

   1.  Test BI0 -  210 - IBM Cognos 8 BI Professional
   2.  Test COG-105 - IBM Cognos 8 BI Technical Specialist
   3.  Test COG-112 - IBM Cognos 8 BI Author
   4.  Test COG-122 - IBM Cognos 8 BI Administrator
   5.  Test COG-125 - IBM Cognos 8 BI Data Warehouse Developer
   6.  Test COG-132 - IBM Cognos 8 BI Metadata Model Developer
   7.  Test COG-135 - IBM Cognos 8 BI OLAP Developer
   8.  Test COG-145 - IBM Cognos 8 BI Multidimensional Author
   9.  Test COG-180 - IBM Cognos 8 BI Professional
   10.Test COG-300 - IBM Cognos TM1 Analyst
   11.Test COG-310 - IBM Cognos TM1 Developer
   12.Test COG-400 - IBM Cognos 8 Planning Application Consultant
   13.Test COG-480 - IBM Cognos 8 Planning Professional


Contact me at jamsheer.k@gmail.com for any of the dumps listed above

Adding Comments in Cognos Report Studio Expressions

You can add comments in  Report Studio expressions using  the below syntax.

#/*

Comments

*/#

Cognos Chart report Customisation

The customization of  the chart reports in cognos is very easy  there are many customizations other than conditional variable customizations in cognos for changing the report display properties, format options like header, footer, labels, titles, grouping, summarizing ,performance tuning like query performance, database performance etc.

To show or Hide the legend options or baselines markers or notes in a chart

Under the option for Chart Annotations, select on the the Legend or Baselines or Markers or Notes property and modify as per the requirement .

To show or Hide the axes in chart

Under the option for Axes, select Y1 or Y2 or Ordinal Axis's property and change it.

To show or Hide the axis line or axis title in Cognos charts

Click on the Y-axis and in the options pane, below the General Modify the properties for Axis Line and Title

To show or Hide the gridlines in chart report types

click on the y-axis or the ordinal axis. Below the General button, you find the Gridlines/ Minor Gridlines as a property, change it.

To display the border around the legend

Click on the legend icon. Below the General, alter the property called borders.

To make the Chart display in different 3D appearance

you can do that by changing the Depth or Visual Angle property in general options.

To show or Hide the border around the chart object

Modify the property called border property under the charts properties box.

To display the tool tips

Note: Some of the pdfs cannot render the tooltips.

to change this, you can simply modify the tooltips property.

To change the options like range or interval in Y-Axis properties

you can select the options Minimum value, Maximum Value, Scale interval, Scale Property Under the options General.

To modify the data format

Click on the y-axis and below option Data, you find the Data Format property, change it.

To alter ordinal axis properties like label truncation or skip interval

Click on the ordinal axis. Below the option General, Click on the Truncation -> Allow Rotation or Allow Stagger or Allow Skip property.

To remove it. a white space around the chart

Click on the option for Padding/Margin property and change it.

You can find the below options under the options Color and BackGround.

To change the colors of the lines and bars in charts

Change the Palette or Conditional Palette property.
 Apply a palette to a series

Change the Series Color property.

Change the default color or font for all chart elements

change the Background Color, Foreground Color, or Fill Effects property.

And you can also change the Font or Relative Alignment property, below the opions for Font & Text.

To Insert a background image or watermark in a chart report

Go to the Background Image property and change it.

Override the default font or color for axes and chart values

Select the lock icon in the toolbar and unlock the chart object,You can also Click on the chart body by clicking on the place between the axes, and modify the Background Color or Foreground Color or Font or Fill Effects property.

To Resize the chart

Below the options for Positioning, modify the Size & Overflow property.

 Insert a background image or watermark in the chart body, that is, the space between the axes

Select the lock icon in the toolbar and unlock the chart object, click on the chart body by clicking between the axes, and change the Background Image property.

Saturday, August 14, 2010

IF THEN ELSE and CASE in FILTER

You can't directly use the case statement in a filter expression inorder to change the filter condition according to the prompt selection by a user.To acheive the result it can be done in two ways one is we can use a nested case expression

Methode 1:
case when ?p_param?=1 then
    filter1
else case when ?p_param?=2 then
    filter 2
end
end

Methode 2:

The same result can be acheived by using if else if .
eg:

if (?p_param? = 'CURRENT DAY')

then ([gosales].[Sales].[Current
Day]=[gosales].[Daily Calendar].[Current Day])

else if (?p_param? = 'WTD')
then ([gosales].[Sales].[WTD]
=[gosales].[Daily Calendar].[WTD])

else if (?p_param? = 'PTD')
then ([gosales].[Sales].[PTD]
=[gosales].[Daily Calendar].[PTD])

else if (?p_param? = 'YTD')
then ([gosales].[Sales].[YTD]
=[gosales].[Daily Calendar].[YTD])

else (0)

Saturday, January 16, 2010

Apply a new template to an existing report in Report Studio

Use the ... and .. tags in the template xml file to replace these two parts in the Report xml file.

Steps:

1.) Open the template in the Studio and click Tools, Copy Report to Clipboard
2.) Open Notepad (or similar text editor) and paste the template xml copied in step #1
3.) Open the existing report in Report Studio and click Tools, Copy Report to Clipboard.
4.) Open another instance of Notepad (etc), and paste the report xml copied in step #3
5.) Click on the notepad instance with the template xml contents (to give it focus).  Find and highlight the section from to , and copy it.
6.) Return to the instance of Notepad with the report xml (from step #4).  Find and highlight the section from to , and paste in the copied XML from the template XML file.
7.) Repeat steps 5 and 6 for to .
8.) Within the modified report XML instance of Notepad, do a "Select all" (Ctrl-A, right-click menu, or from the toolbar menu) and copy the entire contents.
9.) Within Report Studio, click Tools, then Copy Report from Clipboard.