I have a Crystal Report with dynamic parameters up to 4 levels (hierarchy of 4 levels) that is developed on version 12.3.0.601 which is working fine on my system. But when the same was uploaded on Business Objects Central Management Console first 3 hierarchies are populating fine but when comes to 4th hierarchy I am only getting the values that are linked to first value of second hierarchy.
Example:
If I take the example of the organization following is the hierarchy.
1st : business head // One Value
2nd : Project head // 4 values (p1,p2,p3,p4)
3rd : Team head // 1 value
4th: developer // 2 values for every project head that means total of 8 values.
If 2nd hierarchy is p1,p2,p3,p4 then I am getting only 2 values of P1, In the same way if 2nd hierarchy is p2,p1,p3,p4 then I am getting only 2 values that is of P2... but in real I need to total of 8 values because of all 4 values are selected at run time in 2nd level of hierarchy.
I have tried all possible combinations of dynamic parameters but nothing was working for me.
Problem is only in Business Objects Central Management Console version is 3.1x where the dynamic parameter is prompt is wrong and in dev system everything is correct.
Posting the answer so that it would be useful for someone who has the same issue.
Finally I was able to find the solution for the problem... It was the issue of service pack...
I was able to get the SAP note for the same issue.
Link for the note
http://sap-note.com/1494409.htm
According to the note problem was addressed in some of the service packs that are released for BO 3.1
Tested the same on BO 3.1 SP7 and there I can't spot the issue and everything is working fine.
Thanks all for the help...
@Criag thanks for your suggestions on Business View Manager