Found 4 Questions for SAP BpC

M_Expensive statement in SAP HANA

SAP Developer
Updated on 12-Mar-2020 10:36:10
This can be checked using system view M_EXPENSIVE_STATEMENTS.SELECT * FROM M_EXPENSIVE_STATEMENTSIn SAP HANA, the M_EXPENSIVE_STATEMENTS view provides convenient access to the most expensive statements that were executed on the system. A statement is considered being expensive if its runtime exceeds a particular threshold. Please note that the expensive statements trace needs to be activated first in the Performance → Expensive Statements Trace screen in the SAP HANA studio. Click Configure the Trace Configuration dialog

Limitations of using SAP HANA 1.0

Anil SAP Gupta
Updated on 30-Jul-2019 22:30:22
SAP HANA 1.0 can replicate data only from few of data sources and only in few formats using Sybase Replication. You can perform batch loading using SAP Data Services and it is optimized only for Business Object 4.0 for reporting.

Multidimensional Expression and its use in SAP BPC

Samual Sam
Updated on 12-Mar-2020 12:36:48
MDX is a query language developed by Microsoft to query OLAP cubes. In OLAP cubes, data is structured as multidimensional. You have a fact table in middle and dimension tables surrounding fact tables. MDX is used to query STAR schema cubes like this and generate results for different purposes.MDX query language is bit similar to SQL with few fundamental differences like:In MDX queries, it can have 0, 1, 2, 3, 4…up to 128 query axes in the SELECT statement. Each axis behaves in exactly the same way, unlike SQL where there are significant differences between how the rows and the ... Read More

Multiple ALV grids on a single screen in SAP ABAP

Updated on 30-Jul-2019 22:30:20
It is not possible to resize or place the grid at the particular position using function modules as ALVs are always displayed in the Fullscreen by using function modules.One of the method this can be done is that you create a screen using custom container and then use the class CL_GUI_ALV_GRID to attach the ALV grids to this container at desired positions.