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
Maximum 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 MoreHow to use PowerShell Break statement with the Switch command?
In Switch command, when the single value passed and if it matches the condition then the loop gets automatically exited but when there are multiple values passed and if the value matches the first condition and if you want to terminate the loop then you can use the Break statement. An example is given below.ExampleSwitch (3,5){ 1 {"This is One"} 2 {"This is Two"} 3 {"This is Three"; Break} 4 {"This is Four"} 5 {"This is Five"; Break} }OutputThis is ThreeYou can notice in the above output that second parameter 5 won’t be executed because the 3 has already been executed with the break statement.
Read More