Cognos Interview Questions and Answers Q.What is a Data Warehouse? Ans: Data Warehouse is a collection of data marts representing historical data from different operation data sources (OLTP). The data from these OLTP are structured and optimized for querying and analysis in a Data Warehouse. Q.Define Cognos Report Net? Ans: Cognos Report Net is the web-based, dynamic, business intelligence reporting solution from Cognos. Q.What are the tiers of the ReportNet Architecture? Ans: The ReportNet architecture can be separated into three tiers:
- Web server
Q.Define Business Intelligence Ans: Business Intelligence is a broad category of application programs and technology used for query, Reporting and analyzing the business multi dimensionally. Q.What is a Data Mart? Ans: Data Mart is a subset of a data warehouse that can provide data for reporting and analysis. Q.What is HPQS ? Ans: Data Marts are sometimes also called as HPQS (Higher Performance Query Structure). Q.What is multi dimension analysis? Ans: It is a technique to modify the data so that the data can be view at the different levels of details. Q.What are the responsibilities of Cognos Administrator? Ans: Cognos Administrator is assigned with following responsibilities.
- Installations and configurations in distributed network environment.
- Creating the Repository (Content Store).
- Perform back up and recovery of Meta Data.
- Developing the user Administration.
- Tuning the servers.
Q.Responsibility of Cognos Architect? Ans: An Architect is responsible for designing the interface by fulfilling the user requirements.Once the interface has been designed it should be rigorously tested before distributing to the end user population. Q.Roles of the Application Developer? Ans: Design the Reports according to the Report requirement templates. Testing the each report with the following types of tests.
- Unit Testing
- System Testing
- Performance Testing
Q.What is OLAP? Ans: OLAP stands for Online Analytical Processing. It uses database tables (Fact and Dimension tables) to enable multidimensional viewing, analysis and querying of large amount of data. Q.What are the types of OLAPs? Ans:
- DOLAP:-The OLAP tool which works with desktop databases are called as DOLAP Ex:- FoxPro, Clipper, Dbase, Paradox.
- ROLAP:-The OLAP tool, which works with Relational databases, are called as ROLAP. Ex:-Oracle, SQL Server, Tera Data, DB2.
- MOLAP: - The OLAP tool, which works with Multidimensional databases, are called as
MOLAP. Ex:- ESSBASE, Power Cube
- HOLAP:- The OLAP tool which works with Relational databases and Multidimensional database, are called as MOLAP.
Ex:- Cognos, Business Objects. Q.What is OLTP? Ans: OLTP stands for Online Transaction Processing. Except data warehouse databases the other databases are OLTPs. These OLTP databases are designed for recording the daily operations and transactions of a business. Q.What is an Interface? Ans: An Interface is a gateway between the user and database. An Interface contains a logical pointers which pointes to data in the Data Warehouse. An Interface is isolates the complexity and diversity if data bases. A good OLAP Interface writes an efficient SQL read on accurate data from database. An Interface needs to be designed by fulfilling the report requirement. Q.What are the types of components installed while loading the Cognos Report Net Software? Ans: When we install the Cognos Report Net Software there are two types of components get installed :-
- Windows based components. 2. Web based components.
Q.What is the security module used in cognos? Ans: The security module used in cognos is cognos access manager. Q.What is report burn and where it occurs? Ans: Report can be divided into different parts and sending these different parts of report to different users. It occurs in cognos connection. Q.What is difference between drill through and drill down? Ans: drill through allows u to navigate from summary to detailed information. drill down also similar kind of thing, for example will do drill down on year if we drill down on this the next level will come means year contains quaters, it contains months, months contains weeks, week contains days. so,we can view all the levels through drill down For example I developed some reports on employee package now I have to develop same reports to another package. Q.How can I change reports to another package? Ans: Open that report and save as that reportSelect public folder and then select package in which package u want to save then save it. Q.How to create users and permissions in cognos? Ans: Users and Permissions can be given in Access manager - Administration. Individual users can be created using their names or their Ids (if any) in Access manager and then be given permissions. This tool is loaded when you install Cognos 7.x in your machine. In content manager--we have one component called cognos process manager, using process manager we can integrate with third party tools like LDAP or NTLM. we cannot create users in reportnet directly. in real time we can use LDAP. Q.What is the difference between macros and prompt? Ans: Macro is set of instructions to run report. Prompt is just like a dialog box which will ask user to select/enter the information what he needs. A MACRO IS RUN TIME PARAMETER WHICH CAN BE PLACED IN ANY PART OF SQL SELECT STATEMENT,WHERE AS PROMPT IS USED TO GIVE CONDITIONS. Q.What is Cognos Visualizer and Cognos Scripting? Ans: Cognos scripting is like a language, with this we will create macros, Macro is a set of instructions to run a report. Cognos Visualizer is a tool for creating charts(bar, pie, histogram......) & maps using datasources(datafiles like mdc,iqd,csv,excel etc). Q.What is query subject? Ans: A query subject is the basic building block in Framework Manager. A query subject is a set of query items that have an inherent relationship. Q.What are the Ways to Import Data into Catalog? Ans: Create a catalog with .cat file... Q.Report studio has two SQL tabs one native SQL and another one cognos SQL which one is get more preference? which one we need to consider? Cognos sql Q.When we save a report in report studio with what extn it save? Ans: It saves as .XML It will save as .CRRWhen we save the report it save our specifications like u can choose(in report studio RUN MENU by clinking down icon) HTML,XML,CSV,OR PDF Format if u save the report HTML u can also run report different format as u like or different language also Depends on the format on which the report is being run. By default its .html format. The report can be made to run in any formats like HTML, PDF, XLS, CSV ( Comma separated format) and XML and based on that, report can be saved in either .html, .pdf, .xls, .csv or .xml When you r viewing the report in the package is shown with extension .crr Q.How can I convert a list report/Cross tab Report in Cognos EP series into a bar chart or pie chart etc.? Ans: This can be done in Impromptu administrator Q.How many numbers of cubes can we create on a single model? How can we navigate between those cubes? Ans: Using a single Model, we can create as many number of cubes u want. By using the dimension views...etc. Regarding the navigation, when we save cubes, these act as separator multidimensional databases. There wont be any relations. Navigate means opening the cubes separately. Q.What is the difference between drill down and drill through? Ans: Drill down means it will navigate from detail information to summary level information within report. Drill through means it will navigate from summary to detail from report to report. Q.What is the difference between group and association? Ans: In cognos 'group' is used to suppress the duplicate values. And 'associate' is used to suppress the values if it is one-one relationship. Group - It Eliminates the Duplicate values from the report break the columns. Its having a one to many relationship. Association-It Eliminates the Duplicate values from the report and its having one-one relationship. Both Group & Association eliminate duplicates in a column.But we cannot use Association alone.It should have one to one relationship with grouped column. Using Association is a performance enhancement technique. A GROUP IS USED TO ELIMINATE THE DUPLICATES IN DATA.WHERE A ASSOCIATION IS USED TO HIRE OR SUPPRESS THE VALUES IN 1 TO 1 RELATION. Q.What is Cardinality? Ans: Cardinality is nothing but relation between tables like One to One, One to Many and Many to Many. Cardinality is the nature of the relationship. 1-1,1-many relation shipsCardinality is the nature of the relation between two query items Q.How to test reports in cognos? Ans: Go to power play transformer, on toolbar select RUN menu. In RUN menu there is one option that is TEST BUILD you can test ur report there. You may also test the outcome of a report by writing and executing SQL Queries and comparing the outcome with the report outcome. BY USING SYSTEM TESTING, UNIT TESTING, PERFORMANCE TESTING Q.How u create security to reports? Ans: Basically there are two types of securities for any object Levels of Securities:
- Database level Security
- Row level security
Even we can provide LDAP security too. By setting up the Governors in frame work manager also we can give the security to the data accessing through the report. Q.How to find out YEAR CALCULATION? THAT MEANS YOU SHOW THIS YEAR REVENUE AND LAST YEAR REVENUE. WHEN YOU FILTER THIS YEAR VALUE THE RESULT SHOULD DISPLAY THIS YEAR RESULT AND LAST YEAR RESULT? Ans: By using expressions, I mean by using conditional constructs and through graphs. we can view the revenue and calculated data as well. Q.How to configure the Cognos configurations to work in the Windows 2000 Server machine? Ans: Go to Cognos Configuration and see the settings for cognos in the explorer page. There u can set for win2000 server Q.What is drill down and slicing and dicing what are the difference between them? Ans: Drill down means it will explains the summary level information to lowest level information. Slicing is nothing but cutting edge of the cube. Dicing is nothing but viewing the cube in all possible directions. Drill down is the way to get the more detailed data. Slicing and dicing is to get the data according to where clause. Q.What are the enhancements in Cognos Reportnet ? Ans: Enhancements in Cognos reportnet is Cognos 1.0, 1.1, MR1.1, MR1.2 Cognos 1.0,1.1, MR1.1, MR1.2 AND cognos 8, 8.1.1MR, 8.1.2MR, now new version is 8.2 Q.Enhancement in cognos in the list report:- Ans: 1) Apply list column title styles 2) Apply list column body styles 3) Apply table styles Q.Explain the different stages in creating a report in cognos report net? Ans: Open cognos connection in that select Report studio or query studio it will displays there u have packages(ex: gosales and goretailr (defult)) click on that it display Report studio in that select Object pane select required query subject then click run it displays ur report on report viewer screen. Q.What is Report item? Ans: Report item is nothing but a query item when it is drag and drop into the work area. Example in Go sales and retailers package-> Product (is a query subject) and-> Product line is( a query item)->when PL is dropped into the work area then its a report item. Q.How to perform single sign on in Cognos by using URL? Ans: In cognos configuration under authentication allow anonymous access should be false.In cgi-bin properties (under iis) the enable anonymous access should be false. Q.What is loop in framework manager? Ans: Loop is closed path in reportnet it called as ambiguous relationship. That means a query subject contains multiple paths to retrieve the data. It is an exception to resolve to create a shortcut on that query subject otherwise it displays wrong results in reports and performance is degrades. An undefined join between two tables is known as loop.To resolve loop delete the joins, if these joins are necessary then we have to create shortcuts nothing but alias tables. Place the joins in alias tables. A LOOP IS A CLOSED PATH IN FRAME WORK MANAGER DUE TO JOINS. WE ILL RESOLVED IT BY CREATING ALLIAS AND CREATING SHORT CUTS. Q.How you migrate reports to cognos 8 from previous versions? Ans: Migration means report net reports to cognos8.rn Upgrade .bat/rs upgrade .sh is a standalone utility that upgrades a single report specification at a time out side of the cognos. Q.What are the filters in Framework Manager and Report Studio? Ans: Filters in framework manager are
- Standalone filters
- Embedded filters
Report studio Filters are
- Detail filters
- Summary filters
- Create a calculated column which contains the information that the header is to contain, such as "Report for year 1999" (concatenated text and date to string sub string extraction).
- Highlight the report, and then right-click.
iii. Select Properties, and then click the Headers/Footers tab.
- Clear the Column Title Header check box. This will remove the headers from your columns.
- Reinsert the rest of the column headers; insert text will work.
- For the dynamic column, from the Insert menu, click Data and select the calculated column you created and insert it into the report.
In Cognos 8.0, First create a Calculated Data Item, select the list, associate it with the Query in Which Calculated Data Item is created, then click on Structure and then List Header and Footers. Check List Header and make the Box Type of the Column header as None. Unlock and then drag the Calculated Data Item into the required header which will look like a Column Header in the report. For making a column name dynamic the only thing that you have to do is insert a layout calculations from the toolbox tab in report studio. I came across this answer because I wanted each column in across tabulation to have a text description different from the variable (column's) name. Cognos's gloriously useless documentation says nothing on how to do this and adding text isn't an allowed action in page design mode (the error message you get goes beyond unhelpful). To have the column titles, row footers, etc., you want: 1) Switch to page structure view in report studio 2) Expand the crosstab by clicking the plus signs untilcrosstab row levels, crosstab level(variable_name), etc. are visible. 3) From the insertable objects, drag a 'Block' at the level you’d like to add the text. This takes some experimenting. 4) after the block's been added, add into the block a Text Item from the insertable objects. 5) a window will open and you can type in whatever text you want.It's no wonder Jim Goodnight has such harshness towards Cognos. Q) What r the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet? Ans: Reportnet1.1 migration tool is available to migrate the impromptu report to reportnet. Q) Can reportnet supports cubes? Ans: No Q) What are versions of cognos from starting release to latest in the market? Ans: Cognos EP7 series,Cognos reportnet1.1 Mr1,MR2,MR3,MR4,cognos8.0,8.1, 8.2,8.3 Q) What is IQD? What is contained in IQD? How you create IQD In ReportNet FrameWork? Ans: IQD is impromptu Query Definition. It's a transformer report. To use an IQd in reportnet framework manager, there is a process called externalization using which you can import the IQD. IQD Is impromptu query definition, the name it self indicating dat, it contains the SQL statement. To create the iqd in Frame work manager, create a new query subject with required query items . Set the Externalise method property of that Query subject to 'iqd'. While the publishing the package select the 'Generate the files for Externalized query subjects'. And publish it to the local machine, which can be used as data source for Transfromer model. Q) How u provide security to reports? How u provide security to packages ? Ans: Through Access Manager. Q) How to select multiple values from Type-in prompt? Ans: Example - I want to enter into type-in prompt in 'Product name--- Liza' display report data in 'product name is Leza' only OR I want to enter into type-in prompt in 'All', that time display report data in all are report data. Q) How is possible this Scenario using in type-in prompt.? Ans: Here we can enter one value, here it can't shows lovs. In catalog colomns we can select the value for which we can insert the pick list. Can you be more specific abut this. What i understand from the question, you have a prompt page with a text box prompt and the user types the value. When the user types the product name ' Ex: laptop' and clicks 'finish' the report page has to display all the records relevent to laptop. When the user types 'All' in the text box prompt and clicks 'Finish' the report has to display all the products. BY USING STRING VARIABLE WE CAN SELECT(OR)ENTER MULTIPLE VALUES By using the following condition as the filter for the textbox prompt we can get the data for the specified product as well as All products when we type ALL in textbox prompt Product name = ?P_ProductName? or 'ALL' in (?P_ProductName?) Q.What is Defect/Bug/Error Life Cycle? Ans: Defect--During requirement phase if we find its called as defect.A defect in requirement. Bug-----During testing phase if we find its called a BUG. Error Life Cycle- 1) Open 2) Assigned(assigned to dev) 3) Dev-passed(after fixing) 4) Under testing(when testing team receives the fix) 5) Closed (if working fine) else reopen Defect is the issue caught while Testing, When the as said is accepted by the developers then the as said is called as a Bug;Error always occurs in the coding during Unit Testing by the development team. (Issues regarding the coding are said Error's) A Mistake in coding is called an ERROR. This mistake detected by test engineer during testing called defect(or) issue. This defect (or)issue accepted by defect tracking team as code related defect called BUG. When we found a defect /Bug we will set the status New and set the severity and then assign to the junior senior people based on the severity they will set the priority and then they will assign to corresponding developer based on the severity dev fix it. And again tester again re-tested he will fix correctly close the bug, otherwise then again re assign to the corresponding dev. Framework Manager Q.What is Framework manager? Ans: Frame Work Manager is windows based metadata development or metadata modeling tool for Cognos Report Net. Q.What is Folder? Ans: A Folder is used to organize the Query Subjects. Q.Define Relationship? Ans: Relationship is a connection that explains how the data in one Query Subject relates to data in other Query Subjects. Q.What is a Package? Ans: A container for models, reports, and so on. Modelers create packages in Framework Manager to publish models to the ReportNet server. Q.What is Physical layer? Ans: The Physical layer provides the physical query layer and is made up primarily of data source and stored procedure query subjects. It acts as the foundation for the presentation layer. Q.What is Presentation layer? Ans: The Presentation layer makes it easier for report authors to find and understand their data. The Presentation layer is made up primarily of model query subjects that you create. Q.What is a Model? Ans: A model in Frame work manager is a business presentation of the structure of the data from one or more databases. Or A model is a set of related query subjects and other objects. Q.What are Fact Tables? Ans: A Fact Table is a table that contains summarized numerical (facts) and historical data. This Fact Table has a foreign key – primary key relation with a dimension table. Q.What are the types of Facts? Ans: The types of Facts are:
- Additive Facts:- A Fact which can be summed up for any of the dimension available in the Fact Table.
- Semi-Additive Facts:- A Fact which can be summed up to a few dimensions and not for all dimensions and not for all dimensions available in the Fact Table.
- Non-Additive Fact:- a fact which cannot be summed up for any of the dimensions available in the Fact Table.
Q.What are the types of SQL? Ans: SQL is the industry language for creating, updating and querying relational data base management system. Types of SQL.
- Cognos SQL
- Native SQL
- Pass-through SQL.
Q.Define Cognos SQL? Ans: By default Cognos FM uses Cognos SQL to create and edit Query subjects. Advantages:
- Can contain metadata from multiple data sources.
- Have fewer database restrictions
- Interact more effectively with Cognos applications.
Disadvantages: You can not enter nonstandard SQL. Q.Define Native SQL? Ans: Native SQL is the SQL, the data source uses, such as Oracle SQL, but you cannot uses Native SQL in a query subject that references more than one data source in the project. Advantages:
- Performance is optimized across all related query subjects.
- You can use SQL that is specific to your database.
- You cannot use SQL that the data source does not support for sub queries.
- The query subject may not work on different database type.
Q.Define Pass-Through SQL? Ans: Pass-Through SQL lets you use native SQL without any of the restrictions the data source imposes on sub queries. Advantages:
- You can enter any SQL supported by the database.
Disadvantages: 1.There is no opportunity for Frame work manager to automatically optimize performance. The SQL may not work on a different data source. Q.What are Query Processing Types? Ans: There are two types of query processing.
- Limited Local: The database server does as much of the SQL processing and Execution as possible. However, some reports or report sections use local SQL processing.
- Database only: The database server does all the SQL processing and execution with the exception of tasks not supported by the database. An error appears if any reports of report sections require local SQL processing.
Q.What is Query Subject? Ans: A Query Subject maps to the table in the database. A Query Subject uses an SQL to retrieve the data from the data source. A Query Subject is also known as Business View. Q.What are the sources to create new Query subjects? Ans: A new Query Subject can be created from the following sources.
- Model (Query subjects & Query Items)
- Data Sources (Tables and Columns)
- Stored Procedure.
Q.What is Multi Database Access in Cognos Report Net? Ans: In Cognos Report Net a Project can be created from multiple databases. The databases can be either homogenous or hydrogenous. Q.What are Parameter Maps? Ans: A Parameter Map is a key value pair used in creation of conditional Query Subjects. A Parameter map sub situates the values at the query at runtime. Contact for more on Cognos Online Training
Cognos interview questions Tags
cognos interview questions and answers,cognos online training, cognos interview questions, cognos training online, cognos training, cognos training institute, latest cognos interview questions, best cognos interview questions 2019, top 100 cognos interview questions,sample cognos interview questions,cognos interview questions technical, best cognos interview tips, best cognos interview basics, cognos Interview techniques,cognos Interview Tips. For online training videos