Adding Multiple Views in SAP HANA Analytic Privilege

SAP ABAP Expert
Updated on 12-Mar-2020 08:16:49

380 Views

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.

New Versioning Scheme in Java 9

raja
Updated on 12-Mar-2020 08:15:26

633 Views

Since Java 9, versioning can be consistent with semantic versioning. The version number can be a non-empty sequence of strings separated by dots. It contains three major parts: major version number, minor version number, and security. The new versioning scheme has documented in Runtime. Version class and version information can be accessed from it.The version numbers have the below format:$MAJOR.$MINOR.$SECURITY(.$otherpart)?$MAJOR is the major version number and incremented when a major version has released that typically changes the platform specification. For JDK 9, this value is 9.$MINOR is the minor version number and incremented for releases that contain bug fixes and enhancements to ... Read More

Key Characteristics of Using Analytic Privilege in SAP HANA Modeling

SAP Developer
Updated on 12-Mar-2020 08:15:08

186 Views

Analytic Privilege is created inside packages under Content tab.Analytic Privileges are only applied to attributes in an Information View. We cannot add measures to restrict access to Analytic privileges.Analytic Privileges are used to control read access to SAP HANA Information views. You can also hide an information from the specific time period.

Consuming Attribute Analytic View in a Calculation View in SAP HANA

John SAP
Updated on 12-Mar-2020 08:14:26

302 Views

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.

Different Projection Options in Calculation View in SAP HANA

SAP Expert
Updated on 12-Mar-2020 08:13:11

603 Views

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:

Hiding Specific Data in HANA Modeling View

John SAP
Updated on 12-Mar-2020 08:11:52

200 Views

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.

Different Nodes Option in a Calculation View in SAP HANA

SAP ABAP Expert
Updated on 12-Mar-2020 08:10:53

993 Views

In SAP HANA Calculation View, following nodes are available −JoinUnionProjectionAggregationRank

Use PowerShell Break with the Label

Chirag Nagrekar
Updated on 12-Mar-2020 07:30:16

874 Views

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.

Use PowerShell Break Statement with Switch Command

Chirag Nagrekar
Updated on 12-Mar-2020 07:28:38

434 Views

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.

Use PowerShell Break Statement in Foreach Loop

Chirag Nagrekar
Updated on 12-Mar-2020 07:27:28

652 Views

You can use the PowerShell Break statement with the foreach loop as mentioned below.Exampleforeach($obj in (Get-ChildItem D:\Temp)){    Write-Output $obj    if($obj.Name -eq "cars.xml"){Break} }OutputDirectory: D:\Temp Mode LastWriteTime  Length Name ---- -------------  ------ ---- d-----   13-12-2019 09:52GPO_backup d-----   24-11-2018 11:31 LGPO -a----   27-01-2020 22:21   13962 Alias1 -a----   26-01-2020 19:20   13818 aliases.txt -a----   07-05-2018 23:00301 cars.xmlIn the above example, when the file name matches the cars.xml then the loop gets terminated.

Advertisements