NON MEASURE COLUMN IN MDX -
02-09-2005
, 01:07 AM
I have a column named Named "Receipt no" in the two facts
tables(sales_fact,usage_fact) this column is not a measure
and i have to check the existance of sales_fact "Receipt no" in
usage_fact "Receipt no"
like in SQL
SALES_FACT.RECEIPT_NO IN(SELECT RECEIPT_NO FROM USAGE_FACT)
I HAVE TO DO IT IN MDX |