I have table with multiple data providers. In it there is a column that is calculated off of 3 data providers. The column calculates fine in the body of the table. When I try to add a summation of the column to the footer, the footer cell remains blank.
Any help is appreciated, I am under a great deal of pressure to get this finished.
The basic formula is Measure1(DP1) + (Measure2(DP2)* Measure3(DP3)). Measures 1 & 2 are calculated from calculated from other measures and dimensions. All calculation objects are in the table but hidden.
Yes, the linkage between DPs is correct.
I have never been able to get Multicube to work. I tried it, but I am not sure I did it correctly. However, the calculation works in the body of the report.
Are your DPs at different levels of granularity?
If yes, you have to use Multicube(). Also, if it works in the body, you are lucky if you have different levels of granularity. You might also need to add context to the sum for the footer.
The actual calculation is really more complex than I described. However, I broke it into its components and the part I described is the one that causes the rest to fail. All the rest bring back the expected value. This one is apparently null.
Also replacing Sum() with Min() or Max() does not return any value either.