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

Copying data special values to dataform using VBA in smartview

edited Aug 2, 2018 2:36AM in Essbase 1 comment

Summary

Copying data special values to dataform using VBA in smartview

Content

Hello,

We have requirement where when a user enters datain excel sheet it needs to under go some calculations and this data should then be loaded to data form through smart view(As SOX control in process we can only load data through data form or FDM).So I created macro enabled sheet and integrated the data form with it.I am using below code to copy the calculated data from excel sheets and paste special values  to smartview form(data form) but somehow the formula is being copied into data form for certain cells(This is starting at cells F15 in data form).when I run

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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