Removing description "Table" in Bex analyser

[former_member219643]

Hi all,

I have a specific requirement in Bex report.I executed the query through analyzer.I can see the report having rows and columns but at the top I'm seeing the description as "Table" highlighted in blue.

Requirement is to remove the description "Table" at the top.So I went to design mode>grid property>checked "Do not apply formatting". and then i released the design mode,--> manually removed the description"Table" and saved the workbook.

When I do refreshing the workbook,the description is coming again.Could any body say how to remove the description "Table".I don't want to hide the row also

Thanks and Regards

Pradeep

[Former Member · Accepted solution]

The word "Table" is added to excel via macro.

You can delete the word Table in cell and then go to VB Editor. Comment the code below and then it will not be added back during refresh:

' Set new Table Header
With varname(1).Offset(-1, 0).Rows(1)
    .Font.Size = 10
    .Font.FontStyle = "Bold"
    .Interior.ColorIndex = 51
    .Interior.Pattern = xlSolid
    .Interior.PatternColorIndex = xlAutomatic
    .Cells(1, 1) = "Table"
 End With

This way it will not be repopulated

FYI, Module Name: Default WorkBook, Code area "CallBack"

Edited by: Nikhil Saxena on Jul 14, 2011 10:31 AM

[former_member219643 · Accepted solution]

Hi Nikhil,

Thank you so much for your help.I followed your idea and it works fine .

The description "Table" is not an text element.Its coming from the query.When we execute the query in analyser ,we will see this description.Thanks for others also

[former_member202718]

Hi Pradeep,

Goto a new Sheet in the Excel of the Anaylzer and insert a Grid in Desgin mode and assign the Query you want to use.

And Upon Refresh you should just get the report without the table.

Rgds

SVU123

[former_member211907]

Pradeep-

As noted above, your issue is with a Text Element. Bex Analyzer does not require you to have a text element (the way Bex 3.x did). It may also be possible that you wish to rename your query or characteristic or key figure... you can do this in the properties of the appropriate object when you are in Query Designer.

[Former Member]

Hi,

As per my knowledge inorder dispay the description in workbook need to assign text element . try to remove the text elements in workbook hope your issue may solve . even if it displaying the descripton also no issues .please do in dev system what ever you want to do.

Regards

sivaraju