Column Names in BI query for output Port

[Former Member]

Hii Folks,

I have created a iView in Visual composer using a Bi query, that has a output to a table view.

But the Table data is displayed with Column names like F_Techinalname_Lablename

For example i have a field

techinal name : Z_MONPERIOD

Label : Period

but in Output its displays as F_Z_MONPERIOD_Period and in Define/Execute query i m not able to change this...

y is this so ... is there any notes.. to b applied ?

Thanks

Sonal.....

P.S. : i have already checkd note 961375 and 956694 as the field name doesnt contain any non-alphanumeric charaters

Edited by: Sonal Patel on May 4, 2009 9:06 AM

[Former Member · Accepted solution]

Hi Sonal,

The 'F' may be the prefix of the query. You can change the label of a field in a table. To do this, open the 'Layout' tab and select the column of the table and open its properties by using right click option. Now set the 'Label' of the field in 'Display' tab.

Regards

Basheer

[Former Member]

Hi

Have you tried 'Key' or 'Ext_Key' for this same object? Try with these options in table & changing the column heading. & then check what it is the heading of the column after deploying.

Regards

Sandeep

[Former Member]

HI Sonal

Is it working? or still there is any error?

Regards

Sandeep

[Former Member]

Hii all

thanks for ur replies...

i have got the solution...

Thanks again

Sonal...