Search found 6 matches
- Fri Jul 06, 2012 7:25 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Average by month
- Replies: 9
- Views: 5209
Re: Average by month
Dear Tomok, Thanks for youre reply. Unfurtunally your solution is not given me the result I wanted. I get the same results as shown in de previous screenshot_cube/pdf. In my example I expect a value of 1 in the field but It seems I get the count of the total of administrations. Changing this in the ...
- Thu Jul 05, 2012 10:07 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Average by month
- Replies: 9
- Views: 5209
Re: Average by month
Hello, To get the result as I wanted I created the rule shown in the attachtment. I presume there should be a much easier way to get this result. Another question, I just want to put a value of 1 (numeric) in the D0229 field if there is a result on that day in the measure Aantal_DTF Thanks in advanc...
- Wed Jul 04, 2012 3:11 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Average by month
- Replies: 9
- Views: 5209
Re: Average by month
Dear, Hereby the example. The cube is in Dutch. But the explanation is as followed Aantal DTF = Total_number_employee Berekend_aantal_DTF = Average_Employee Aantal_DTF_Count = Count_Total_Employee I expected 1 in the Count_Total_Employee on the 01/01, 02/01 and 03/01 and the value 3 on januari. Your...
- Wed Jul 04, 2012 2:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Average by month
- Replies: 9
- Views: 5209
Re: Average by month
Dear Declanr, Unfortunally this doesn't work. In my example Count_Total_Employee is the extra measure field. I expect a value of 1 in this field but It seems I get the count of the total of administrations. Changing this in the outline will change the value of the filed Count_Total_Employee. Regards...
- Wed Jul 04, 2012 1:43 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Average by month
- Replies: 9
- Views: 5209
Average by month
Dear all, 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_Empl...
- Wed Mar 28, 2012 8:36 am
- Forum: Hyperion Essbase & Shared Services
- Topic: view lost database connection
- Replies: 3
- Views: 47972
view lost database connection
Dear all, My first post on this forum. I created a map in TM1 (names reports). In this map I create 11 views, (all connected to one database) I did this last week and had no problems with opening those views. Since yesterday 8 of the 11 views has no database connection anymore. The first 3 reports w...