Excel add-in V9: Not able to drilldown
We recently upgraded from V7.4 to V9.1 and we’re seeing an issue with the Excel Add-In. A small group of users (about five) are unable to use the Drilldown feature (the option is completely greyed ou...
Forum Discussion
We just upgraded from 8.4 to 9.2, and suddenly whilst the Drilldown option is visible, the function no longer works ie it no longer seemed to connect to the signon application anymore. However if you open a CV in Excel and convert the functions to xfGETCells formulas, the drilldown function works.
It would appear that it no longer able to read the cell references and needed the xfgetcells formula to have POV dimensions "hardcoded" in the formulas and not referenced to other cells 😶. this is still under investigation for us.
We've had the same experience with 9.2 and logged this as a bug with OneStream. They are investigating and working on a fix for the next release. They did not provide any specific timing. A possible work-around is to create an Excel macro that converts the current XFGetCell formula to hardcode the POV members, and then you can use the drill. Not a great long-term solution.
Did they mention a issue reference? Its an issue for us as well, we can raise a ticket or something to help elevate the issue.
The bug number is PF8-3261
I just found out that this was "discovered" in January and I questioned them why it is not in the release notes as KNOWN bugs. It would appear they do not update release notes until the next version - by which it is too late for those who upgraded without knowing. So, now I am wondering, what other functions is not working in 9.2? 😬
oh, and all our reports are using XFGetCell formulas. The macro suggestion would not be ideal to convert ALL our reports. We rely too heavily on referenced cells.
