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

Smartview Report HsgetValue to retain data when it is opened

in Planning 3 comments

Summary:

Smartview Report HsgetValue to retain data when it is opened by the user who does not have Oracle connection

Content (please ensure you mask any confidential information):

Hi,

I have build an Excel report in Smartview using HsGetvalue formula. Everything is working fine until I'm connected. When I try to save and share the report to the user, he does not see the data/numbers, instead sees #no CONNECTION. However, he can login and retrieve the data as he has access to Oracle Planning application on which the report is built.

However, his requirement is to share this report to the internal Audit team who does not have access to Oracle. They just want to see the numbers in the report. Is there a way to save the report in a different format to retain the data.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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