We are having some difficulties to retrieve last user instance webi
report with BI Web Services. If the last instance is from that user we
can retrieve it, but if it is not we get an error message “A document with this name does not exist”. We are using BOXI3.1 SP5. We think that it is related to advanced user right, but we don’t know excatly which rights we should grant to use this feature. SAP suggest us to add user to QaaWS Group Designer, but this does not resolve the issue.
Do you have any suggestion?
Many thanks.
Steps for Reconstruction
Create a webi report
Publish block as BI web service
Create a dashboard with a Qaaws that
retrieve the last instance of the
webi report.
Assign rights to user in that folder.
We get the error message if the last instance is
not from the user. If
the last instance is from that user everything works perfect.
I have tried another thing.
If I check the WebService from the Webi RichClient, I get the expected results, It retrieves the last instance from the user inbox. However, If I execute the Xcelius dashboard with the same parameters I do not get the data set. I am sure that it is something related to user right, but I don’t know exactly which one I should grant.
Well, I am using the Qaaws connector of Xcelsius but the URL that I insert is from a BI Service ( block of Webi).
Yes I have created a publication and I send the instances to users instances. The strange thing is that if I test the BI Service conector from the Webi Rich client and I set the varible “FromLastUserInstance” to TRUE it is working perfect, the problem is inside the repository.
Finally I could solve it by using publications, I have opened a ticket in SAP support and this is the way to use “getfromUserInstance”. Also you need to type 1 in the Xcelsius parameter, not a TRUE value, if not it will not work.
Hi, I am new to Bi services.
How do you direct your web service created from a block in the webi report to use the latest instance rather than from the stored report itself? Or is this the default?
If you look through the options when you add the connection in Xcelsius, you will see values for “refresh” “getFromLatestInstance” and “getFromUserInstance”. If you set none of these values, it will refresh the report. If you set only the getFromLatestInstance to TRUE it will use the latest instance. If you set only the getFromUserInstance to TRUE it will use the latest instance for that user.
But I don’t see these types of options on the connection in Xcelsius.
We are still using Xi 3.1, so maybe I am using an older or limited version of Xcelsius. I am using Xcelsius 2008 version 5.6.2.0.
Also I am fairly new to Xcelsius development, and maybe I am looking in the wrong place?
Can you please describe to me how you navigate to the options you mentioned?
Thanks.
Don
I don’t have Xcelsius 2008 on this machine anymore, so I’m not 100% sure all the steps are the same.
Open the Connections dialog
Add the web service connection
Configure it to point to the web service you published from the block
When you have done that, you end up with two sets of properties down below. The left side is inputs (e.g., login, password, prompts). That is where you will find the options to specify whether to refresh or use the latest instance. Just scroll down to below where you enter the prompts.
Thank you very much!
I had to publish the web service again to get these options to show. I have set the GetFromLatestinstance to 1, and it appears to be working.
I am stuck working on a lot of data cleanup and reporting now, but cannot wait to get back to working with the dashboard.
Wish I had better documentation on this but one step at a time I guess.
Thanks again.
Don
(BOB member since 2008-06-05)