EVfunctions fails using web template (without openning BPC Excel)

[gorka_iborurea]

When we publish a template in the contant libary, it gives us a url. We use this url to access from a sap portal. Then, the template bottoms with macros that have EVfunctions don't work. We need to open the BPC Excel Client to run it.

¿How can we use a web template directly from the url? (without openning the BPC Excel Client)

[gorka_iborurea · Accepted solution]

maybe I'm explaining bad myself, or maybe I don't underestand your answer.

I will try to explain it step by step my problem,

we made a template, with evfunctions, like match-codes, refresh buttom, and another buttoms with Ev functions. This template is used to introduce user-values, so the users can fill the template and save the introduce data in the application.

We publish it with the content library, so we get a url. We put this URL in sap portal, like a link to this template.

When users or administrators wants to use this template by this link, it is opened with internet explorer, but the cannot use this template, because, those buttoms and functions doesn't works if we openned in this way. The only way to use this link is if we connect to the bpc excel client, before we use this link. But our question or problem is that we don't want to use in these way, we want to start introducing data and using the template directly from the url.

So our question is: is there any possibility to do that? and if it is, how can we apply it?

thanks for your answers.

Gorka I.

[Former Member · Accepted solution]

Hi Gorka,

I dont think the BPC macros will work on web. These were designed for the BPC excel interface. May be some expert can throw some light on this.

[gorka_iborurea]

we have make a change in the way of openning internet and it works.

So, we have change in the settings of my pc, going to windows options, and then Type of archives. We choose to open .XLS and in advance options dismark all the possibilities. So then, when you open a publish template, it is opened as a Excel, and then you only have to start your bpc session to have your template active.

So, we have plenty of urls on a portal, and with these solution, you enter your bpc user id one time, even if you more than one application.

[gorka_iborurea]

you are right, it seems that it is the problem. I am going to open another post to know if there are any possibilities of acceding a BPC report from a SAP portal.

Thanks a lot

[gorka_iborurea]

I think it doesn`t work for our scenario. We have the following problem.

We have a template in which we have a column that brings load data and we need another one to send data. Then, if we put offline the template, we can not send this data, and neither refresh it.

We have two customer buttoms, one to refresh the data, and another one to send it to our application. Those buttoms go with macros, and with EV functions. We don´t want to lost them, we need to work "online", but without openning BPC Excel Client.

Thanks for your reply, but it doesn´t work for our scenario

[Former Member]

Hi,

When you open it from the content library, again go online using the park n go feature.

Hope this helps.

[Former Member]

Hi,

Please use the park n go feature to take the excel offline and then save it. Publish this report in the content library.

Hope this helps.