Attribute view vs calculation view of type dimension

[Former Member]

Hi,

I have created one simple attribute view with joining tables KNA1 & ADRC. It is working fine and giving me correct data. With same tables when im creating a calculation view of type dimension im expecting same result but its not giving me any data. could anybody guide me any specific setting i need to make in calculation view to achieve this.

Rgds

[former_member199842 · Accepted solution]

Hi,

What is the HANA SP version you are using ?

Thanks and Regards,

Poorna

[Former Member · Accepted solution]

it shows version as 1.00.097.03.1443520413 so i guess its SPS9.

[anindya_bose · Accepted solution]

It is SPS9..  Can you paste screenshot of view properties ? and also the model

Regards

Anindya

[Former Member · Accepted solution]

Here is a scr shot of view properties. please check.

[anindya_bose · Accepted solution]

can you make Analytic Privilege field blank and check ? 

Regards

Anindya

[mangesh_kothuri · Accepted solution]

select "CrossClient" from dropdown ..save and activate.

[Former Member · Accepted solution]

That seems work. could you please let me know how choosing 'cross client' brought the result even though i have single client in my system.

rgds

[anindya_bose · Accepted solution]

Hi Sudhanshu

Earlier you had setting of "Session Client" , that means you were only seeing data for a client ( MANDT) which is set in your user profile in HANA.

It seems, that client did not have data .

Now, you set it as "cross client", so basically you see data for all clients .  In production, if you have only one client in source system ( or you replicate only client's data ) , it would make same with both the settings.

  explained it very well here . What is session client and cross client ? | SCN

Regards

Anindya

[Former Member · Accepted solution]

that's what my question is. i have only one client and it has all the data so why should i set it cross client.

[anindya_bose · Accepted solution]

What is set in your Session Client ?  Security --->User --->Your user id

In my case, it is set as blank but I can see data with settings as "Session client" . However , I am on SPS 10 .

What do you see here ?

1. Window Preferences SAP HANA Modeler Default Model Parameters . Default Client ?

[mangesh_kothuri · Accepted solution]

Sudhanshu, please mark this thread as  answered if your original issue is resolved.

[Former Member]

Hi Sudhanshu, Can you check if the Join type and cardinality are the same in both views?

Thanks!

[Former Member]

Join type shouldn't be an issue as data in both table is correct. im joining tables with address number field and i can see common address numbers. Does cardinality really matter here?

[Former Member]

Hi Rgds,

It should work fine, can you check your 'Default Client' in view properties?

Regards,

Shireesha

[Former Member]

its session client