# Managing Application Cost Catalog

The Application Cost page contains various functionalities to manage the application cost catalog for chargeback.

# Adding a Record

1. In the Application Cost table, click the () add icon.

2. For the Type, Vendor License, and Name columns, double-click the corresponding empty cell to transform it into a text editor.

3. Type in the value or choose among the suggested options.

   A list of all related data will be displayed while typing if data is processed and available.

   The application type in the Type column are commonly Feature, Feature Set, Package, Handle, etc.

4. Choose among the available values for Unit:

   Unit	Description
   DU 1H	Number of distinct user per hour
   DU 1D	Number of distinct user per day
   DU 1M	Number of distinct user per month
   ET 1H	Total number of elapsed time per hour
   ET 1D	Total number of elapsed time per day
   ET 1M	Total number of elapsed time per month
   MC-UG 1H	Maximum concurrent license used per user group per hour
   MC-UG 1D	Maximum concurrent license used per user group per day
   MC-UG 1M	Maximum concurrent license used per user group per month

   Application Cost: Units
   
   

5. Use the following description to properly provide values for the Unit Cost, Fixed Cost, and Units Included columns:

   Column	Description
   Unit Cost	The price of the application per unit.
   Fixed Cost	The fixed price of an application for the whole billing period.
   Units Included	The limit before charging based on Unit Cost. If the usage is less than or equal to Units Included, it is covered by the Fixed Cost.

   Application Cost: Cost Columns

6. Choose the date ranges for the validity of the record.

   • Valid From - start of the validity
   • Expired On - end of the validity
   
   

   

   Analysis Server Application Cost: Adding a Record
   
   

7. You can continue adding more record by clicking the () Add icon.

   Use the Undo and Redo options to revert unsaved modifications. The Undo option can revert until the last unsaved modification, while the Redo option can restore up to the current modification.

8. Once done, click the Save icon. Choose OK on the confirmation prompt to continue.

   

   Analysis Server Application Cost: Added a Record
   
   

# Updating a Record

1. In the Application Cost table, click the row of the record to update then click the Edit icon, or double-click the value of the record to transform it into a text editor.

2. Modify the values. Repeat the procedure to update all desired values.

   Use the Undo and Redo options to revert unsaved modifications. The Undo option can revert until the last unsaved modification, while the Redo option can restore up to the current modification.

3. Once satisfied with the modifications, click the Save icon. Choose OK on the confirmation prompt to continue.

   

   Analysis Server Application Cost: Updating a Record
   
   

# Deleting Records

1. In the Application Cost table, click the row of the record to delete.

   To select multiple records:

   • Select the first record, press the Shift keyboard key, then select the last record to include all consecutive records.
   • Select any record, press the Ctrl keyboard key, then select multiple records.
   
   

2. Click the Delete icon or the Delete keyboard key. The selected item(s) will be removed in the list.

   

   Analysis Server Application Cost: Deleting a Record
   
   
   Use the Undo and Redo options to revert unsaved modifications. The Undo option can revert until the last unsaved modification, while the Redo option can restore up to the current modification.

3. Once done, click the Save icon. Choose OK on the confirmation prompt to continue.

# Importing Records

1. In the upper-right corner of the Application Cost table, beside the search bar, click the Import Data from Excel icon.

2. In the Import Costs dialog, click Download Template.

   This downloads an Excel template you can use to store application cost information.

   

   Analysis Server Application Cost: Downloading the Template
   
   

3. Open the downloaded template and fill in accordingly.

   Validations are predefined in the template. Once done, save and close the file.

   

   Analysis Server Application Cost: Template
   
   

4. Go back to the Application Cost page and click the Import Data from Excel icon. Select Browse to look for the Excel file.

   A check icon beside the file name indicates that the file is valid.

5. Choose among the Insert type:

   • Append - adds items from the Excel file to the existing items in the Application Cost table
   • Replace - deletes the existing items in the Application Cost table and replaces them with the imported records from the Excel file

6. Click Upload to continue.

   If Replace is selected, choose OK on the confirmation prompt to continue.

   

   Analysis Server Application Cost: Importing Records
   
   

# Exporting Records

1. In the upper-right corner of the Application Cost table, beside the search bar, click the Export Data to Excel icon.

   

   Analysis Server Application Cost: Exporting Records
   
   

This downloads an Excel file containing all data in the Application Cost table. This file can also be used to import records.