Anil SAP Gupta

Anil SAP Gupta

97 Articles Published

Articles by Anil SAP Gupta

Page 10 of 10

Can I filter a column in PN in SAP HANA with REGEX?

Anil SAP Gupta
Anil SAP Gupta
Updated on 30-Jul-2019 405 Views

Projection Node is basically a graphical Calculation view. SAP HANA does not allow usage of regular expression in a graphical calculation view for filtering out data.So if you still need to use graphical calculation view (Projection Node), then you need to filter out the data either by using a table function or equivalent.

Read More

Creating communication between Java application and SAP

Anil SAP Gupta
Anil SAP Gupta
Updated on 30-Jul-2019 245 Views

Note that com.sap.conn.jco.JCo can be used as an alternative of com.sap.mw.jco and exists in sapjco.jar. Classes in sapjco.jar files is also different. You can check this link for more details:com.sap.conn.jco.JCo 

Read More

Is Partitioning required in SAP HANA tables for one million records?

Anil SAP Gupta
Anil SAP Gupta
Updated on 30-Jul-2019 252 Views

I think you are over thinking on a potential issue. The size of tables as you said will be rarely over one million records which does not qualify it to be considered a big table. In my application we have tables which are much bigger than that but still work pretty well over time. Also, as you said that data is mainly categorized on a daily basis so, theoretically it makes sense to partition tables on dates.  It should improve the performance to some extent. But it can also lead to good number of partitions which can backfire too from ...

Read More

Installing SAPUI5 on local machine using XAMPP

Anil SAP Gupta
Anil SAP Gupta
Updated on 30-Jul-2019 293 Views

You can refer this link for setting up basic development environment for SAP UI5:Basic Development environment for SAPUI5To setup local Development with Eclipse, you should refer this:UI5 with Eclipse

Read More

Reading latest measurement point in SAP RFC

Anil SAP Gupta
Anil SAP Gupta
Updated on 30-Jul-2019 728 Views

There is a Function Module: MEASUREM_DOCUM_RFC_SINGLE_002 that you can use to read documents if keys are known. When there is no RFC module to get a list of $foo according to a set of selection criteria, it is possible to use RFC_READ_TABLE to get the keys from db directly.Function Module MEASUREM_DOCUM_RFC_SINGLE_002: RFC Measurement document: Individual processing, Change/Display or ReadUseWith use of this RFC, following remote calls can be used:Remote dialog (WITH_DIALOG_SCREEN = 'X')Remote dialog in display mode (EDIT_MODE = ' ')Remote dialog in change mode (EDIT_MODE = 'X')Remote reading of measurement document data (WITH_DIALOG_SCREEN = ' ')NotesApart from when an ...

Read More

Creating Attribute and Analytic view as persistent model in SAP HANA

Anil SAP Gupta
Anil SAP Gupta
Updated on 30-Jul-2019 219 Views

This is possible as all views can be created as persistent in SAP HANA. You need to get XMS representation creating attributeview, .analyticview, .calculationview file and activate it.In your case I think you need to check details of your Analytic view and if there is some path that you need to modify.

Read More

Fetching data from transparent tables in SAP system

SAP
Anil SAP Gupta
Anil SAP Gupta
Updated on 30-Jul-2019 592 Views

Try checking length of variable if it is meeting minimum variable length required, if not append zeroes in end.

Read More
Showing 91–97 of 97 articles
« Prev 1 6 7 8 9 10 Next »
Advertisements