Forum Stats

  • 3,750,407 Users
  • 2,250,174 Discussions
  • 7,866,970 Comments

Discussions

Essbase design and calc performance

User_7EQWL
User_7EQWL Member Posts: 3 Green Ribbon

we have BSO application in PBCS which is having 10-11 dimensions

Time(D)

Account(D)--19000+ members

Remaining all are Sparses here

Scaneario,Year,Version

Entity(35000membrs)

Spars5(34000+membrs)

Sparse6(34000+Membrs)

Sparse7(19000+Membe)

Sparse8(2000+Membrs)

dimension order is like

Time Account then lowest sparse to Highest Sparse dim

i am running one calc

SET UPDATECALC OFF;

SET FRMLBOTTOMUP ON;

fix( All sparse dimsll @lev0 and feb,mar..dec and @relative(Account,0))

(Sparse)memberA1= shift((sparse)X,-1));

endfix

Its taking Around 20 minutes

i tried with calcparellel but nopes..

is it due to having heavy/more members in Dimensions

do i need to change the dimension order?

how is lolipop model is it helps?

which is ggood one for above dims

help would be appriciated