Hi,
I've just created in BO Designer 6.5 a derived table for the calculation of an aggregate function.
The table is structured in the following way (for example):
SELECT SUM(ColumnCount) AS Sum_Distinct_NDG
FROM (SELECT COUNT(DISTINCT cod_sample) AS ColumnCount
FROM table.sample) DTBL
In the derived table I have only one numeric column, and I can not put it in join with my fact table (table.sample).
I thought topopulate the derived table also with an "alias" of the "table.sample.cod_sample" to put them in join, am I right? Anyway... I don't know how to do it.
Can anybody help me to go on?
Thanks in advance
Riccardo