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

Smart View Client 720

edited Aug 2, 2018 2:42AM in Essbase 2 comments

Summary

Wipe out Formula with Hard code member

Content

Hi,  

I am using Excel 2016 and currently using smart view client 710.  I created a report that uses formula to pick up member for refresh.  Example, I have a sheet that allows user to select the year they wanted to view the data and the smart view report will have a link to that input that picks up the year.

For users that are using client 710, they have no problem refreshing this report.  But for users who are using smart view 720, they notice that weird things happen when they refresh it.  The cells that contain the formula will either change (example from $C$

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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