Skip to Content
0
Former Member
Dec 02, 2009 at 11:12 AM

Universe Created by Integration gives error

33 Views

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.