on 03-22-2016 5:26 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I set the session client, but there is no any usage when I try to select data via JDBC. All client data are exist.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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. |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This message was moderated.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.