hyperion

  1. Y

    Automatic smart view hyperion refresh with VBA

    maybe someone could help me to understand, what I'm doing wrong, as I'm stuck.. In general, I have a process, where I have an .vbs file, that triggers macro file, which makes connection to Hyperion and refreshes sheets. For some reason, when I'm triggering that macro, it always asks me to enter...
  2. Y

    Automatic smart view hyperion refresh with VBA

    maybe someone could help me to understand, what I'm doing wrong, as I'm stuck.. In general, I have a process, where I have an .vbs file, that triggers macro file, which makes connection to Hyperion and refreshes sheets. For some reason, when I'm triggering that macro, it always asks me to enter...
  3. R

    Issues With Running xlsm files with Hyperion Add-In

    I have created Microsoft Excel Macro Enabled (xlsm) files containing 195 lines of VBA code (teo subroutines, two functions) and total file sizes ranging from 162 kb to 205 kb. The files run perfectly on my computer but when my boss runs it, it takes twice as long and then the screen freezes...
  4. W

    Need Help Combining Hyperion Smart View with VBA

    I'm working with Hyperion Smart View and was wondering if anyone knew of the VBA add ons that would allow me to refresh and drill in data? Below you'll see the code I'm working on. Currently I'm using SendKeys to accomplish the two tasks as you'll see below. What's a better way to do this...
  5. M

    Smart View, consolidate all

    Hi guys,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> 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...
  6. E

    Hyperion Retrieve and Loading One Sheet at a Time

    Hi - I've got a workbook that I load/refresh on multiple sheets. I want to load each sheet separately. Right now, every time I export, the entire workbook exports up into Hyperion Enterprise. How do I change this? Is this something I can change? I have other workbooks with a similar setup...
  7. K

    Hyperion Data Retrieving and Cell Data issue

    Hello erveryone! For those who know it, I'm using Hyperion to retrieve sales data from a database. Everything works fine exepted that hyperion fills < '0 > instead of < 0 > when the data is not available (most of the time it means 0). The problem is the following, I use formulas that test...
  8. M

    Delay for SendKeys, TsTom?

    Hi! I am using Sendkeys for Hyperion Planning Excel Add-In User Interface in order to automate retrieving data from the database. Sometimes the UI is too slow and I'd need a little pause between Sendkeys commands. The most helpful solution was provided by TsTom year 2003 in this Forum, see...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top