Parse failed: Exception: DBD, The supplied XML is not valid. State: N/A

[Former Member]

Hi,

We are using BI 4.1 SP3 Patch1. I created universe for using BEX Query. Everything is working but when I created a dimension with below code, I get error when I parse it. I am using Universe Design Tool.

My dimension formula

CASE WHEN @Select (Branch Code\L01 Branch Code)<>'10102' THEN 'Not Include' ELSE 'Include' END

Error message is below.

"Parse failed: Exception: DBD, The supplied XML is not valid. CASE WHEN @Select(Branch Code\L01 Branch Code)<>'10102' THEN 'Not Include' ELSE 'Include'  END State: N/A"

Can you have any ideas about the problem?

Regards,

Cihangir

[Former Member]

Hi,

Nornal CASE statement will not work in this case as you have created universe based on BEx query.

CASE statement will only work with relational tables or DSOs.

In case of BEx query, we need to define MDX expressions using <expression> tag.

Try this and check if it works:

<EXPRESSION> IIF(@Select(Branch Code\L01 Branch Code)<>'10102','Not Include' ,'Include')</EXPRESSION>

Hope it will help.

Regards,

Yuvraj

[Former Member]

Hi Yuvraj,

Thanks for your reply.

I have done your formula. This time I am getting below errors in Universe and Webi.

Thanks,

Regards,

Cihangir

[Former Member]

Hi,

Can you try this and check if it works:

<EXPRESSION> IIF(@Select(Branch Code\L01 Branch Code)<>'10102',0 ,1)</EXPRESSION>

Regards,

Yuvraj

[Former Member]

Hi Yuvraj,

I tried below formula but it gives same error. I did not understand why it doesn't accept the expression.

Is there any setup customization that I should do?

Best Regards,

Cihangir

[amitrathi239]

what is the data type of L01 Branch Code Number or string?If number then remove the single quotes and try

[Former Member]

Hi Amit,

L01 Branch Code is CHAR with 8 in BW.  I also refresh the Universe structure but it is still getting error. Our BW database is on DB2.

Regards,

Cihangir

[amitrathi239]

Instead of @Select (Branch Code\L01 Branch Code) use direct table.column mapping in CASE statement  and try.

[Former Member]

Hi,

Could you please refer to below threads and see if that helps you.

Parse failed: Exception: DBD, The supplied XML ... | SCN

Parse failed: Exception:DBD, The supplied xml i... | SCN

Basically all suggest to refresh the Universe Structure.

Regards

Niraj

[Former Member]

Hi Niraj,

I have refreshed Universe structure but I still getting error when I parse the dimension.

Regards,

Cihangir