No. of Sparse Members in Planning Form

HFar

Hi All,

We have a requirement to build Budget Model Employee Wise in Hyperion BSO Application.

Can anyone please guide whether it is possible to map Client's requirement. Dimension Structure Required is as follow:

There are 3000 employees in a separate Workforce Dimension in Rows.

Period Dimension in Column.

Page View have following Dimensions with all having Dynamic Calc Members.

1 - Cost Centers Dimension, (100+ Members)

2 - Grade Dimension, (50 Members)

3 - Employee Type Dimension, (10 Members)

4 - Entity Dimension (10 Members)

Thanks in Advance for assistance.

Regards

HF

Julien Mallet

Then it's because too many dyn calc upper level members certainly have an impact on performance. Try to make one of the 3 dims stored and aggregate it.

Julien Mallet

Hi,

Well it would not be very difficult for you to test it, but it should be alright. 3000 rows by 12 periods that's 36k cells, and I think we can assume you will be using suppress missing rows and in most cases not all employees will have data.

HFar

Thank you.

But form is not responding even with 500 employees in rows and 3 dynamic calc members in Page view.

Any help?

Thanks

Julien Mallet

Then it's because too many dyn calc upper level members certainly have an impact on performance. Try to make one of the 3 dims stored and aggregate it.

HFar

Thank you Mr. Mallel,

We have made 1 dimension parent as Store. Still form got stuck. Any idea?

Julien Mallet

Is it stuck or is it just slow? Have you looks at the planning log? and Essbase log? Are you by chance using an old version of IE?

HFar

Well it is struck.. Process was ended in easconseole sessions. We are still checking how to make that form open.

adnan645

A dynamic parent can efficiently add 100 children it as per my experience. you have 3000 employees. Try their parent to set on store. The second thing you can see is if there are 4 dimensions in page that are using dynamic calc, then spreadsheet operations start at the back end and they don't stop.

Mishra Chandan

Hi

If Cost Center is on page and Employee is in row then can you try suppress function in the form. I hope it will work,

Regards,

Chandan M