Which of the following methods supports formulas like HsGetValue to retrieve FCCS data in Smart View?

• A. Function Builder
• B. Ad Hoc Query
• C. Pivot Table
• D. Data Harvest

Answer: (A)

HsGetValue is a Smart View retrieval formula used to pull FCCS data directly into an Excel worksheet. The Function Builder is the tool designed to create these retrieval formulas, guiding you through selecting the FCCS data source, dimensions, and members, and then constructing the HsGetValue syntax correctly. This makes Function Builder the appropriate way to build formulas like HsGetValue.

Ad Hoc Query, Pivot Table, and Data Harvest serve different purposes: Ad Hoc Query retrieves data into a grid without building retrieval formulas; Pivot Table analyzes or summarizes data once it’s retrieved; Data Harvest is for loading data into FCCS from external sources.