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...

Some videos you may like

This Week's Hot Topics

Top