Skip to Content

Removing description "Table" in Bex analyser

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 14, 2011 at 05:00 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 13, 2011 at 11:23 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 13, 2011 at 12:47 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 14, 2011 at 10:11 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.