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.
