SEM BPS with Webgui

[Former Member]

Hi Guru:

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

Is it possible?

Thanks.

Eric

[Former Member · Accepted solution]

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 · Accepted solution]

Hi Srini:

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

Thank you very much.

Best regards,

Eric

[Former Member · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

Hi Monica:

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

Eric

[Former Member · Accepted solution]

Hi,

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

Thanks,

Monica Fonseca

[andrea_previati]

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]

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

[Former Member]

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]

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]

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