Re: Real world issue: How to "split" queries in presence of record replication and replication sensitive aggregate functions ?

FreeData ha scritto:

Hi FreeData, thanks!

> Two options for you:
> 1. Make your dimension Type 1 which will remove duplicates.

Sorry? Not sure to get what you mean.

> 2. Remove your measure from your dimension.

hmmm, You must assume a programmer's perspective. Not a user's. The program must do what the user says not viceversa.

The terms of the problem are: given a set of tables and relationships and given a set of fields, possibly equipped with aggregate function, which result in the report, determine the correct split of relationships and the subqueries that will yield the desired result. You can see an implementation of that, for instance, in Business Objects (the well know BI program) [I believe that implementation fails under some conditions]

For instance in my example the first query is a wrong result. Report computation is actually wrong. The second query (a UNION of 2 subqueries) should be the best result, given the user request).

-P Received on Thu Sep 14 2006 - 14:59:02 CEST