Archives of the TeradataForum

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

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

<-- 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>>