I have a problem in a query. The query is using a formula variable (replacement path) to count "number of orders" according to the how-to-guide available on SDN: "How to Get the Document Count in a Query Using Formula Variable with Processing Type Replacement Path".
This works fine in many cases, but if a document is deleted, this will still be counted and the result will therefore be incorrect. This is my problem and I cannot compress the InfoCube after each load (which would solve the problem), as I am also using the BWA which then requires a full delete/fill after each load to be aligned with the compressed InfoCube.
I therefore need some other solution for the counter and I have tried using query conditions to supress the empty lines, but this only works for certain drill-downs (and of course I want the counter to be correct always, regardless of drilldown).
Does anybody have any suggestion on how to solve this?
Thank you in advance,