- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
SAP ABAP Expert has Published 141 Articles
SAP ABAP Expert
213 Views
When you have to run an OLAP query that perform sum of Sales in table with where clause in Country=’US’.Select Sum(Sales) from FCT_SALES where Country=’US’; It storage type is a column based storage in memory cells all the values for Sales will come together in database and when an aggregation ‘Sum’ ... Read More
SAP ABAP Expert
199 Views
In SAP HANA, Data modeling can only be performed on Column store tables. You can’t select Row store tables while create data modeling views on top of HANA database. In below pic, you can see it only shows all column store tables to add in Data Foundation layer of a ... Read More
SAP ABAP Expert
111 Views
SAP HANA studio client is available to run on variety of platforms. Following Operating systems can be used to run HANA Studio client tool:Microsoft Windows x32 & x64 versions with availability for −Windows XPWindows VistaWindows 7Windows 8SUSE Linux Enterprise Server SLES 11: x86 64-bit versionRed Hat Enterprise Linux (RHEL) 6.5Mac ... Read More
SAP ABAP Expert
2K+ Views
You can achieve this by running the below SQL query −>CREATE USER TEST password “Welcome1$$” VALID FROM ‘2017-12-05 11:00:00’ UNTIL ‘2018-12-08 12:00:00’; CREATE USER DUMMY password “Welcome1$$” VALID FROM NOW UNTIL FOREVER;Note that password passed in this SQL should meet password policy of SAP HANA system otherwise user creation ... Read More
SAP ABAP Expert
613 Views
Parameter password_expire_warning_timeDefault Value 14 (days)Parameter definitionNotification is transmitted via the database client (ODBC or JDBC) and it is up to the client application to provide this information to the user.If you enter the value 0, the user does not receive notification that his or her password is due to expire.The ... Read More
SAP ABAP Expert
192 Views
SAP HANA Cockpit with Fiori-based Launchpad shows the content in the form of tiles arranged in groups. Using these tiles, you can access individual applications and can also access app-specific data for immediate review.You can also perform a drill on these tiles to see the detailed information about specific applications. ... Read More
SAP ABAP Expert
534 Views
A view in a database is defined as Virtual table which derives its data from one or more columns of one table or multiple tables. A view can be created using tables of one or more database and is stored in database where it is created.You can find views in ... Read More
To Continue Learning Please Login
Login with Google