Parse Failed: Invalid Definition (UNV0023)

[Former Member]

I have a universe based on a BEx query. The BEx query uses formula variables as filters which the users must enter values for when running the report. If I build a report in WEBI based on this universe I get no issues. The filter variables prompt comes up whenever I refresh. However, if I parse the filter object in Universe Designer I get the following error:

Parse Failed: Invalid Definition (UNV0023)

The WHERE statement for this filter is:

<OPERATOR VALUE="AND"><OPTIONAL><FILTER KEY="[!V000003]">
<CONDITION OPERATORCONDITION="Equal">
<CONSTANT CAPTION="@Prompt('Percentage Commission to Manager (%)','N',,mono,free,,{10})"/>
</CONDITION></FILTER></OPTIONAL><OPERATOR VALUE="AND">
<FILTER KEY="[!V000002]"><CONDITION OPERATORCONDITION="Equal">
<CONSTANT CAPTION="@Prompt('Dual Rate','N',,mono,free,,{6})"/>
</CONDITION></FILTER><FILTER KEY="[!V000001]"><CONDITION OPERATORCONDITION="Equal">
<CONSTANT CAPTION="@Prompt('Single Rate','N',,mono,free,,{3})"/></CONDITION>
</FILTER></OPERATOR></OPERATOR>

Here you can see we have three variables, V000001, V000002 and V000003, which have default values and will prompt the WEBI users with the following texts:

'Percentage Commission to Manager (%)'

'Dual Rate'

'Single Rate'

Can I ignore this or is there a better way to define the filter?

Edited by: Khaled McGonnell on Nov 9, 2010 5:49 PM

Edited by: Khaled McGonnell on Nov 9, 2010 5:50 PM

[Former Member · Accepted solution]

Hi,

The XML syntax s incorrect. Here is the XML start and end of your expression:

<OPERATOR VALUE="AND"><OPTIONAL>   .......    </OPERATOR></OPERATOR>

The correct start and end XML must be:

<OPERATOR VALUE="AND"><OPTIONAL>   .......    </OPTIONAL></OPERATOR>

Didier

[Former Member · Accepted solution]

Thanks for this. I have updated the tagging accordingly but I still get the same parse error. Is the following code still defective:

<OPERATOR VALUE="AND">
	<OPTIONAL>
		<FILTER KEY="[!V000003]">
			<CONDITION OPERATORCONDITION="Equal">
				<CONSTANT CAPTION="@Prompt('Percentage Commission to Manager (%)','N',,mono,free,,{10})"/>
			</CONDITION>
		</FILTER>
	</OPTIONAL>
</OPERATOR>
<OPERATOR VALUE="AND">
	<OPTIONAL>
		<FILTER KEY="[!V000002]">
			<CONDITION OPERATORCONDITION="Equal">
				<CONSTANT CAPTION="@Prompt('Dual Fuel Rate','N',,mono,free,,{6})"/>
			</CONDITION>
		</FILTER>
	</OPTIONAL>
</OPERATOR>
<OPERATOR VALUE="AND">
	<OPTIONAL>
		<FILTER KEY="[!V000001]">
			<CONDITION OPERATORCONDITION="Equal">
				<CONSTANT CAPTION="@Prompt('Single Fuel Rate','N',,mono,free,,{3})"/>
			</CONDITION>
		</FILTER>
	</OPTIONAL>
</OPERATOR>

[Former Member · Accepted solution]

Hi,

You have added default values in @Prompt: default values and static values must always be enclosed with single quote even if the data type is numeric.

<OPERATOR VALUE="AND">
	<OPTIONAL>
		<FILTER KEY="[!V000003]">
			<CONDITION OPERATORCONDITION="Equal">
				<CONSTANT CAPTION="@Prompt('Percentage Commission to Manager (%)','N',,mono,free,,{'10'})"/>
			</CONDITION>
		</FILTER>
	</OPTIONAL>
</OPERATOR>
<OPERATOR VALUE="AND">
	<OPTIONAL>
		<FILTER KEY="[!V000002]">
			<CONDITION OPERATORCONDITION="Equal">
				<CONSTANT CAPTION="@Prompt('Dual Fuel Rate','N',,mono,free,,{'6'})"/>
			</CONDITION>
		</FILTER>
	</OPTIONAL>
</OPERATOR>
<OPERATOR VALUE="AND">
	<OPTIONAL>
		<FILTER KEY="[!V000001]">
			<CONDITION OPERATORCONDITION="Equal">
				<CONSTANT CAPTION="@Prompt('Single Fuel Rate','N',,mono,free,,{'3'})"/>
			</CONDITION>
		</FILTER>
	</OPTIONAL>
</OPERATOR>

Didier

[Former Member · Accepted solution]

This is parsing OK now. Legend - thank you!

[Former Member · Accepted solution]

Hi Didier Mazoue,

Hope your doing good.

I am also getting the Parse failed error in my universe Can you please help me.

I am getting so many errors.Ex:

1.

<FILTER KEY="[0P_PER3]"><CONDITION OPERATORCONDITION="Equal"><CONSTANT TECH_NAME="@Prompt('Posting Period (Single Value Entry, Mandatory)','A','Posting period\LovPosting Period (Single Value Entry, Mandatory)Base',mono,primary_key,,{'12':'[0FISCPER3].[012]'})"/></CONDITION></FILTER>

2.

<FILTER KEY="[!V000003]"><CONDITION OPERATORCONDITION="Equal"><CONSTANT TECH_NAME="@Prompt('Budget Version','A','Version2\LovBudget VersionBase',mono,primary_key,,{'900':'[0VERSION].[900]'})"/></CONDITION></FILTER>

The above two examples are showing parse failed error.Can you please correct above code.

Thanks & REgards

Sathish.

[Henry_Banks · Accepted solution]

this thread is really old. Didier is unlikely monitoring this post.

Perhaps his doc will be of use to you http://scn.sap.com/docs/DOC-6965

Regards,

H

[Former Member]

Hi Sathish,

Is your issue Resolved? I have created universe on Bex queries with two optional prompts.After creation of universe the 2 filter is created but 1 filter is not getting parsed. Here is the syntax

<OPTIONAL><FILTER KEY="[!V000002]"><CONDITION OPERATORCONDITION="InList"><CONSTANT TECH_NAME="@Prompt('Plant BO','A','Plant\LovPlant BOBase',multi,primary_key,,{'1001':'[0PLANT].[1001]'})"/></CONDITION></FILTER></OPTIONAL>

I have already gone thru the document posted by Henry Banks but unable to get any breakthru. Your help will be highly appeciated.

Regards

Dewesh