Skip to Content
0
Former Member
Nov 12, 2012 at 08:24 AM

Invalid Definition (UNV0023) while Parsing a Condition

44 Views

Hi,

I am pretty new to BI and need your expertise.I have an OLAP universe created on top of SAP BW Infocube. All the pre-defined filters from the SAP BW is parsing fine in Universe Designer except for one. Please see the XML code below:

<OPERATOR VALUE="AND"><FILTER KEY="[!V000013]"><CONDITION OPERATORCONDITION="Equal"><CONSTANT TECH_NAME="@Prompt('UOM','A','Organizational Units\LovUOMBase',mono,primary_key,,{'HL':'[ZFAUOM].[HL]'})"/></CONDITION></FILTER><OPERATOR VALUE="AND"><FILTER KEY="[!V000011]"><CONDITION OPERATORCONDITION="Equal"><CONSTANT TECH_NAME="@Prompt('Plan Version','A','Organizational Units\LovPlan VersionBase',mono,primary_key)"/></CONDITION></FILTER><OPERATOR VALUE="AND"><FILTER KEY="[!V000010]"><CONDITION OPERATORCONDITION="Equal"><CONSTANT TECH_NAME="@Prompt('Fiscal Period.Year(to)','A','Organizational Units\LovFiscal Period.Year(to)Base',mono,primary_key)"/></CONDITION></FILTER><OPERATOR VALUE="AND"><FILTER KEY="[!V000009]"><CONDITION OPERATORCONDITION="Equal"><CONSTANT TECH_NAME="@Prompt('Fiscal Period.Year (from)','A','Organizational Units\LovFiscal Period.Year (from)Base',mono,primary_key)"/></CONDITION></FILTER><FILTER KEY="[!V000001]"><CONDITION OPERATORCONDITION="Equal"><CONSTANT TECH_NAME="@Prompt('Currency','A','Organizational Units\LovCurrencyBase',mono,primary_key,,{'L':'[ZFA_CURRC].[L]'})"/></CONDITION></FILTER></OPERATOR></OPERATOR></OPERATOR></OPERATOR>

I have searched on SCN for the similar issue and implemented those steps(like start and end expression in XML) however I am still getting the parse error.

Could you please tell me what is wrong with this code and how it can be resolved?

Thanks,

Nitin