What is session client and cross client ?

[Former Member]

Hi

Can any one please make me understand what is session client and cross client in view properties TAB while creating the View on hana tables. Would be thankful if some one explains with a real time example.

Thanks.

Tej

[muthuram_shanmugavel2 · Accepted solution]

Hi Ravi Theja,

Based on HANA Column Views - client settings, Data Preview would show the output.

Table should have "MANDT" column as the client settings applied by this column.

Assume Table will have 3 columns MANDT, ID and Value and It have the following Entries.

Attribute View is created on top of this Table.

Attribute View Client Settings:  Session Client

User 1 has Session Client Value as 100 and User 2 has Session Client Value as 800.

If User 1 see the Data Preview of Attribute View  --> can see only one record ID=1

If User 2 see the Data Preview of Attribute View  --> can see only one record ID=3

Attribute View Client Settings:  Cross Client

User 1 has Session Client Value as 100 and User 2 has Session Client Value as 800.

If User 1 see the Data Preview of Attribute View  --> can see all three records (ID=1, 2, 3)

If User 2 see the Data Preview of Attribute View  --> can see all three records (ID=1, 2, 3)

Attribute View Client Settings:  Fixed (500)

User 1 has Session Client Value as 100 and User 2 has Session Client Value as 800.

If User 1 see the Data Preview of Attribute View  --> can see only one record ID=2

If User 2 see the Data Preview of Attribute View  --> can see only one record ID=2

------------------------------------------------------------------------------------------------------------------------------------

* In Only Session Client Setting, Data Preview depends on User Settings and show the data.

** In Cross Client and Fixed Settings, It would follow the View settings show the data

I hope this answer would make you better understanding on this client settings.

Regards,

Muthuram

[changlin_ke]

I set the session client, but there is no any usage when I try to select data via JDBC. All client data are exist.

[former_member771715]

This is a helpful explanation - thank you. Although, for the new users in Eclipse this is not a straight forward to find why the data flow doesn't seem to work. This appears to be a user specific setting which got to be changed manually (cross client vs. sessions client vs. fixed client) by system administrator.

Anyways, it would be great to tag this post in the forum respectively ("Eclipse data flow issue", "CV not working despite objects activation", etc.).

[former_member184088]

Hello Ravi,

Default Client Value	Description
Session Client	If you use session client as the default client value, then at run time, modeler filters the table data according to the value you specify as the session client in the user profile.
Cross Client	If you use cross client as the default client value, then modeler does not filter the table data against any client and you see values relevant to all clients.
Fixed Client	If you want to use a fixed client value, for example, 001, then modeler the table data for this client value.

[anindyaSAP]

This message was moderated.