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

How to populate an Excel worksheet with output from HypQueryMembers function

edited Aug 2, 2018 2:36AM in Essbase

Summary

How to populate an Excel worksheet with output from HypQueryMembers function

Content

Hi. I'm trying to get the children of a member without having to do an ad-hoc and zoom. I am automating a report using VBA and want to make it as fast as possible. I tried using HypQueryMembers, but I can't get the members to show up in a worksheet or listbox. All I've been able to do is get the return code - 0 for successful and so forth. Does anyone have any idea how to get the actual output of the function? Below is my code as it stands right now.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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