cancel
Showing results for 
Search instead for 
Did you mean: 

Live Office ignoring WebI prompt (SAP BI 4.2 SP3 PL5 )

0 Kudos

Dear experts

We are currently planning an update from BI 4.1 SP3 P2 to BI 4.2 SP3 P5. During tests on our sandbox system we discovered that Live Office seems to ignore the WebI prompt. We didn't find out until now what the problem is.

If you refresh the WebI report everything works. The prompt appears and the report is selecting the data correctly based on the given criteria. When we use the Live Office report the prompt will not appear. It directly displays the loading progress bar. Finally it just displays the report as it is saved within the repository (no data refresh at all).

If I create a new Live Office report based on that specific WebI report I see the WebI prompt. But Live Office just ignores my input and loads all the data possible instead.

Anybody experienced similar behavior?

Thanks in advance
Lars

jyothirmayee_s
Active Contributor
0 Kudos

Hi,

What is the data source to WebI?. Usually prompts defined in BEx get into LO, gets Only within WebI.

Hope you are using Design Studio.

Goto LO tab>> Object>> Select WebI object and refresh the report.

Below is an old post but will give you more details on the similar issue.

https://archive.sap.com/discussions/thread/3764522

Thanks,

Jothi

0 Kudos

Hi,

Thanks for your answer.

We use a BEx query and a UNV on top of it. Both have no filters or anything special within. For the UNV we used Universe-Design-Tool. We do not have Design Studio installed yet.

Thanks
Lars

jyothirmayee_s
Active Contributor
0 Kudos

Hi,

So where are you presenting your data connecting to LO and WEbI?.

Any BI Presentation Layer or Excel?.

Thanks,

Jothi

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member182342
Active Contributor
0 Kudos

Hi All,

The best practise is to open excel document first and insert all the Live office connection and refresh it once. and then Xcelsius and import the excel in which you have included Live connection earlier . After bind all the prompts and refresh it and check whether it is working fine or not.

Regards,

Anish

0 Kudos

Hi all,

i have the same issue. When i try to import the webi into an axcel file, no prompts asked and live office imports no data.

Only header but no data.

former_member269762
Participant
0 Kudos

Hi Lars,

Is your problem resolved? I am facing some issue related to webi prompts.

Thanks
Deepti

0 Kudos

Hi Deepti

The problem is still relevant.
We opened a ticket but investigation of the issue takes its time.

Regards
Lars

0 Kudos

Hi Deepti

I just got an answer from SAP today. See the conclusion of the analysis below:

"It seems like any WebI report which is having optional prompt is not in working in BI 4.2 SP3 Patch 5".

I was able to reproduce the error with optional checkbox ticked. When the query filter is not set to optional everything seems to work fine.

Regards
Lars