I just started working with Cognos Express Architect and have the following question.
I build a cube with 3 dimensions; Period - Administration and Persons
The Person dimension is the measure dimension and has the following elements:
Total_Number_Employee, Hours_available, Count_Total_Employee, Average_Employee
By day/month/quarter I want to have the average of the amount of Employees.
I use the following rule to put a temporary field on 1:
['Count_Total_Employee'] = N: IF (['Total_Number_Employee']<> 0,1,0);
['Average_Employee'] =C:['Total_Number_Employee']\['Count_Total_Employee'];
I seems the Count_Ttotal_Employee is increase the value with the elements in the Administration dimension.
Simply I want to haven the following result
Value Total_number_Employee on 01/01/2012 is 100
Value Total_number_Employee on 02/01/2012 is 100
Value Total_number_Employee on 03/01/2012 is 100
Value Total_number_Employee on 04/01/2012 is 100
Value Total_number_Employee on 05/01/2012 is 100
Value Total_number_Employee on 06/01/2012 is 100 till
Value Total_number_Employee on 31/01/2012 is 100
Consolidated January Total_number_Emlpoyee is 3100
Value Average_Employee on 01/01/2012 is 100
Value Average_Employee on 03/01/2012 is 100
Value Average_Employee on 03/01/2012 is 100
Value Average_Employee on 04/01/2012 is 100
Value Average_Employee on 05/01/2012 is 100
Value Average_Employee on 06/01/2012 is 100 till
Value Average_Employee on 31/01/2012 is 100
Consolidated January Average_Employee should be 100 !!!!
Quit simple perheps
![Embarrassed :oops:](./images/smilies/icon_redface.gif)