Dayalan Punniyamoorthy Blog

Friday, December 30, 2016

Loading data into PBCS ASO using Smart-view HsSetValue & HsGetValue!!!

Let me cover a simple one this time, how to load data to a ASO cube using smart view in PBCS using HsSetValue & HsGetValue

Just make sure the following statements are true before the load

The Level 0 members are selected for the data load for all the dimension’s part of the ASO cube

As we all know we can’t load the data to a dynamic calculated members and attribute members

As per the document

HsGetValue

Data sources: Oracle Hyperion Financial Management, Oracle Essbase Cloud, Oracle Hyperion Planning, Oracle Planning and Budgeting Cloud, Oracle Enterprise Performance Reporting Cloud

HsGetValue retrieves data from the data source for selected members of a dimension. When HsGetValue retrieves no data, the value specified for the #NoData/Missing Label replacement option is used (see Table 1). 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 successfully.


Syntax Private connection:
HsGetValue("PrivateConnectionName","POV")

Shared connection:
HsGetValue("WSFN|ProviderType|Server|Application|Database","POV")


HsSetValue


Data sources: Oracle Planning and Budgeting Cloud

HsSetValue sends a data value from a worksheet to a data source selected members of a dimension. To send data to a data source, you must have the appropriate load rule and write access for the data source.

Syntax Private connection:
HsSetValue (dollar amount,"PrivateConnectionName","POV")

Shared connection:
HsSetValue (dollar amount,"WSFN|ProviderType|Server|Application|Database","POV")


Complete POV is built for the data load by accessing the individual cells and the value of cell Z22 will be loaded.
  
 =HsSetValue(Z22,"WSFN|HP|planning-test-server.pbcs.us2.oraclecloud.com|Vision|ASORpt","Account#"&BM$22&";Period#"&BN$4&";Years#"&BN$3&";Scenario#"&BN$2&";Version#Working;Currency#AED;Entity#"&BO$3&";Center#0000;Product#"&BP$4&";Ledger#"&BP$2&";Analysis#Main")

Once the data is loaded it can be validates using the formula

=HsGetValue("WSFN|HP|planning-test-server.pbcs.us2.oraclecloud.com|Vision|ASORpt","Account#"&BM$22&";Period#"&BN$4&";Years#"&BN$3&";Scenario#"&BN$2&";Version#Working;Currency#AED;Entity#"&BO$3&";Center#0000;Product#"&BP$4&";Ledger#"&BP$2&";Analysis#Main")

Hope this is useful!!!








No comments:

Post a Comment