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.

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.

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 limit the data retrieved from the database.

• Examples of fil...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.

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

Smart manufacturing enables efficient and flexible production through the use of advanced technologies.

• Smart manufacturing utilizes technologies such as IoT, AI, and robotics to optimize production processes.

• Case-based analysis of industry deep dive of IR 4.0 involves analyzing real-world examples of smart manufacturing implementation.

• Examples of smart manufacturing use cases include predictive maintenance, real-time monitoring, and supply chain optimization.

• Smart manufacturi...read more

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

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

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 BI to provide a comprehensive view of business data.

• Examp...read more

Delete removes specific rows while truncate removes all rows from a table.

• Delete is a DML operation while truncate is a DDL operation.

• Delete can be rolled back while truncate cannot be rolled back.

• Delete operation is slower than truncate operation.

• Delete operation frees up space in the transaction log while truncate does not.

• Example: DELETE FROM table_name WHERE condition; TRUNCATE TABLE table_name;

Business requirements define the overall goals and objectives of a project, while functional requirements specify the specific features and functionalities that the system must have to meet those goals.

• Business requirements focus on the 'what' and 'why' of a project, while functional requirements focus on the 'how'.

• Business requirements are high-level and non-technical, while functional requirements are detailed and technical.

• Business requirements are usually documented in a ...read more

Value types store data directly, while reference types store a reference to the data's memory location.

• Value types are stored on the stack, while reference types are stored on the heap.

• Value types include simple types like int, float, and struct, while reference types include classes, interfaces, and arrays.

• When passing a value type to a method, a copy of the data is passed, while passing a reference type passes a reference to the data.

• Changing a value type in one place does ...read more

Truncate and Delete are SQL commands used to remove data from a table.

• Truncate is a DDL (Data Definition Language) command used to remove all data from a table.

• Delete is a DML (Data Manipulation Language) command used to remove specific rows from a table.

• Truncate is faster than Delete as it does not log individual row deletions.

• Truncate cannot be rolled back, while Delete can be rolled back using a transaction.

• Truncate resets the identity of the table, while Delete does not.