Current Position:Home > Smart View - Excel Formulas

Smart View - Excel Formulas

Update:11-30Source: network consolidation
Advertisement
Hello -
New to the system, but wanted to know if there's a way to keep Excel formulas after refreshing in SmartView. Appears as though we lose the formulas after clicking the refresh icon.
Thanks in advance

The Best Answer

Advertisement
We have this issue as well. It has contributed to our startup with Smartview being very poor and given our implementation a bad name. In our experience, Smartview does not deal well with Formulas. We worked around this by using one tab to feed another with the correct formulas. In our experience, Smartview is OK on raw numbers but do not hope or epect it to output fully formatted excel reports.
In particular, Smartview, at least in our simple implementation, is very poor at mixing Excel formulas into a table.
  • Smart View - Excel Formulas Update:11-30

    Hello - New to the system, but wanted to know if there's a way to keep Excel formulas after refreshing in SmartView. Appears as though we lose the formulas after clicking the refresh icon. Thanks in advanceWe have this issue as well. It has contribut

  • Some users not seeing all of a web form in Smart View Excel 11.1.2? Update:10-11

    I am on Planning 11.1.2 and I have an end user who, when he opens a web form in Excel using Smart View, he only sees about 1/3 of the entire form. If in the Oracle/Planning web, the form is fine. When he uses my machine, he sees the entire web form i

  • Smart View/Excel A document with the name 'HsTBar.xla' is already open Update:10-11

    I got this error message when starting Excel. The following fixed it: 1. Deleted shortcuts to HsTBar.xla in Documents and Setting 2. Disabled Smart View in Hyperion > About 3. Unchecked Hyperion Smart View for Office in Tools > Addins 4. Quit Excel

  • 64-bit Smart View + Excel 2010 64-bit Issues - Help Please Update:11-30

    Hello everyone. First, I am not an "IT guy" so please bare with me as I am not technical but need help. I am running Windows 7 64-bit Professional and Excel 2010 64-bit. I installed Oracle Smart View for Office, Fusion Edition 64-bit as an add-i

  • Smart view -excel addin Update:11-30

    they does the same retrieval just want to know whats the difference between excel addin and smart viewSmart View works with all of the office products not just Excel and is the replacement for the Add-in. Smartview uses Web Services (APS) while the a

  • Smart View Excel Add-in for Hyperion Enterprise 6.5 Update:11-30

    Hi All, I'm trying add a data source connection directly in Connection Manager and my data source provider is Hyperion Enterprise. In the Install manual it mentions the following URL syntax for Hyperion Enterprise http://<servername>/heofficeprovide

  • Smart View deleting formulas on refresh Update:10-11

    Hi everyone, We're using SV 11.1.1.3.00 to pull info into excel 2003, and I'm trying to understand the do's and dont's when refreshing the data. At this point, I'm not sure if that's just the way it is, or something else - On an initial refresh with

  • Excel Taking time to open after installing Smart View Update:11-30

    Hi, After installing Smart View excel is taking around 2 minutes to open. We just launch Excel and it takes two minutes to open. We don't connect to the planning server. Then when Excel responds, the smart view plugin works fine, we can connect to th

  • Error entering data in a data form using Smart View Update:10-11

    One of my user is facing an issue while entering data in a data form through Excel, if she uses the same data form in workspace she is able to enter data. She is facing the issue while entering in a specific column, for all other columns she is able

  • Excel Formulas - Smart View Update:11-30

    Hello - New to the system, but wanted to know if there's a way to keep Excel formulas after refreshing in SmartView. Appears as though we lose the formulas after clicking the refresh icon. Thanks in advanceWhen the Change Alias Table is set to Defaul