I often get questions about limitations of Web Intelligence Reporting via BICS. This is a wonderful note that anyone using this solution should really review and bookmark as it answers a lot of questions.
Note 1611185 - Usage of BEx Queries via BICS in Web Intelligence 4.x