Skip to Content
0
Former Member
Apr 22, 2014 at 03:29 PM

Cannot SUM Database Delegate Measures in Webi

111 Views

Hi,

I am on BO3.1 SP5. We have a few COUNT(DISTINCT X) and Ratio ( SUM(A) / SUM(B) ) measures in our universe and we figured that we need to make them Database Delegate as they would otherwise result in incorrect results based on the dimension used in query vs the dimesions user drags into a report.

Now we have the right results, but when a user tries to use the Σ on those columsn in the Webi i get the #TOREFRESH and on hitting the Refresh Query I get an error as it generated a second query and since I have Start Date dimension used it says invalid date format. However my question is why we cannot use the SUM on the Database Delegate measures and what do I need to do to make it work after the #TOREFRESH message.