Explore topic-wise InterviewSolutions in .

Design a Cross Tab Report for COMPARATIVE ANALYSIS. Cross tab report is created with 3 drop zones.

1. ROW
2. COLUMN
3. Measure

Design a Cross Tab Report for comparative analysis. Cross tab report is created with 3 drop zones.

A Drill Through allows you to NAVIGATE the information from SUMMARY 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.

A Drill Through allows you to navigate the information from summary to detail.

A Drill Through id developed with two reports

Their should be a common column between the two reports.

• 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.

• 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.

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...

There are three types of Calculations:-

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.

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.

Only a LIST report can be CONVERTED into a repeater. You cannot CONVERT a cross tab or CHART into a repeater.

Only a list report can be converted into a repeater. You cannot convert a cross tab or chart into a repeater.

YES, to gain a different perspective on your data, you can CONVERT a list REPORT into a cross TAB report.

To convert list to cross tab report minimum 3 report items required.

Yes, to gain a different perspective on your data, you can convert a list report into a cross tab report.

To convert list to cross tab report minimum 3 report items required.

HEADERS and FOOTERS allow you to FORMAT the report and PRESENT the DATA in a readable format.

Headers and Footers allow you to format the report and present the data in a readable format.

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

The data can be exported into the following file formats:

BASED on the ORDER of the PAGES ADD to the REPORT.

Based on the order of the pages add to the report.

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 analysis.

It allows comparing one element with remaining all.

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 analysis.

It allows comparing one element with remaining all.

Sorts the data in the FOLLOWING 2 directions:

• Ascending
• Descending

The default SORT is don’t sort.

Sorts the data in the following 2 directions:

The default sort is don’t sort.

A FILTER which is APPLIED to the GROUP is KNOWN as Group Filter.

A filter which is applied to the group is known as Group Filter.

If the filter applied after AGGREGATION than AGGREGATED RECORDS are filtered.

If the filter applied after aggregation than aggregated records are filtered.

If the filter is APPLIED before AGGREGATION KNOWN as AGGREGATED records are FILTERED. (Detailed Records are filtered)

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

A FILTER is a CONDITION, which RESTRICTS the amount of data displayed in the REPORT.

A filter is a condition, which restricts the amount of data displayed in the report.

To DEVELOP the CASCADING PROMPT the RELATIONSHIP between the dimensional query ITEMS should be 1 to many (1: M).

To develop the cascading prompt the relationship between the dimensional query Items should be 1 to many (1: M).

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.

A Cascading Prompt can be developed in a two different ways:

A PROMPT that USES values from a previous prompt to FILTER the values in the CURRENT prompt or Pick list.

A prompt that uses values from a previous prompt to filter the values in the current prompt or Pick list.

The PROMPTS that are CREATED in the REPORT ENVIRONMENT are CALLED as Non-reusable prompts.

The prompts that are created in the report environment are called as Non-reusable prompts.

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.

To create a prompt you can:

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.

The following are the types of prompts:

The DUPLICATES can be ELIMINATED by CREATING the GROUPS.

The duplicates can be eliminated by creating the Groups.

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.

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.

SELECT the GROUPED Report ITEM, from the changed layout menu CLICK on SET page breaks.

Select the Grouped Report Item, from the changed layout menu click on 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.

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.

The DATA is displayed in a series of COLUMNS (TABULAR format).

The data is displayed in a series of columns (Tabular format).

The AREA WITHIN a STUDIO that contains the REPORT, analysis, query or agent currently being USED.

The area within a studio that contains the report, analysis, query or agent currently being used.

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.

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.

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.

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.

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.

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.

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.

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.

A member of a dimension WHOSE measure VALUES are not STORED but are calculated at run TIME using an EXPRESSION.

A member of a dimension whose measure values are not stored but are calculated at run time using an expression.

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.

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.

Using REPORT STUDIO we can CREATE more ADVANCED professional Business Reports.

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