Skip to Content
0
Former Member
Jan 18, 2010 at 12:27 AM

Retain formatting in BEx

224 Views

Gurus,

We're on BI 7.

I have inserted a query in my BEx Analyzer with the following steps:

1) Open BEx Analyzer

2) Selected the Query and insert the Variable as the query has variables.

3) Now I have 2 Characteristic (Product Categroy and Material) and 3 Key Figure (Year 2004, 2005 and 2006) display on the BEx workbook.

4) On the BEx Workbook now, I manually selected the Year 2005 and 2006 column (in the result are only, not the entire workbook), and change the color to Yellow.

5) I also added a new text (Good Year) on top of the Year 2005 and 2006, and merge the column, so I have something like following:

..Good Year..

2005...2006..

So basically Year 2005 and 2006 are grouped under Good Year.

I then click BEx toolbar ->Save Workbook as, to save the workbook and close this workbook.

When I open this workbook again, the formart and color remain the same as what I have done above. However, when I click on Refresh on the BEx toolbox, the color has gone.

How can I keep the formatting that I have done manually in the workbook?

Please advice, thanks.