Style sheet for the Business Explorer

[Former Member]

Hi ,

how do u find the default style sheet used for the business explorer? We have tried the style sheets in MIME repository, but none seems to match. Any ideas. We want to change the style of a particular cell.

Thanks,

Kartheek

[Former Member · Accepted solution]

Hi Kartheek,

The styles are stored in the workbook. For each celltype a style template is created. You can see the templates in Excel by selecting a specific cell afterwards goto Format --> styles. In the list of styles you will see a lot of Styles beginning with SAPBEx..... If you modify the style each cell of the corresponding style will have the same modified style.

But remember that the changes only take effect on the current workbook. To make these changes available for all Queries you must set the workbook as default Workbook.

best regards.

Kai Wachter

[Former Member · Accepted solution]

Hi Kai,

I have done as you have said and now when I open a new query, it uses the default workbook. However, I want it to be default workbook template for all the users. Is there anyway to set this?

Many Thanks,

Kartheek

[Former Member · Accepted solution]

hi Karthek,

to perform this step for each user is from my opinion not possible. Each user must perform this step. If every user could set the default, then settings from otjher users would be overwritten. You can only make it easier for the users to set the template. Save the Template workbook to special folder in a role. So each user can see and use the workbook.

best regards.

kai wachter

[Former Member · Accepted solution]

Hi Kai,

Thx for the reply. But, I want to change the color of the cell in all the reports for all users. There must be some CSS where the colors for the workbook are picked up when a query is run.

Many Thx.

Kartheek

[former_member188975 · Accepted solution]

Hi Kartheek,

You would need to create a workbook template with all the settings (color, fonts etc) that you are looking for. This has to be set as the permanent workbook template. You also have to make the setting for each query to be embedded in this workbook template. Only then will each report carry the same settings.

If you supply your users with workbooks, then you can open up the query in this template, and save as workbook. the settings will remain in place. The users will also need to have this workbook template assigned to them via a role.

Hope this helps...

[Former Member · Accepted solution]

Hi Bhanu,

Is it possible to set the default template to all the users? As of now, if I set the default workbook template, it only applies to my login. Better than that, is it possible to change the defalt colors of the template used when running a new query.

Many Thanks

Kartheek

[former_member188975 · Accepted solution]

Hi Kartheek,

I don't think there is a central place where you can set the Permanent workbook template and then Query Embed into the workbook template, for all users at once. This one time setting has to be done in the user's BEx. Once this is done however, all queries will be run according to the formatting that you have set up in the workbook template.

Hope this helps...

[Former Member]

Hi,

You mean the cascading style sheet used in the default BEx web template?

LauQ

[Former Member]

I mean the styles used to render the cells in Business explorer(not in web). We need to change the style of a particular cell.

[former_member188975]

Hi Kartheek,

The "stylesheet" in BEx is actually what we call the workbook template. You can create a workbook template with all the custom changes (color, font) etc that you require, and then Insert your queries into it.

For info take a look at:

http://help.sap.com/saphelp_nw04/helpdata/en/33/746e393cf65c1ae10000000a114084/content.htm

Hope this helps...