Cognos Certification Dumps

Latest Cognos8 Business Intelligence Dumps for all of the tests listed below


   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.

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)