Found 6 Questions for SAP BEX

Using different Engine types in SAP HANA

Anil SAP Gupta
Updated on 30-Jul-2019 22:30:21
It will use both OLAP and Join engine. The join between the FACT and DIM will be executed in the OLAP engine and joins inside the attribute views will be executed in the JOIN engine so both the engines will be used.

How the Table statement works in ABAP

Syed Javed
Updated on 30-Jul-2019 22:30:22
With table statement, you are able to get a single line of data corresponding to the dictionary structure you specify. The fields of structure can be used as select options and the structure can be passed as variable in the program.

Open a Workbook require loading SAPBEX.xla file

Amit Sharma
Updated on 14-Feb-2020 10:28:54
Copy the below code in PERSONAL.XLSM module of your workbook and then refresh −Private WithEvents App As Application Private Sub Workbook_Open()    Set App = Application End Sub Try adding below code, in your module: Private Sub App_WorkbookOpen(ByVal Wb As Workbook)    MsgBox "New Workbook: " & Wb.Name End Sub

Copying ALV layout from one client to another in SAP if they are not user specific

Ramu Prasad
Updated on 30-Jul-2019 22:30:20
You can transport your ALV layouts to other system if they are not user specific. This can be performed in Layout Administration by raising a customizing request.Navigate to this path for Layout Administration:Main Menu -> Settings -> Layout -> Administration

Adding a text plus and text written from a parameter type C in ABAP

Updated on 10-Dec-2019 08:38:36
This can be achieved by using String Expressions or by using CONCATENATE keyword. With the use of “Concatenate” operator && you can do this.To use String Expressions, you should check online documentation and sample programs by using T-code: ABAPDOCU as shown above.You can also refer to below link for ABAP documentation:

Determining values of parameters of given type on a given selection screen in SAP

Updated on 13-Feb-2020 12:42:12
The function module RS_SELSCREEN_INFO will provide you with the list of parameters and selection options once the report name is input. You can see full details about this FM by entering the name RS_SELSCREEN_INFO into the relevant SAP T-code like SE37 or SE80You can call this FM RS_SELSCREEN_INFO as below −CALL FUNCTION 'RS_SELSCREEN_INFO' "    EXPORTING       report =                    " rsvar-report Report Name    TABLES       field_info =                " scr_info     Information about type, reference field, etc.    EXCEPTIONS ... Read More