Analytics Software

Hi all,

I am trying to retreive a ad hoc report and getting Essbase Error 1130001. I have figured out what is causing this Error but not able to find a solution for it. There is a sparse dimension "HP" which has total 823 members and 549 stored

members. The top level member of the dimension is stored and the rememing descendants are marked as Dynamic Calc.

HP (Name of the Dimension) (Stored) (Gen 1)

A_1000(Dynamic Calc) (Descendant of HP) (Gen 2) (Consolidation sign +)

B_2000(Dynamic Calc) (Descendant of HP) (Gen 2) (Consolidation Sign ~)

So there are many more descendants to Gen 2 as well till it gets down to Level 0. If i retreive the spreadhseet at member "HP" i am able to reteive it but if i Reteive at A_1000 i get this Essbase Error. My guess is this is memory Error and Is there a way i

can get rid of this Error by incresing some Dynamic calc cache size? If yes which cache settings should i increase and by how much?

All my Users are assigned security at A_1000 and i cant assign them security at "HP" as thats the dimension name itself so would have to assign them administrator rights to access that member in Hyperion Planning.

Please advise!

Thanks!