Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles on Trending Technologies
Technical articles with clear explanations and examples
What is Common Locale Data Repository (CLDR) in Java 9?
Internationalization enhancements for Java 9 include enabling of CLDR Locale Data by Default.There are four distinct sources for locale data identified by using the below keywords:CLDR: The locale data provided by a Unicode Common Locale Data Repository (CLDR) project.HOST: The current user’s customization of an underlying operating system’s settings. Depending on the operating system, formats like date, time, number, and currency can be supported.SPI: The locale-sensitive services implemented in installed SPI providers.COMPAT (JRE): The locale data that is compatible with releases prior to Java 9. The JRE can still be used as a value but deprecated, and removed in the ...
Read MoreMaximum Table name length in SAP HANA
Maximum table name length supported in SAP HANA is 127 characters.
Read MoreMaximum table count in a schema in SAP HANA
In SAP HANA, a maximum number of tables in a schema are 131072. To create a table, you have to right click on Schema name → New Table
Read MoreUsing an Analytic Privilege for specific time in SAP HANA
Yes, when an Analytic Privilege is defined you have an option of using it for a specific time period. You have an option of defining Privilege validity where you can pass validity details.You can also opt for SQL Editor or Dynamic where you can pass different validity conditions. When you use SQL option you can pass a SQL query and it will be set as per SQL queryFor Dynamic option, you can pass Stored Procedure to define validity.
Read MoreAdding multiple views in SAP HANA Analytic Privilege
Yes, you can define Analytic Privilege for multiple views in a single object. When you add multiple HANA views, you can find all Attributes: Select attributes to assign analytic privileges.
Read MoreConsuming Attribute/Analytic view in a Calculation view in SAP HANA
You can use Calculation View without Star Join to consume Attribute and Analytic view in SAP HANA. To use these views, you can add Projection node and add the views to the projections.In this, you can see how to create a Calculation view without Star Join. To add Project node, you can simply drag it from the right side.
Read MoreUsing different Projection options in Calculation view in SAP HANA
When you set data category as CUBE, the default node is aggregation. When you set data category as Dimension, default node is Projection.You can change the Default node by selecting Star Join checkbox.When you finish selection for data category, you get a default node under Scenario pane. Check the below snapshot:
Read MoreHiding specific data in HANA Modeling View
Analytic Privileges are used to limit access to HANA Information views. You can assign different types of right to different users on a different component of a View in Analytic Privileges.When it is required that data in the same view should not be accessible to other users who do not have any relevant requirement for that data. This can be performed using Analytic Privileges in HANA.
Read MoreDifferent Nodes option in a Calculation view in SAP HANA
In SAP HANA Calculation View, following nodes are available −JoinUnionProjectionAggregationRank
Read MoreHow to use PowerShell Break with the Label.
When the break statement is mentioned with the Label, PowerShell exits to the label instead of exiting the current loop.Example$i = 1 while ($i -lt 10) { Write-Output "i = $i" if($i -eq 5){ Write-Output "Break statement executed" Break :mylable } $i++ } Write-Output "Entering to another loop" $j = 1 :mylable while($j -lt 3){ Write-Output "j = $j" $j++ }Outputi = 1 i = 2 i = 3 i = 4 i = 5 Break statement executed Entering to another loop j = 1 j = 2As you can see in the above example when the value of 5 executed, the block containing label (mylable) is also executed and execution moves to another loop.
Read More