Skip to Content
0
Former Member
Apr 20, 2010 at 04:51 PM

Schedule Instance in WebI Report MDX Error

29 Views

Hi,

Hopefully you can help me with an issue:

Issue

We have Webi report based on Bex Query,s with several Optional and two Manadtory variables, Connection is SSO, when refreshing the report in infoview there are no issues or errors. Using BO XI 3.0

Trying to Schedule an Instance of the report, using the same values in the Prompt as refreshing the report online and it's failing and returning a MDX error= " A database Error occured, the Database text is: The MDX query Select {measure etc etc etc..... All the measures and dimensions... failed to execute with Error FUNCTION NOT FOUND.

This doesn't happen for reports which don't have prompts, which process correctly.

Any help/suggestions would be greaatly appreciated.

Cheers,

Laurence

: