Following workflow is describing the problem:
When creating a universe on a SAP/BI query, the objects are generated
automatically
A parse is executed afterwards to check the object syntax. This parse
reveals one problem with a filter object that is coming from the SAP System.
The BusinessObjects error message is:"Filter Parse failed: Invalid
Definition (UNV 0023)"
[cid:image003.jpg@01CA727D.347E4790]
However when the syntax is manually checked, no special failures can be
found within the syntax of the object. The definition of the prompt seems
to be correct and identical to other prompt syntaxes used in the specified
universe.
Hereby the object syntax that fails to parse: <FILTER
KEY="[!V000001]"><CONDITION OPERATORCONDITION="Between"><CONSTANT
TECH_NAME="@Prompt('Operational Company Selection From','A','Operational
Company\LovOperational Company
SelectionBase',mono,primary_key,,{'AAA':'[ZOPERCOMP].[AAA]'})"/><CONSTANT
TECH_NAME="@Prompt('Operational Company Selection To','A','Operational
Company\LovOperational Company
SelectionBase',mono,primary_key,,{'ZZZ':'[ZOPERCOMP].[ZZZ]'})"/></CONDITION>
</FILTER>
When the universe is published to the server and reports are created on the
enterprise system, all works fine. When reports are created locally the
prompt screen appears normally.[cid:image007.jpg@01CA727D.347E4790]
The query starts to run afterwards, but after a short while an error message
is appearing on screen
[cid:image006.png@01CA727B.67F47BA0]
This error is not appearing when the query is run in InfoView with exact the
same parameters, on exact the same universe.
Hereby the complete error:
Data - ASP CCR Global - Internal Costs2
A database error occured. The database error text is: The MDX query SELECT
{ [4FYCCZCJVGYE0QXRVP9S5BEIM].[4FYCCZK8EFK3JDH81JC4FDD8E],
[4FYCCZCJVGYE0QXRVP9S5BEIM].[4FYCD079ZBD8393KJ1J59J9DQ],
[4FYCCZCJVGYE0QXRVP9S5BEIM].[4FYCD0UBK76CN4PX0JQ63P5J2],
[4FYCCZCJVGYE0QXRVP9S5BEIM].[4FYCD1HD52ZH70C9I1X6XV1OE],
[4FYCCZCJVGYE0QXRVP9S5BEIM].[4FYCD2RGAULQARKYH2B8M6TZ2],
[4FYCCZCJVGYE0QXRVP9S5BEIM].[4FYCD3EHVQEUUN7AYKI9GCQ4E],
[4FYCCZCJVGYE0QXRVP9S5BEIM].[4FYCD41JGM7ZEITNG2PAAIM9Q],
[4FYCCZCJVGYE0QXRVP9S5BEIM].[4FYCD24EPYSLQVYLZK47S0XTQ] } ON COLUMNS , NON
EMPTY CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN(
[ZSERVTEAM__ZREGLEV2].[LEVEL01].MEMBERS,
[ZSERVTEAM__ZREGLEV3].[LEVEL01].MEMBERS ),
[ZSERVTEAM__ZSERTEAM2].[LEVEL01].MEMBERS ),
[ZASAPCOMP__ZBPCCNTRY].[LEVEL01].MEMBERS ),
[4FYCCUFVRD334CIG5HRXQ281Q].MEMBERS ) ON ROWS FROM
[ZCCR_M01/QZCCR_M01_5007_BO] SAP VARIABLES [!V000001] INCLUDING
[ZOPERCOMP].[AAA] : [ZOPERCOMP].[ZZZ] [!V000003] INCLUDING [0CALMONTH2].[06]
[!V000002] INCLUDING [0CALYEAR].[2009] [!V000003] INCLUDING
[0CALMONTH2].[06] [!V000002] INCLUDING [0CALYEAR].[2009] [!V000001]
INCLUDING [ZOPERCOMP].[AAA] : [ZOPERCOMP].[ZZZ] failed to execute with the
error Inconsistent input parameter (parameter: <unknown>, value <unknown>).
(WIS 10901)
We have these issues on several PC's. The report was created via WebI Rich
client last Thursday. Nothing has changed in the meanwhile to the server
On Windows level automatic updates were installed.