how to remove SAP Characteristic(table) names while loading into Qlikview

[#1]

Hello Community,

in one of my application, I am loading data from SAP BW using SAPOLAPconncetor,

its working fine and data is loaded into QVD from SAP DB.Next If I load data from QVD to Qlikview desktop data is loaded successfully but the data is stored with table name with field data value like below format,

my issue is If we choose any field in List Box or any QV object data is stored with table name. but I need data alone to present in qlikview objects.

Country List box

=================

COUNTRY LISTBOX
[Tablename].Field vlue

my issue is If we choose any field in List Box or any QV object data is stored with table name.

any suggestions...???anybody has,had the same issue..???

Thanks

[Anonymous]

In order to get only the Field code you should use the "2" property in the OLAP connector wizard.

For example, let's take field 0CUSTOMER:

you script should include the following code:

Dimensions (

[0CUSTOMER] ([20CUSTOMER])),

Thanks

Yaniv