Not able to see the text for Units

[Former Member]

Hello all,

I am new to hana i need help in one our requirements.

The requirement is as below:

I want to show quantity and units in the reports.

For this i have created an attribute view with T006,T006T and i have joind DIMID in both the tables and given join as text join and language as spras.

for out put i have selected MSEHI(Unit of measurement),DimId from T006 table and TXDIM(Dimension text) from the T006T table.

But when ran the view and when use data preview it is showing blanks.

But if i executed the same with the query i am getting the output, PFB query

select "HANA_POC"."T006"."DIMID","HANA_POC"."T006"."MSEHI","HANA_POC"."T006T"."TXDIM"

from "HANA_POC"."T006","HANA_POC"."T006T"

where "HANA_POC"."T006"."DIMID" = "HANA_POC"."T006T"."DIMID" and "HANA_POC"."T006T"."SPRAS"='E';

Please correct me what i am doing wrong in the GUI..

Thanks,

Mahesh

[lucas_oliveira]

Hi Mahesh,

Text join will use the language set on parameter LANGUAGE_SAP your DB connection. So I'm guessing your connection was set in another language. Check it with:

select * from m_session_context where connection_id = current_connection

If you generate a Planviz execution you'll be also able to see how's that being filtered (check for the basic plan operators on your T006T table.

So to check everything in English, just make sure your connection in HANA studio is set to English (right click -> properties -> additional properties -> Locale).

Regards,

Lucas de Oliveira