Skip to Content
0
Former Member
May 10, 2010 at 07:42 PM

How can I get past the error message "Variables are not compatible DMB00"?

359 Views

Hello,

I'm working in Desktop Intelligence XI and I'm using an Excel data provider and a universe data provider. I've linked the two providers on the common field "Cost_Code". The Excel data provider also has a "Cost_Code_Descr_xls" field so I've created a new variable that makes this description field a detail object associated with the "Cost_Code" dimension. This allows me to use both objects in the report.

Some of the cost codes in my universe data provider are not found in my cost_code Excel provider so I'm trying to create a simple formula to deal with these null values:

= if isnull(<Cost_Code_Descr_xls>) then "Unclassified" else <Cost_Code_Descr_xls>

This is where I get the "Variables are not compatible" error.

Any ideas on how to get around this error?

Thanks!

David