BO Analysis for office

[former_member449282]

Hi Friends,

I would like to implement for SAP BO Analysis for office, My Client requirement is they do not want use same standard format for "Analysis for office", Client want to configure/Template based on there requirement.

For Example: When we run the Standard Analysis for office, it will show the output for "Blue crystal" color, columns and Result set's. They want there own color "Columns" like Header row is different color, Column row is different color, Grand Total is different color and even letter style also different.

They want Analysis for office "Template". Could you please guide me how to implement for this scenario.

Thanks in advance friends.

Regards,

Bharathi

[former_member229078]

Hi

Save the Workbbook template you designed on a "shared" server accessible by users, I would say, and as an administator define the path in the Ao_app.config file.

See hereunder an example

<!--### DocumentConfiguration ###--> <!--default of 'DefaultWorkbookPath': value="" --><DefaultWorkbookPath value="F:\Public\Documents\SAP\SAP AO\WBtemplate.xlsx" />

to remind the config file is stored on C:ProgramData\SAP\Cof.

The parameter to adapt is the DefaultWorkbookPath one (cf § 4.4.4 administrator guide) .

But to achieve your wish you need to replace in the Ao_App.config file the configuration level of that parameter from UserRoaming to PerMachine, so it will be no changeable by users.

<!--### DocumentConfiguration ###--> <section name="DefaultWorkbookPath" type="String" configurationLevel="UserRoaming" />

Rgds

Eric

[former_member229078 · Accepted solution]

Hi Bharathi,

Unfortunately I can't share a "business" template except a trial one.

A Very simple one as you can see.

[former_member449282]

Thank you for your help.

[former_member229078]

Hi

Save the Workbbook template you designed on a "shared" server accessible by users, I would say, and as an administator define the path in the Ao_app.config file.

See hereunder an example

<!--### DocumentConfiguration ###--> <!--default of 'DefaultWorkbookPath': value="" --><DefaultWorkbookPath value="F:\Public\Documents\SAP\SAP AO\WBtemplate.xlsx" />

to remind the config file is stored on C:ProgramData\SAP\Cof.

The parameter to adapt is the DefaultWorkbookPath one (cf § 4.4.4 administrator guide) .

But to achieve your wish you need to replace in the Ao_App.config file the configuration level of that parameter from UserRoaming to PerMachine, so it will be no changeable by users.

<!--### DocumentConfiguration ###--> <section name="DefaultWorkbookPath" type="String" configurationLevel="UserRoaming" />

Rgds

Eric

[former_member449282]

Hi Eric,

Thank you very much for your valuable inputs.

Could you please share your Example Template, where we need to Design and Configure etc.

Advance thanks, because based on this I need to prepare and guide him to client.

Regards,

Bharathi

[former_member229078]

Hi Bharathi,

Look at that link for example .

Define a workbook as the default workbook

Rgds

Eric

[former_member449282]

Hi Eric,

Thanks for your help. But we need to implement all Users "Globally" when use the "Analysis for office" we need to sync same look and feel all the user's and color template etc.

Kindly advice how to achieve this.

Thanks, Regards,

Bharathi