Evan Shen
07/07/2022, 5:23 PMOndrej Stumpf
07/08/2022, 7:50 AMAmbiguous context for count
means that the analytical engine cannot distinctly determine the source table whose rows you want to calculate. The engine attempts to find one attribute that will serve as a context for calculation ( = will determine the source table). The attribute you want to count, plus all attributes from Rows
(the dimension of the report), must be derivable from that context attribute.
Without knowing your report and your model, I can't tell you exactly what to do to fix the problem, but I suggest you look into the docs for COUNT, particularly the "two-parameter version" - the second parameter allows you to exactly specify the context attribute so the engine will not attempt to determine it itself.