IBM Cognos Multiple Choice Questions & Answers

 

1.          Which default property measure has when you add it to report –

a.      Aggregate

b.      Drill Down

c.       Drill Up

d.      None

Answer:  a.

 

2.          Which of the following section Report Specification does not contain?

a.      Specification Header

b.      Queries

c.       Layout

d.      Database

Answer: d.

 

3.          Store Procedure in FM can be imported which returns cursor.

a.      True

b.      False

Answer: a.

 

4.          Active reports can be viewed on

a.      Desktop

b.      Ipad

c.       Android

d.      All of the above

Answer: d.

 

5.          What is extension of transformer cube files-

a.      .mdl

b.      .pyj

c.       Both a &b

d.      None

Answer: c.

 

6.          SQL query can be added to reports studio report.

 

a.      True

b.      False

Answer: a.

 

7.          Framework manager create a package which has extension

a.      .cpf

b.      .xml

c.       .cp

d.      None

Answer: a.

 

8.          Which of the following where Administrator can configure metadata database connection.

a.      Cognos Framework Manager

b.      Cognos Connection

c.       Cognos Administration

d.      Cognos Configuration

Answer: d.

 

9.          Which of the following permission are type of IBM Cognos security.

a.      Write

b.      Execute

c.       Traverse

d.      Set policy

e.      All of the above

f.        None

10.      IBM Cognos does not support ODBC connections

a.      True

b.      False

Answer: b.

 

IBM Cognos SDK Set Up in Eclipse

Step by Step with SDK in IBM Cognos

       As per the previous article on same topic https://innovatechanalytics.blogspot.com/2019/12/ibm-cognos-sdk-developer.html, we could understand the pre-requisite to implement SDK in IBM Cognos. Therefore, we need first eclipse and .jar files primarily. Make sure, your Computers should have java installed, which is compatible to eclipse version. There are many eclipse version, which has java compatibility issues. 

Below are the steps to set up to create new project in eclipse –

1.      Launch Eclipse, Create a java project from File > New > Java Project

2.      Name to Java Project

It looks like as below –

3.      Import .JAR files from Cognos Content manager location /SDK/java/Lib

a.      Right Click on JRE System Lib > Build Path > Configure Build Path

b.      Add External Jars, Ref snip below -

4.      Once you set up these entire necessary pre requisite, and then go to design custom java code. You are going to create .Java files in Src folder. After importing external jar files, you no need to give any other path in your java code.

Custom java code automatically refer these jar files, its classes and functions. If you need, you can expand the jar files and read all its function along with descriptions mentioned over there. Upcoming article includes first java program with Cognos.

Thanks for reading this article!

IBM Cognos SDK Developer

        Step by Step with SDK in IBM Cognos

First, you need to the background of SDK with IBM Cognos. SDK is Software Development Kit to integrate IBM Cognos into your existing software or portals and to provide several methods for developing custom solutions. Before proceeding to use SDK, you need to have knowledge about any of the Java, VB .NET, and C# which is used to design various codes in order to customizing, and embedding Cognos BI processes. I would recommend to use Java language to implement SDK.

Following are the steps to begin SDK environment –

1.     Install Eclipse/NetBeans or any java IDE platform.

-         This is to run the java program.

2.     Install IBM Cognos SDK suit on your server where the Content manager is installed in your IBM Cognos environment

-         This is to generate the required java libraries, which are compatible to your environment.

3.     Import these libraries in your eclipse.

-         This is required to call IBM Cognos objects / methods. This is present in you IBM Cognos installation location in SDK folder mostly, in  /sdk/java/lib .

You may find the description of these Jar files on IBM Site-

https://www.ibm.com/support/pages/sdk-how-use-sdk-libraries-including-axis-jar-files-software-application

We have implemented the IBM Cogons SDK in our project which helped us to reduce efforts and save the customers cost.

Thanks for reading the article!!!

I will back with another article on same topic  J