100) What is a Report Studio?
Using Report Studio we can create more advanced professional Business Reports.
101) What is burst?
To create many report results by running
a single report once. For example, you can create a report that shows
sales for each employee, and run it once, sending different results to
regional managers by bursting on region.
You set up bursting in Report Studio and enable it in the portal.
102) Define calculated member?
A member of a dimension whose measure values are not stored but are calculated at run time using an expression.
103) What is cardinality?
For OLAP data sources, cardinality is
the number of members in a hierarchy. The cardinality property for a
hierarchy is used to assign solve orders to expressions.
For relational data sources, cardinality
indicates the nature of the relationship between two query subjects,
query items, or other model objects.
104) Define report specification?
An XML representation of the queries,
prompts, layouts, and styles in a report. You create report
specifications by using Report Studio or Query Studio, or by writing
your own report specifications in XML.
105) What is report view?
A reference to another report that has its own properties, such as prompt values, schedules, and results.
You use report views to share a report specification instead of making copies of it.
106) What is report item?
A query item that is added to a report is known as a report item.
Report items appear as columns in list
reports, and as rows and columns in crosstab reports. In charts, report
items appear as data markers and axis labels.
107) What is work area?
The area within a studio that contains the report, analysis, query or agent currently being used.
108) What is Simple List Report?
The data is displayed in a series of columns (Tabular format).
109) How to set Page Breaks?
To set the page breaks in the report needs to be designed with either Group or Section.
Each Group or section will be displayed in a separate page.
110) What is the procedure for Page Breaks?
Select the Grouped Report Item, from the changed layout menu click on set page breaks.
111) Define Sections:
Like group a section also eliminates the
duplicates and display the report item as a separate block and
separated from rest of other report items.
112) How to eliminate duplicates?
The duplicates can be eliminated by creating the Groups
113) What is a prompt?
A prompt is an end users object which
allows you to select the values or enter the values to restrict the data
displayed in the report.
A report element that asks for parameter values before the report is run.
A Prompt is known as dynamic filter.
Prompt can be created using Parameters enclosed between ? marks.
Ex :- ?prompt?
114) What are the types of Prompts?
The following are the types of prompts:
1. Text box Prompt
2. Value Prompt
3. Select and Search Prompt
4. Date Prompt
5. Time Prompt
6. Date and time Prompt.
115) How many ways are there to create prompt?
To create a prompt you can:
Ø Use the Build prompt page tool.
Ø Build your own prompt and prompt page.
Ø Create a prompt directly in a report page.
116) What is a Non-reusable prompt?
The prompts that are created in the report environment are called as Non-reusable prompts.
117) What is a cascading prompt?
A prompt that uses values from a previous prompt to filter the values in the current prompt or Pick list.
118) How many ways we can create Cascading Prompt?
A Cascading Prompt can be developed in a two different ways.
1. Single select and auto submit cascading prompt.
2. Multi select and Re-prompt button cascading prompt.
119) What kind of relationship is required for cascading prompt?
To develop the cascading prompt the relationship between the dimensional query Items should be 1 to many (1: M).
120) What is a filter?
A filter is a condition, which restricts the amount of data displayed in the report.
121) What is Detailed Filter?
If the filter is applied before aggregation known as aggregated records are filtered. (Detailed Records are filtered)
122) What is Summary Filter?
If the filter applied after aggregation than aggregated records are filtered.
123) What is Group Filter?
A filter which is applied to the group is known as Group Filter.
124) Define Sorting:
Sorts the data in the following 2 directions
1. Ascending
2. Descending
The default sort is don’t sort.
125) Define the Custom Group:
A custom group allows you to compare one element in the attribute with remaining all elements with in the same attribute.
It is defined for comparative analyses.
It allows comparing one element with remaining all.
126) How the pages of a single report delivered to the browser?
Based on the order of the pages add to the report.
127) In How many file formats we can export Report Data.
The data can be exported into the following file formats
1. PDF format (Portable Document Format)
2. CSV Format (Comma Separated Value)
3. XML Format
128) Use of Header and Footer in Reports?
Headers and Footers allow you to format the report and present the data in a readable format.
129) Can you convert list to Cross tab report?
Yes, to gain a different perspective on your data, you can convert a list report into a cross tab report.
Note: To convert list to cross tab report minimum 3 report items required.
130) Can you converting to repeater?
Only a list report can be converted into a repeater. You cannot convert a cross tab or chart into a repeater.
131) What is a Calculation?
According to the report requirement a
calculation needs to be done using an object known as calculation object
this process is known as OLAP Scrubbing.
132) What are the types of Calculations?
There are three types of Calculations:-
1. Detail:- Calculation is performed for non-aggregated (Detail) records
2. Group: – Calculation is performed for aggregated records.
3. Layout Calculation: – Calculation is performed to develop customized report titles, page No, etc…
133) To get the possible outcomes what types of variables you use?
Boolean variable: If there are only two possible outcomes, where the value will be YES or NO.
String variable: If there is more than one outcome, based on string values you will specify.
Language variable: Language variable when the values are different languages.
134) What is Master detail relationship?
A Master detail relationship allows you to merge a Master query and Detail query.
To link the Master query and the Detailed query there should be a common column between the query.
A Master detail report provides navigation form summary to detail.
135) What is Drill Through?
A Drill Through allows you to navigate the information from summery to detail.
A Drill Through id developed with two reports
1. Parent Report which contains Summary Data.
2. Child Report which contains Detailed Data.
Their should be a common column between the two reports.
136) Define Cross Tab Report:
Design a Cross Tab Report for comparative analysis. Cross tab report is created with 3 drop zones.
1. Row
2. Column
3. Measure
137) What all the types of Cross Tab layouts Cognos Report Net supports?
Cognos Report net supports only Basic and Nested Cross Tab layouts.
138) Define a chart:
A Chart is a graphical presentation of business data.
A chart Report is designed for comparative Analysis.
139) What are the different types of charts?
1. Column chart
2. Bar Chart
3. Pie Chart
4. Line Chart
5. Area Chart
6. Point Chart
7. Radar Chart
140) Define Collapse Group:
It will suppress (hide) the details of a grouped report.
141) Define Expand Group:
It restores the details. A report needs to be designed with group.
No comments:
Post a Comment