I am facing one strange behaviour of the system. In one of the query we are not getting results for one project. Hence, we tired to replicate the query selection / restrictions in list cube. Here if we give Controlling Area then we don't get any result. If we remove controlling area from selection then we get correct result.
This is happening with only one Project - Controlling area combination. For all other projects we are getting result even if we give CO area in selection.
Request your suggestions for solving this problem.
Thanks in advance for your support.