Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
No. of Sparse Members in Planning Form

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
Best Answer
-
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.
Answers
-
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.
-
Thank you.
But form is not responding even with 500 employees in rows and 3 dynamic calc members in Page view.
Any help?
Thanks
-
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.
-
Thank you Mr. Mallel,
We have made 1 dimension parent as Store. Still form got stuck. Any idea?
-
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?
-
Well it is struck.. Process was ended in easconseole sessions. We are still checking how to make that form open.
-
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.
-
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