Skip to Content
0
Former Member
Jun 09, 2009 at 12:10 PM

Generating Derived Table

33 Views

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