When using Smartview in Excel, the first step is to create a connection using a connection manager：
1) you provide the Provider -> Hyperion Provider.
2) you provide the location -> yourservername/hfmofficeprovider/hfmofficeprovider.aspx
3) you select the Cube(You will be prompted for an userid and password)
4) you name the Connection and provide a description. Example of Connection Name: HFMProt Description Example: HFM Prototype
The name you create on the fourth step is your connection Name; This name is the one you use in the HSGETVALUE formula. Using my Example:
HSGETVALUE("HFMProt", "yourstring")
Then you just create multiple connections to multiple cubes.
The HsGetValue function retrieves data from a data source for the dimension members that you
specify. You can specify all dimension members. Any member not specified is considered a
default POV member and uses the default in the POV Manager.
When users select Refresh or Refresh All, only HsGetValue is called. When users select Submit,
HsSetValue is called first, HsGetValue is then called only if HsSetValue returns sucessfully.
The syntax is as follows:
HsGetValue (“Connection”,”POV”)
Here are two examples:
The function in the following example returns the value from the HFM01 application for the
default Point of View.
Example 1:
HsGetValue(“HFM01”,”Scenario#Actual;Year#2004;Period#July;View#YTD;
Entity#UnitedStates.Connecticut;Value#USD;Account#Sales;ICP#[ICP
None];Custom1#GolfBalls;Custom2#Customer2;Custom3#[None];Custom4#
Increases;”)
The function in the following example returns the value from the HE application for the default
Point of View.
Example 2:
HsGetValue(“HE01”,”Scenario#Actual;Period#July;View#YTD;函数prototype
Entity#UnitedStates.Connecticut;Account#Sales;”)

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。