Interview Questions.

Question 1. What Is A Report Studio?

Answer :

Using Report Studio we can create more advanced professional Business Reports.

Question 2. What Is Burst?

Answer :

To create many report results via jogging a single report once. For example, you could create a file that suggests sales for each employee, and run it as soon as, sending special consequences to nearby managers through bursting on region.

You installation bursting in Report Studio and permit it in the portal.

Informatica Interview Questions
Question 3. Define Calculated Member?

Answer :

A member of a measurement whose measure values aren't stored but are calculated at run time the use of an expression.

Question four. What Is Cardinality?

Answer :

For OLAP information resources, cardinality is the wide variety of members in a hierarchy. The cardinality belongings for a hierarchy is used to assign remedy orders to expressions.

For relational data resources, cardinality indicates the nature of the connection among two question subjects, question objects, or other version items.

Informatica Tutorial
Question 5. Define Report Specification?

Answer :

An XML illustration of the queries, prompts, layouts, and styles in a document. You create document specs by the use of Report Studio or Query Studio, or by means of writing your own file specs in XML.

IBM Cognos Interview Questions
Question 6. What Is Report View?

Answer :

A connection with any other record that has its personal residences, together with set off values, schedules, and results.

You use file views to percentage a report specification as opposed to making copies of it.

Question 7. What Is Report Item?

Answer :

A question item that is brought to a report is called a record item.

Report items appear as columns in list reviews, and as rows and columns in crosstab reports. In charts, document gadgets appear as facts markers and axis labels.

IBM Cognos Tutorial Data Warehousing Interview Questions
Question eight. What Is Work Area?

Answer :

The vicinity inside a studio that incorporates the report, analysis, query or agent currently being used.

Question nine. What Is Simple List Report?

Answer :

The information is displayed in a sequence of columns (Tabular format).

DWBI Interview Questions
Question 10. How To Set Page Breaks?

Answer :

To set the web page breaks inside the report wishes to be designed with either Group or Section.

Each Group or phase may be displayed in a separate page.

Data Warehousing Tutorial
Question 11. What Is The Procedure For Page Breaks?

Answer :

Select the Grouped Report Item, from the changed format menu click on set page breaks.

IBM Cognos TM1 Interview Questions
Question 12. Define Sections?

Answer :

Like institution a segment also eliminates the duplicates and show the document item as a separate block and separated from rest of different file gadgets.

Informatica Interview Questions
Question thirteen. How To Eliminate Duplicates?

Answer :

The duplicates can be eliminated with the aid of creating the Groups.

Software Development Lifecycle (SDLC) Tutorial
Question 14. What Is A Prompt?

Answer :

A prompt is an cease customers item which lets in you to select the values or enter the values to restrict the facts displayed in the record.

A record element that asks for parameter values before the report is administered.

A Prompt is called dynamic filter out.

Prompt may be created using Parameters enclosed between ? Marks.

Ex :- ?Set off?

Question 15. What Are The Types Of Prompts?

Answer :

The following are the forms of prompts:

Text field Prompt
Value Prompt
Select and Search Prompt
Date Prompt
Time Prompt
Date and time Prompt.
Cognos ReportNet (CRN) Interview Questions
Question 16. How Many Ways Are There To Create Prompt?

Answer :

To create a spark off you could:

Use the Build prompt web page device.
Build your very own activate and spark off web page.
Create a prompt at once in a report page.
Adaptive software development Tutorial
Question 17. What Is A Non-reusable Prompt?

Answer :

The prompts which are created within the record surroundings are referred to as as Non-reusable activates.

Software Development Lifecycle (SDLC) Interview Questions
Question 18. What Is A Cascading Prompt?

Answer :

A prompt that uses values from a preceding activate to filter out the values within the present day activate or Pick list.

IBM Cognos Interview Questions
Question 19. How Many Ways We Can Create Cascading Prompt?

Answer :

A Cascading Prompt may be advanced in a  unique approaches:

Single pick out and auto publish cascading spark off.
Multi select and Re-set off button cascading set off.
Question 20. What Kind Of Relationship Is Required For Cascading Prompt?

Answer :

To broaden the cascading spark off the relationship among the dimensional query Items must be 1 to many (1: M).

Cognos BI Interview Questions
Question 21. What Is A Filter?

Answer :

A filter is a circumstance, which restricts the amount of information displayed within the report.

Question 22. What Is Detailed Filter?

Answer :

If the filter is implemented before aggregation known as aggregated records are filtered. (Detailed Records are filtered)

