We are working on our universe conversion from UNV to UNX.
We have a custom in-house web service that calls the Business Objects SDK to schedule reports.
We have discovered that after converting our Web Intelligence reports to the UNX universe that Business Objects no longer accepts the call to input prompt values through the SDK.
Has anyone run into this or heard of something similar?
This is a big issue for us because almost all of our report scheduling is done in this manner.
We just upgraded to BI 4.3 sp 4 patch 5.
John, are you using the ReportEngine SDK or REST?
We are using an SDK, I’m not sure if is the ReportEngine one or the WebI one.
It seems there may have been a change to how the parameter name is referenced.
Where before we could reference the parameter name with something like “Enter Date:” now we may need to pass it in as “psEnter Date”.
I’m still trying to get the details on both from our developers.
If you’re using ReportEngine, you may be out of luck. It’s been deprecated for years, and it wouldn’t surprise me if it doesn’t support .unx universes at all.
REST is supported, and should work. I’m assuming this is what you’re using. When you refresh a report with prompts, it’ll return a response template including the prompts that need to be filled out. You just complete that template with the values for the prompts, and send it back. If you get another template back (rather than a refreshed report), then it means you didn’t answer all prompts (or it’s a hierarchical prompt, and you’re now getting the next “level” of prompts). So (again, assuming you’re using REST), I would suggest taking a close look at the response you’re getting back, to see which prompt isn’t being completed. One thought I have is that unx supports both date/time as well as date formats for prompts. You might be passing a date/time value to a prompt that’s only expecting a date.
It looks like it is using the Enterprise SDK. We aren’t finding any references to other SDKs but none of us wrote the code.
So here is what we have been able to figure out so far.
Given a universe prompt with a prompt of “Select a Country”:
- A WebI report written against a UNV universe will refer to this prompt as “Select a Country” through the SDK.
- A WebI report written against a UNX universe or converted from the above report will refer to this prompt as :psSelect a Country" through the SDK.
- A Crystal Report written against a UNV universe will refer to this prompt as “query_Prompt0” or whatever query name you assigned in Crystal Reports when you design it through the SDK.
- A Crystal Report written against a UNX universe will refer to this prompt as “Select a Country” through the SDK which is the prompt of the report, not the name.
Now to figure out how to get the application to figure out which is which and map the parameters appropriately so all of our schedules don’t have to be modified.