Capgemini SAP MM Functional Consultant Interview Questions and Answers

OLAP in IDT and UDT and generating reports without universe

• OLAP can be used in both IDT and UDT for data analysis

• Reports can be generated without a universe using OLAP

• OLAP allows for multidimensional analysis of data

HANA, ERP, and BW are all data sources that can be used to create reports in BI.

• HANA can be used as a data source for BI reports, allowing for real-time reporting and analysis.

• ERP data can also be used to create BI reports, providing insights into business operations and performance.

• BW is a data warehousing solution that can be used to store and manage data for BI reporting.

• All three data sources can be integrated with...read more

Report customisation can be done by using tools like Crystal Reports or SSRS to modify the layout and data displayed.

• Identify the report to be customised

• Determine the changes to be made

• Use a report customisation tool like Crystal Reports or SSRS

• Modify the layout and data displayed

• Test the customised report to ensure accuracy

Report managing under CMC involves creating, scheduling, and distributing reports.

• Create reports using CMC's report creation tools

• Schedule reports to run at specific times or intervals

• Distribute reports to specific users or groups

• Monitor report usage and performance

• Customize report templates and layouts

• Examples: Sales reports, financial reports, inventory reports

BI reports have filters at both report level and query level.

• Report level filters allow users to filter data within the report itself.

• Query level filters are applied to the underlying data source before the report is generated.

• Common filters include date filters, dimension filters, and measure filters.

• Report level filters can be applied to specific visualizations or the entire report.

• Query level filters can be used to ...read more

There are multiple ways to resolve loops during universe building.

• One way is to use aggregate awareness to avoid loops.

• Another way is to use aliases to create a self-join.

• A third way is to use contexts to define the scope of the query.

• It is also important to ensure that the join paths are correct and optimized.

• Testing and debugging can help identify and resolve any remaining loops.

Yes, I am satisfied with my current salary.

• I am content with my current salary as it meets my financial needs

• I feel valued for my work and contributions at my current salary level

• I have compared my salary with industry standards and feel it is fair

The speed of the person sitting under the train is zero.

• The person sitting under the train is stationary.

• The speed of the train does not affect the speed of the person.

• The person's speed is relative to the ground, not the train.

Water does not fall from a filled glass because of surface tension and gravity.

• Surface tension of water creates a force that holds it together and prevents it from overflowing.

• Gravity pulls the water downwards, keeping it inside the glass.

• The shape of the glass also plays a role in containing the water.

• If the glass is filled beyond its capacity, the surface tension may break and water will overflow.

Reference architecture of insurance is a blueprint for designing and implementing insurance systems.

• Reference architecture provides a common language and framework for insurance companies to design and implement their systems.

• It includes components such as data models, business processes, and technology infrastructure.

• Examples of reference architectures in insurance include ACORD and LOMA.

• Reference architecture helps e...read more