Namaste!
Hyperion Essbase has got many features to enhance the multi-dimensional reporting functionality.
In some of the cases few budgeting departments in an organization would require to have a separate database dedicated for their department/cost centre due to the sensitive nature of the data.
For example Payroll department may have to budget the payroll expanses using drivers like employee, grade, department etc. This budget data would have to be secured and not visible to all
other department budget owners.
Also the granularity of employee or grade wise budget would cause more sparsity and result in bigger
database/cube size. All these reasons may add up to take a call on allocation of separate database/cube for payroll budgeting.
However for a consolidating reporting purpose, it would be necessary to bring back the total payroll
cost to main database/cube.
@XREF is the most popularly used feature to transfer the data from one database/cube to another
database/cube.
I have put together a video to demonstrate the XREF functionality of Hyperion Essbase.
Happy Learning!
I have published an Advanced course on Hyperion Essbase on Udemy. Here is the coupon code. Please check it out if you are interested.
https://www.udemy.com/course/hyperion-essbase-advanced-course/?couponCode=ESBADV9
Hyperion Essbase has got many features to enhance the multi-dimensional reporting functionality.
In some of the cases few budgeting departments in an organization would require to have a separate database dedicated for their department/cost centre due to the sensitive nature of the data.
For example Payroll department may have to budget the payroll expanses using drivers like employee, grade, department etc. This budget data would have to be secured and not visible to all
other department budget owners.
Also the granularity of employee or grade wise budget would cause more sparsity and result in bigger
database/cube size. All these reasons may add up to take a call on allocation of separate database/cube for payroll budgeting.
However for a consolidating reporting purpose, it would be necessary to bring back the total payroll
cost to main database/cube.
@XREF is the most popularly used feature to transfer the data from one database/cube to another
database/cube.
I have put together a video to demonstrate the XREF functionality of Hyperion Essbase.
Happy Learning!
I have published an Advanced course on Hyperion Essbase on Udemy. Here is the coupon code. Please check it out if you are interested.
https://www.udemy.com/course/hyperion-essbase-advanced-course/?couponCode=ESBADV9
java online course
ReplyDeletesalesforce online course
hadoop online course
Data Science online course
linux online course
etl testing online course
web methods online course
business analyst training
I am well pleased for the opportunity to have through your blog. I have learned something new and great from your blog. Discover online photo editing course. We put special emphasis on comprehensive learning with practical application and industry training. Students acquire a deep knowledge and will learn concepts like Adobe Photoshop CC, Adobe Camera Raw interface and study different layers of operation and much more. This graphic design in hindi is for someone who wants to become an expert in all the aspects of Web and Photo Editor. It’s a professional course to make a student ready for the job.
ReplyDeletefreelance ui ux designer