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:
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.