Display Key and Text header

[former_member210571]

Hello All,

When we run a BW report in Analysis, the Text fields have no column headings. 

So can we automatically apply column headings for Key and Text?

Example: The below report has the GL account number but when you include the text (GL Account Description) that column has no heading.

The column Adjacent to G/L Account refers to G/L Account (highlighted).

Please suggest how to display G/L Text header.

Thanks,

Mirza Mizanul Haque

[TammyPowlas]

I don't see a way to change that - that is a setting that comes over from the BEx Query.  Perhaps others have ideas?

[Former Member]

BBex analyzer has exactly the same issue.  To allow people using pivot on the output, we used to write a macro on the callback routine of the Bex analyzer to populate the header.  You should be able to do the same in the analysis API after refresh.

peter

[former_member210571]

Thanks for the information.

@Peter: Can you help me with the macro, means the steps how to implement it.

Thanks,

Mirza

[Zumwaby]

This Blog posting has some example code:

Also see Step 5 in this post:

[Former Member]

Thanks Byrne,

I also would recommend to check my "Best practices"

@ Mirza: You need steps 5 and 6. Otherwise your headers will disappear again, after refresh/drill-downs.

Regards, Martin