cancel
Showing results for 
Search instead for 
Did you mean: 

SEM BPS with Webgui

Former Member
0 Kudos

Hi Guru:

We plan to use Webgui for our planning application, our layout is based on excel.

Is it possible?

Thanks.

Eric

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Eric,

You should be able to use Excel on web (referred as OWC - Office Web omponent) with no additional licensing and most of excel formula would work. Excel formatting also works on web.What doesn't work for sure is macros or any macro based formatting.I have a word document that clearly says what works and what doesn't, I can send that to you if you can provide your email.Your office version need to be 2003 or above to utlize most of the functionality.You would need to check flag "Publish for Web" only if you have customization available on your layout that you want to see on the web.But if you are using the layout as-is with no changes, you wouldn't have to check the flag "Publish for Web".

Hope this helps.

Cheers

Srini

Former Member
0 Kudos

Hi Srini:

Please send it to eric.xue.cn@gmail.com

Thank you very much.

Best regards,

Eric

Former Member
0 Kudos

Eric,

I had sent you the required document.Also, pay close attention to the pointers mentioned in <b>SAP Note: 632333 - BPS Web: How can I use Excel in Web Interfaces?</b> .Between the document I had sent you and this SAP note, you would be able to get a very good understanding of OWC in BPS.

Hope this helps.

Cheers

Srini

Former Member
0 Kudos

Srini,

So OWC is free in Office 2003? I think the last time I heard OWC for BPS cost additional licensing but they were on an older version of Office.

Cheers,

Mary

Former Member
0 Kudos

Yeah, it is free and if you do not have it, you could download it from MS website.

Thanks for all the reply, but still I think there is some misunderstanding.

Actually, what I am asking for is Web GUI, not the BPS WIB.

I found my excel layout could not display correctly in Web GUI, anyone know something for that?

Former Member
0 Kudos

Hi Srini,

I'm having the same problems of Eric, so if you don't mind, could you send me the same document you sent to him.

Best Regards,

Monica Fonseca

Former Member
0 Kudos

Hi Monica:

Tell me your mail address and I will forward it to you.

Eric

Former Member
0 Kudos

Hi,

Please sendo to my "partner" joao.arvanas@score.pt

Thanks,

Monica Fonseca

Answers (2)

Answers (2)

andrea_previati
Contributor
0 Kudos

Hi.

In the web (BPS_WB) you can't use excel formula.

For this purpose you should write a simple fox formula and add it on save of the planning layout.

Hope it helps

Andreas

Former Member
0 Kudos

You might be able to Excel formulas in layouts if you pay additional license for Excel in the Web.

Former Member
0 Kudos

Yes it is possible, in your layout config you just need to ensure it is tagged as 'publish for web' and also in the web gui config mark it as an excel layout. You do lose a bit of the excel functionality that you have in planning folders though, for example you can not execute macros.

Former Member
0 Kudos

Hi Andrew:

Thank you very much for your help.

You say a bit of excel functionality will be lost, how about the excel formula, like we have an excel column which calculate the difference of the 2 columns generated by layout? How about the formatting?

Thank you very much.

Best regards,

Eric

Former Member
0 Kudos

Now I tried my planning folder in the WebGui, when I openned a layout, there is nothing display, then I click the layout button again, it shows an error says my excel has problem.

So how to deal with it?

Thank you very much.

Eric