Hi guys,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o></o>
I know this isn't the best place for this type of question, but thinking some of you may have come across this sort of this before. I'm using Smart View to retrieve data from Hyperion. I've built a VBA macro that completes a number of HFM functions which all work fine. <o></o>
<o></o>
My issue is that I need to either a) do a consolidate or b) a calculate & translate in order to get updated data. I want to do this in Excel VBA via Smart View VBA functions (already declared).<o></o>
<o></o>
I've used the following code<o></o>
sts = HypCalculate (Empty, Empty)<o></o>
sts = HypTranslate (Empty, Empty)<o></o>
<o></o>
I've used Empty as these functions need to calculate and translate data in the current worksheet. <o></o>
<o></o>
Any help is much appreciated!!!<o></o>
G<o></o>
fficeffice" /><o></o><o
></o>I know this isn't the best place for this type of question, but thinking some of you may have come across this sort of this before. I'm using Smart View to retrieve data from Hyperion. I've built a VBA macro that completes a number of HFM functions which all work fine. <o
></o><o
></o>My issue is that I need to either a) do a consolidate or b) a calculate & translate in order to get updated data. I want to do this in Excel VBA via Smart View VBA functions (already declared).<o
></o><o
></o>I've used the following code<o
></o>sts = HypCalculate (Empty, Empty)<o
></o>sts = HypTranslate (Empty, Empty)<o
></o><o
></o>I've used Empty as these functions need to calculate and translate data in the current worksheet. <o
></o><o
></o>Any help is much appreciated!!!<o
></o>G<o
></o>
