COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Fredrik on 30 Jun 2015 07:11:41 AM

Title: Better performance using calculted member instead of hierarchy member?
Post by: Fredrik on 30 Jun 2015 07:11:41 AM
Hi!

How can report performance be better if I use calculted member instead of hierarchy member in the slicer?

I have a report that takes 30 seconds to execute when I use hierarchy members in the slicer. But if I replace the hierarchy members with calculted members, representing the same members as my hierarchy member, the report only takes 10 seconds to execute.

Regards

Fredrik