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

Planning Analyze not working

Received Response
9
Views
2
Comments
edited May 21, 2019 8:58AM in Essbase 2 comments

Summary

Planning Analyze not working - " Ad hoc grid can not be opened as there are no valid rows of data"

Content

Hello,

After the May update we noticed an odd behavior when trying to ad-hoc analyze some specific forms. Both users and administrator are receiving the following error: " Ad hoc grid can not be opened as there are no valid rows of data". I made sure the Suppress Missing Rows / Columns / Suppress Blocks are cleared. Is happening even when trying to ad-hoc analyze a form that has data on it. 

We tested out on Excel 2016 64- bit and Office 365. We tested with the following versions of SmartView: 11.1.2.5.900 and 11.1.2.5.810.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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