HANA Studio Filter table based on current client in Calculated Column

[gborcho]

Hi All,

I have an issue for which I am trying to find a solution.

I have a table which I'd like to filter 'MANDT' field to the Client currently connected to and only it.

is there a way to do it ? My thoughts are using some table for that but I am not sure.

Any help will be appreciated 🙂

Thanks

[eason_chen · Accepted solution]

Hi,

You may refer to following KBA.
2463361 - Contents of a basis table are not visible in a Calculation View
2393833 - HANA calculation view’s data not available in BW

After you change view properties "Default Client" from "Cross Client" to "Session Client", data would be filtered based on MANDT. You also need to maintain "Session Client" for your DB user.

Best Regards,
Eason Chen

[gborcho · Accepted solution]

Thank You Eason,

I will try that and report back.

What do you mean by maintain "Session Client" for DB user?