Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 02 Mar 2004 @ 14:05:12 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Unique Congnos Measures !!
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, March 02, 2004 08:07 -->

Hi All,

I'm stuck up at one pint. In the denorm table, I've month wise employee data & the month may contain more than one record for the same employee.

So, when I'm creating the cube in Transformer, is there any way that the employee_count ()measure) can be taken unique?

for example - one employee 'A' is involved in two projects in one month. So there are two records for employee 'A' in that month with different projects. Now If I want to see the no. of employees in that month, the measure counts the employee 'A' twice. Is there any way by which it should can count the employee just once? can we put some 'distinct' or 'group by' or 'Unique' conditions on measures.

Please note that I've to take the detailed data into the cube, which means, I don't want to put this condition at the IQD file level.

Any help in this regard would be appreciated.

Thanks



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016