Question 23. What Is Summary Filter?

Answer :

If the clear out applied after aggregation than aggregated data are filtered.

Question 24. What Is Group Filter?

Answer :

A filter out that's implemented to the institution is called Group Filter.

Data Warehousing Interview Questions
Question 25. Define Sorting?

Answer :

Sorts the data within the following 2 directions:

Ascending
Descending
The default type is don’t sort.

Question 26. Define The Custom Group?

Answer :

A custom organization allows you to compare one element in the attribute with closing all factors with inside the same characteristic.

It is described for comparative evaluation.

It lets in comparing one detail with closing all.

Question 27. How The Pages Of A Single Report Delivered To The Browser?

Answer :

Based at the order of the pages upload to the file.

DWBI Interview Questions
Question 28. In How Many File Formats We Can Export Report Data?

Answer :

The records may be exported into the subsequent document codecs:

PDF layout (Portable Document Format)
CSV Format (Comma Separated Value)
XML Format
Question 29. Use Of Header And Footer In Reports?

Answer :

Headers and Footers can help you layout the file and gift the data in a readable layout.

Question 30. Can You Convert List To Cross Tab Report?

Answer :

Yes, to advantage a exceptional attitude on your facts, you could convert a listing report right into a pass tab record.

To convert list to pass tab file minimal three report items required.

Question 31. Can You Convert To Repeater?

Answer :

Only a listing document can be converted into a repeater. You can not convert a go tab or chart into a repeater.

Question 32. What Is A Calculation?

Answer :

According to the report requirement a calculation needs to be achieved the usage of an item referred to as calculation object this manner is called OLAP Scrubbing.

Question 33. What Are The Types Of Calculations?

Answer :

There are 3 varieties of Calculations:-

Detail:- Calculation is carried out for non-aggregated (Detail)  records
Group: - Calculation is carried out for aggregated statistics.
Layout Calculation: - Calculation is done to broaden custom designed record titles, page No, and so forth...
IBM Cognos TM1 Interview Questions
Question 34. To Get The Possible Outcomes What Types Of Variables You Use?

Answer :

Boolean variable: If there are only two viable outcomes, wherein the fee can be YES or NO.
String variable: If there's multiple final results, based totally on string values you will specify.
Language variable: Language variable while the values are unique languages.
Question 35. What Is Master Detail Relationship?

Answer :

A Master element dating lets in you to merge a Master query and Detail question.
To link the Master query and the Detailed question there should be a commonplace column between the query.
A Master element report gives navigation shape precis to detail.
Question 36. What Is Drill Through?

Answer :

A Drill Through allows you to navigate the statistics from summary to element.

A Drill Through identity advanced with two reviews

Parent Report which incorporates Summary Data.
Child Report which includes Detailed Data.
Their should be a common column between the two reviews.

Cognos ReportNet (CRN) Interview Questions
Question 37. Define Cross Tab Report?

Answer :

Design a Cross Tab Report for comparative analysis. Cross tab record is created with three   drop zones.

Row
Column
Measure
Question 38. What All The Types Of Cross Tab Layouts Cognos Report Net Supports?

Answer :

Cognos Reportnet supports only Basic and Nested Cross Tab layouts.

Question 39. Define A Chart?

Answer :

A Chart is a graphical presentation of enterprise facts.
A chart Report is designed for comparative Analysis.
Question 40. What Are The Different Types Of Charts?

Answer :

Column chart
Bar Chart
Pie Chart
Line Chart
Area Chart
Point Chart
Radar Chart
Software Development Lifecycle (SDLC) Interview Questions
Question 41. Define Collapse Group?

Answer :

It will suppress (disguise) the details of a grouped report.

Question forty two. Define Expand Group?

Answer :

It restores the information. A record needs to be designed with group.

Cognos BI Interview Questions
Question forty three. What Are Enhancements In List Report In Cognos 8 Report Studio?

Answer :

A listing file is more desirable with following capabilities:

Can apply List column Title Style
Can observe listing column Body Style
Can apply the table Style
Question forty four. What Are Enhancements In Cross Tab Report In Cognos eight?

Answer :

Cross tab record is more desirable with following functions:

Can create the union Cross tabs.
Can create headers and footers for a pass tab.
List like cross tab.
Question 45. What Are Enhancements In Chart Report In Cognos eight?

Answer :

A Chart report is more desirable with following capabilities:

1. The following new charts are upload

Gauge Charts
3-d point chart
By polar axis charts (used for Bio-era).
2. The chart can be implemented with patterns, Fonts, Colors.
Three. Can perform drill on chart.

