cancel
Showing results for 
Search instead for 
Did you mean: 

Formatting in BEx Aanlyzer

p_m8
Participant
0 Kudos

Gurus,

Does anyone know how can I retain the format I have done manually in BEx Analyzer?

This is what I have done in BEx Analyzer:

1) Open workbook, and result is displayed.

2) In workbook, I have selected cell C11 to C19 in the Result area and change the color and fonts via Home ->Style (in Excel 2007), and selected SAPBExCritical5 style.

3) I can see the selected cells have been changed with new fonts and color.

4) Then go to Workbook Setting ->Themes (this will change to Design Mode)

5) Click on New button and give a name myTheme1. Then click on Apply and Save button. Then click on Apply New Style option (this will apply my current formatting in Result are into this Theme???)

6) When I click on the Save icon in the BEx Toolbox, I exited the Design Mode and I can see that the color and fonts of cell C11 to C19 gone!!!

Can you please provide me on the exact steps on how to create and save the Themes so that I can format the fonts and color of the result please?

I need to solve this urgently, please help.

Accepted Solutions (0)

Answers (2)

Answers (2)

p_m8
Participant
0 Kudos

no help

Former Member
0 Kudos

In Analyzer, you can do formatting for the report output set as below. Suppose you want a specific color, pattern and font for entire result set. When you run the workbook, you place the cursor in any result cell and go to Style, you can see one SAP style attached to the result set. You need to change this style with the kind of formatting you need. These changes will be applicable to all the result cells. In workbook settings or data provider settings somwhere you see a check box for Apply formatting. This box needs to be checked for the formatting changes to be applied after you exit the design mode. I dont think you can assign a particular style to individual cells of report output, SAP automatically assigns its own styles like SAP Head, SAP Headkey, SAP data (didnt remember exact names) etc. You can modify these styles and the changes will be reflected to all the cells which have these styles attached. I dont have Analyzer system with me otherwise, could have provided more technical inputs.

p_m8
Participant
0 Kudos

Hi ,

Thanks for you input.

I have the Apply Format indicator set.

I have followed what you says but still not working. When I click on Refresh icon, the colour gone.

Please, can you provide me the steps on how exactly we can change the fonts/colors?

I am running out of time to do this, plese help.

Thanks in advance.

Former Member
0 Kudos

Make sure you save as workbook, then formatting should "stick" even if you refresh data.

p_m8
Participant
0 Kudos

After all the steps, I have clicked to Save icon in the BEx Toolbar to Save icon.

I have tryied both Save option:

1) Save Workbook

2) Save Workbook As

When I open the workbook, the color is still there. When I click on Refresh, all color gone.

If you have done this before, can you kindly please share with me on the exact steps please?

I am running out of time to complete this, please help.

Thanks.

p_m8
Participant
0 Kudos

Hi,

I have tried again with the following:

1) Open Workbook, qeury result displayed on the screen.

2) Select cell C10 to C13.

3) Then I go to Home ->Style tab (in Excel 2007).

4) I see a list of SAPBEX* style there.

5) I can see that the Style used is SAPBEXstdData (for the cell that I selected).

6) I change the style to SAPBEXexcGood3. I can see the color of the cells that I have selected change to Green (as per SAPBEXexcGood3).

7) In BEX Toolbar, I then click on Save icon and Save Workbook.

😎 Close the Workbook and re-open the Workbook again.

9) The color still there (green color for the cells that I have selected and changed).

10) But when I click on Refresh icon, the color gone!!!

Please help on what is wrong? How can I retain the color/format?

Need your help urgently.

Thanks.