We are moving from 11.0.11 to 11.1.7 and have run into an error in one report that we ported over.
Through the process of elimination I have narrowed down the issue to an expression that uses running-total.
The full expression is:
running-total(count(distinct([C].[Site_Performance_DM_Revs_CSP033].[dat_aqu_35676].[queryid])
for [Last Modified Substring]))
'Last Modified Substring' = If ([C].[Site_Performance_DM_Revs_CSP033].[dat_aqu_35676].[revision] = 1)
THEN(substring([Lastmdt],1,7))
ELSE (Null)
'Lastmdt' is a date
If I remove running-total then the report runs fine. Otherwise, I get the error:
'Query Service internal error has occurred, please see the log for details.'
All the data in the report is from a single source (Hive database).
I have tried removing running-total and adding it back in by selecting it from the list of function in 11.1.7 - still get the error.
------------------------------
Ethan Davis
------------------------------
#CognosAnalyticswithWatson