Perfomance Crystal 2011 -> SAP BW
I just wanted to get an understanding what the best practices are with connecting SAP BW to Crystal 2011. Obviosuly the preferred route is using BOE Crystal. This tool will not meet our needs from a functionality perspective.
I read that Crystal 2011 when connecting to BEx query brings back all records based on the restriction in the BEx query regardless of the restrictions in Crystal (via select expert). Is this true? This was from a presentation in 2010. If this is the case I will need to load as many restrictions into the BEx query, but this could mean a lot of BEx queries!
If anyone has any links information on any other best practices let me know.