ApplyComparison in Advance Qualification - not parsed into SQL

[Lesio]

Anybody ever had an issue with an ApplyComparison function inside advance qualification. SQL generated by the report ignores this filter. This is MicroStrategy 7.1, issue both in 2 and 3 tier.

To make things stranger, the code used to work. It stopped working after I made a modification to the SQL below (in red). I also rolled changes back to what it was before and still SQL is not getting parsed into the WHERE clause

ApplyComparison ("#0 in (select add_months(max(billed_dt),-1)/100 REF_DATE from olapv2_db.isg_ref_bill_dt)", ([Bill Date]@ID / 100))

Thanks a lot,
Leszek

 

[entaroadun]

It used to work. You made a change and it didn't work (MSTR ignores it completely). You change it back and it still doesn't work.

The object in the metadata is probably corrupt. Delete the object and re-create it from scratch.

 

[Lesio]

Thanks !
Actually, the problem was in a new attribute which was not calculated to be part of the key in the table object, key re-calculation solved it. Re-creating any object used by this report did not help.