Hyperion Planning aggregation time

Hyperion Planning aggregation time

Joined: November 25th, 2011, 3:27 pm

November 25th, 2011, 3:56 pm #1

Dear ,
We have build 4 applications which have the following DB size
AP 1:90GB,base data 23MB, block size 64K,0level blocks 603.330,upper level blocks 72.132K , density 0.17%
AP 2:90GB,base data 53MB, block size 40K,0level blocks 30.203, upper level blocks 54.668K, density 4.36%
AP 3:33GB,base data128MB, block size 315K,0level blocks 390518, upper level blocks 11.516K, density 0.05%
AP 4:14GB,base data 19MB, block size 32K,0level blocks 35.280, upper level blocks 9.216, density 0.00..%
Outline : App 1
Dim Type S.Mem
1 D 146
2 D 14
3 D 4
4 S 29
5 S 4
6 S 7
7 S 4
8 S 16
9 S 58
10 S 164
11 S 402
12 S 1339
13 S 4 (attr.)
14 S 4(attr.)
15 S 4(attr.)
Outline app 2 :
App2
Dim Type S.Mem.
1 D 122
2 D 24
3 D 4
4 S 4
5 S 4
6 S 9
7 S 18
8 S 29
9 S 59
10 S 93
11 S 163
12 S 412
13 S 1172
14 S 3 (attr)
15 S 3 (attr)
Outline app 3 :
App3
Dim Type S.Mem.
1 D 56
2 D 14
3 D 4
4 D 14
5 S 29
6 S 4
7 S 4
8 S 6
9 S 347
10 S 397
11 S 11.408
12 S 541
13 S 1058
14 S 3
15 S 7
16 S 11(a)
17 S 11(a)
18 S 4(a)
Outline app 4 :
App4
Dim T SMem.
1 D 63
2 D 24
3 D 5
4 S 3
5 S 5
6 S 4
7 S 4
8 S 29
9 S 24
10 S 47
11 S 58
12 S 71
13 S 994
14 S 3

Main problem : aggregation of ap 1 takes 8 hours, aggregation of ap 2 takes 6 hours, aggregation of ap 3 takes 6 hours, aggregation of a 4 takes 3 hours. DB size is growing continuously. We did not clean the DB from zero's since last 8 weeks.
For reporting purposes we installed ASO cubes but aggregations still needs , also, to be done in BSO Hyperion planning for end users.
Does anybody have experience in such large cubes -outlines , do you have suggestions to improve , can we improve aggregation performance without change structure of the DB any other suggestions to improve performance ?
Many thanks for your precious help ,
Christian

Reply
Like
Share

Cameron Lackpour
Cameron Lackpour

November 25th, 2011, 5:52 pm #2

Having said that, I'll throw out two questions:
1). Defragmentation -- as in do you ever do it?
2). Do you use focused aggs off of forms?

Regards,

Cameron Lackpour
Reply
Share

GlennS
GlennS

November 25th, 2011, 9:50 pm #3

I agree with Cameron, This is not something you can get an immediate response from. It is something that someoulw need to look at and analyze.
You mention you are using an ASO cube for reporting. Did you buy a full use Essbase license? If you just bought Planning, you don't have the authorization to use ASO cubes
Reply
Share

Joined: November 25th, 2011, 3:27 pm

November 26th, 2011, 7:37 am #4

Yes all essbase licenses are ok
Reply
Like
Share


Confirmation of reply: