Copying and Pasting HsGetValue Functions
You may copy cells and ranges of cells containing the HsGetValue function from one Office application and paste them into Excel, Word or PowerPoint.
Note these guidelines when copying and pasting functions:
-
Only cells containing the HsGetValue function may be copied and pasted. You may not copy and paste cells containing other functions.
-
The data point generated will use the connection-level alias.
-
Any cell references in the function will be replaced with its evaluated values. For example, if a function contains
"Year#""&A2&""
for the dim#member combination, and cell A2 contains"Qtr2"
, then the function generated will have"Year#Qtr2"
as the extracted value. -
Any POV changes applied on the data point query from the POV Manager will be applied only to the dimensions not present in the data point.
-
Function XML may be exported from legacy applications.
-
The following copy/paste scenarios are supported:
-
Functions from a single connection with no cell references.
-
Functions from a single connection with cell references.
-
Functions from multiple connections
-
Visualize in Excel—a grid with single intersection will be generated using the function POV.
-
Functions with case insensitive connection names.
-
-
The following copy/paste scenarios are not supported:
-
Functions from an ad hoc grid (these will be pasted as static values).
-
Nested formulas.
-
Formulas with arithmetic operations; for example, divide or multiply.
-
Other Excel functions; for example, IF or SUM.
-
To copy and paste functions: