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