Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

H function report - Manual sum rows showing #VALUE unless expand all hidden rows

edited Aug 2, 2018 2:36AM in Essbase 6 comments

Summary

H function report - Manual sum rows showing #VALUE unless expand all hidden rows

Content

Hi,

we are using excel 2016 and smart view version 610,

Ever since we started excel 2016, we started seeing new issues with our h function report from smart view.

Details of the connection source and most of the dimensions information were hidden in the first few rows of the report.  We hide those rows so that the report looks presentable for "screenshot".  In this report, we have rows that are manual sum of data such as subtotal of a group and grand total.

Before excel 2016, we just need to click "refresh all" and the report will get updated.  the subtotal and grand total will also picked up accordingly based on updated data.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!