4.Now we are able to create map reviews which incorporates Geographical data and compares the commercial enterprise with numerous geographies.

Question 46. What Is Prompt Cache?

Answer :

When a file incorporate a set off executes a spark off queries the data from database at first actual time and shops the effects in spark off cache.

Question forty seven. What Is Query Studio?

Answer :

Query Studio is the adhoc querying device.

Question 48. What Is A Adhoc Report?

Answer :

An adhoc record is a easy document or one-time record that is outdoor the set of wellknown reviews you could have available to you.

A layout time surroundings acts as a runtime surroundings.

It’s additionally referred to as self provider.

Question forty nine. What Is Measure?

Answer :

A query object that consists of values that can be aggregated to supply significant effects. For instance, product fees may be dealt with as a degree because average and general costs have some that means, but product codes, though numbers, are not usually treated the equal manner. Measures are quantitative performance indicators.

Measures deliver the numbers that typically appear inside the cells of cross tab reports or inside the numbers of a chart.Measures are also called data.

Question 50. How Grand Totals And Sub Totals Are Generated In Query Studio?

Answer :

In Query Studio the footer summaries (Grand Totals) are mechanically generated for measures.

The sub totals may be generated through developing the Groups.

Question fifty one. Define Layout?

Answer :

In reporting, format defines the advent of the document, such as formatting, style, and layout.

In document specifications, layout is likewise the call of an detail that defines how the records back by queries is presented.

Question fifty two. What Are Enhancements In Cognos eight Query Studio?

Answer :

Formatting :- Now question studio permits you to format the record with font, colours, and border styles.
Conditional Formatting :- The records inside the file may be formatted primarily based on given circumstance this permits you to fast become aware of the information for faster analyses.
Applying Templates :-Templates can be created in file studio which can be implemented to the reviews created in Query Studio.
Improved Filtering :- Query Studio lets in you to create more superior filters the usage of logical operators. AND or OR.
Query Data from OLAP resources (dice) :- Now Query Studio supports in analyzing the records from multi-dimensional systems known as Cubes.
Supports Hierarchy Levels :- Since Query studio reads the statistics from Cube that is defined with hierarchy ranges it helps multi-dimensional analysis. (Drill Up, Drill Down, Drill Across).
Question fifty three. What Is Conditional Format?

Answer :

The information inside the report may be formatted based on given situation this lets in you to quickly pick out the facts for quicker analyses.

Question fifty four. Define Event Studio?

Answer :

Use the occasion studio to carry out the tasks whilst the commercial enterprise event takes place.

When an event occur people are alerted to take actions.

Question 55. Define Burst?

Answer :

To create many file effects by strolling a unmarried report as soon as.

For example: you may create a file that shows income for every worker, and run it once, sending extraordinary consequences to nearby managers by bursting on place.You set up bursting in Report Studio and enable it in the portal.

Question fifty six. What Is A Report?

Answer :

A set of data deliberately laid out to speak commercial enterprise information. Depending on the context, "record" may additionally consult with record specification or file output.

Report (more precisely, document specification) is the standard term for the gadgets created with the aid of edited by way of Query Studio, Report Studio, and Analysis Studio.

Question 57. What Is Report Specification?

Answer :

The definition of queries, activates, layouts, and patterns that make up a file. A document specification is combined with statistics by means of a run operation to create document outputs. You create document specs with the aid of the usage of Report Studio, Query Studio, Analysis Studio, or via the Software Development Kit.

Question fifty eight. Define Report Output?

Answer :

A record output combines statistics at the point in time whilst the record turned into run with a file specification. It is a report that can be displayed, printed or emailed. Cognos eight can produce report outputs in HTML, PDF, Excel, or CSV formats.

Question fifty nine. Define Content Manager?

Answer :

The Cognos eight service that manages the garage of consumer packages, which includes utility-specific protection, configuration facts, models, metrics, reviews, and file output.

Content Manager is needed to put up fashions, retrieve or shop file specifications, control scheduling statistics, and manipulate the Cognos namespace.

Question 60. What Is Data Source?

Answer :

A relational database, dimensional cube, file, or different bodily statistics store that may be accessed through Cognos 8.

Question 61. Define Data Tree?

Answer :

Within a studio, consists of items together with question subjects, question items, dimensions, levels, and participants. A facts tree is used as a palette of the to be had records that can be inserted into calculations, filters, display regions, and other authoring gestures.

