Search found 6 matches

by J.Donkers
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 ...
by J.Donkers
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...
by J.Donkers
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...
by J.Donkers
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...
by J.Donkers
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...
by J.Donkers
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...