Creating Functions Manually

You can create functions manually in Smart View.

To create a function manually in Smart View:

1. Connect to a data source.
2. In the Smart View Home panel, select a cube by clicking in the empty area next to the cube name.
3. Right-click the cube, select Set as Connection for Functions, type a name for the connection, and then click OK.

   In the below example, the connection name is MyVision.

   Figure 14-6 Connection Name

   
   
   

   Note:

   You must create a connection name for each new spreadsheet.

   The connection name is saved with the spreadsheet. When you reopen the saved spreadsheet, you will not be prompted to enter a connection name.

4. In the sheet, click the cell in which you want to enter the function.
5. Enter an equals sign and then type the function name; for example:

   =HsSetValue

6. Enter parameters for the function according to rules described in Syntax Guidelines, using the information specific to each function in Function Descriptions.
7. To add functions to other cells in the sheet, repeat steps 4 through 6
8. To run the functions, refresh the sheet.

   Functions are validated only upon refresh.

   If any function is invalid, then all functions on the sheet, including valid functions, will display #Error. For example, an invalid dimension or member name will result in an invalid function.

   Review the functions for errors and refresh the sheet again.