Question:
Hi ,
I have one requirement in which i will be having two key figures.I need to compare these two key figures and put some color to one key fgure out of these two.
Let me just explain clearly.
I have Key Figure to Capture Target Information.Lets say as ' A '.
I have one more Key Figure to capture Actual Information. Lets say 'B'.
My Requirement is to put color in the Report output to Key Figure 'B' if B is not equal to A.
Immediate response is highly appreciated
Thanks in Advance
Jeevan
Answer:
Did u try using exceptions??
Answer:
Hi ,
I tried using exceptions, but i did not get the way i want.let me know if you have any idea
Jeevan
Answer:
it's not straight forward to have KF B colored, but you can create a simple Calculated KF (let's say Z)which is B-A. Then make a conditon on this new CKF Z and color it when it is not equal to 0...
Then the cell for KF Z will be colored, not B, but it is still the correct line
Answer:
Thanks for the Info.
But instead of coloring the Calculated Key Figure with Color,Can i hide that Key Figure and color to the entire row based on the value for the Key Figure.
As it is said , in the calculated key figure Z .I ll compare the Two Key figures Information.If both the KF's values are equal i ll put '1' in the calculated(Z) KF otherwise '0'.
Can i hide this calculated key figure , but i want use and put some color to the entire row where this value is '1.
I think , it can be done in Tempaltes level.But I dont know what's the approach for the same.
Appreciate ur thoughts
Jeevan
Answer:
There was a post on coloring the entire rows with execeptions just yesterday and the answer there was VB for BEx reports of java/html for webreports (but i don't think hiding the CKF Z will work, as since then the exception won't work...).
I don't know another way either...