Question sixty two. Define Drill Down?

Answer :

The act of navigating from one stage of data to a greater detailed degree. The levels are set by means of the shape of the records.

Question sixty three. Define Drill Up?

Answer :

The act of navigating from one degree of data to a less precise stage. The degrees are set with the aid of the structure of the facts.

Question 64. What Is Hierarchy?

Answer :

A hierarchy represents a group of dimensional members prepared right into a tree structure, with each member having one or more determine contributors and an arbitrary range of toddler individuals.

The root of a hierarchy has no figure, and leaf individuals of a hierarchy don't have any children.

Question sixty five. What Is Layout?

Answer :

In reporting, format defines the arrival of the record, including formatting, fashion, and design.

In document specifications, layout is the part of the specification that defines how the facts again by queries is presented.

Question 66. Define Level?

Answer :

A stage is a set of members that have not unusual attributes. For instance, a geographical measurement may incorporate degrees for usa, vicinity, and town. Levels are used to define the shape of hierarchies in a dimension.

Question sixty seven. What Is Member?

Answer :

A member is a completely unique object within a level. For instance, Camping Equipment and Golf Equipment are contributors of the Product Line level.

Question 68. Define Locale?

Answer :

A code this is used to set the language or dialect used for browsers, record textual content, and so on; and the nearby options, such as formats for time, date, cash, cash expressions, and time of day.

For Cognos merchandise, you can specify a locale for the product interface (product locale) and for the records inside the file (content locale).

Question sixty nine. Define Multidimensional Expression Language (mdx)?

Answer :

An abbreviation for multidimensional expression language, MDX is the multidimensional equivalent of SQL. Cognos 8 lets in file authors to kind of their queries the usage of MDX expressions in Report Studio for dimensional statistics sources.

Question 70. What Is The Use Of Repeater?

Answer :

In Report Studio, a cell box that repeats values inside itself and not using a predefined inner shape.

Question 71. Define Repeater Table?

Answer :

In Report Studio, a table-like box that repeats cells throughout and down the page for row in the associated question.

Question 72. What Is Template?

Answer :

A reusable reviews format or style that can be used to set the presentation of a query or report.

Question seventy three. Define Work Area?

Answer :

The location inside a studio that consists of the report, analysis, query or agent currently getting used

Question seventy four. What Is A Hot File?

Answer :

A separate neighborhood records desk that can be brought for your catalog or used in the record as a statistics source and as though it is a regular database desk. A Hot File may be joined both with a database table or with another Hot File itself.

Question 75. What Is Impromptu?

Answer :

Impromptu is a windows primarily based powerful interactive query and reporting tool that lets you question records and create sophisticated reports in a smooth – to- use and sophisticated computer and interface.

Question 76. What Is The Difference B/w Macro And Prompt?

Answer :

Macro is a dynamic item that's used to alternative the values at query run time.

Prompt is a file element that asks for values earlier than the document is administered.

Question 77. What Is A Cube Size?

Answer :

Cube size is not static. It may be described consistent with Project but we will create up to 2GB.

Question 78. What Is Refreshing Of Cube And How Can We Do It?

Answer :

Refreshing a cube method getting the contemporary statistics from content material store. We have an option to refresh dice.

Question 79. What Is Meant By Dash Boards/flash Cards?

Answer :

Dash Board reviews are used to create many reviews in one document.

Question 80. What Is The Usage Of Html Object In Tools Box?

Answer :

By the usage of HTML item, We can insert multimedia record into file. At the run time we will see the document multimedia record.

Question 81. How Can We Use Conditional Blocks?

Answer :

Conditional Blocks adds an empty block that you could use for conditional formatting. You can cover and display report factors.

Question 82. What Is Cube Group?

Answer :

Set of comparable cubes built by using Transformer.

Question eighty three. What Is Burst Reporting?

Answer :

Burst reporting approach sending a unmarried file to a couple of recipients the use of Cognos connection.

Question eighty four. What Is Level Span?

Answer :

Level Span is used to avoid 1:1 relationship.

Question 85. What Is Analyses Studio?

Answer :

In analyses studio customers can discover analyses and examine dimensional statistics. Use Analyses studio to examine the statistics from more than one dimensional structures called Cubes.

Question 86. What Are Report Analysis Studio Supports?

Answer :

Analysis studio supports best cross tab, charts.

Question 87. What Is Cube?

Answer :

A bodily records supply containing a multidimensional representation of records. A cube consists of facts prepared into dimensions and optimized to provide faster retrieval and navigation in reports.