Mapping Accounts with Host Analytics newest feature AirliftXL is the fastest and most efficient way to map a large number of accounts on Global Template Single Copy (GTSC) budget templates. This article provides a walkthrough on building a Host Analytics GTSC budget template using the Excel add-in AirliftXL.
1) Install the AirliftXL Excel add-in by following the instructions at the Host Analytics Help site. If you have already installed the Excel add-in, proceed to step 2.
2) Set up the properties and details of your GTSC budget template in AirliftXL using guidance from the Host Analytics Help Site. After setting this up, we can input the line items of your GTSC budget template in the template layout section. The segments with a segment source of “Template” will be the segments we map using AirliftXL for destination accounts.
3) In order to map reference accounts and reference cube accounts using AirliftXL, the template property “Enable RA/RC Mapping” must be set to “Yes”. After clicking the Update button, the “RA/RC Mapping” needs to be set to “Template”. Then click Update once more to see the “Map/Template” column.
4) Copy and paste the “L” in the first row to as many rows below it as needed for your template. This copies the drop down list for selecting the line type to each row in your template.
5) After selecting the type for each line, all L, C, L-Hist, and C-Hist lines that require a destination account mapping or RA, RC, and RA-Mult lines that require a reference account/cube mapping can be mapped with AirliftXL by copying and pasting segment members from the segment tab to the corresponding line/column on the template tab. You can select different dimensions from the drop down list on the segment tab to copy and paste any remaining dimensions you need to map.
For more information on each line type, you can reference the following table from the Host Analytics Help site.
Line Type Table
|L||The row is designated as a Line Item.|
|C||The row is designated as Calculated. These types of rows contain calculations.|
|H||The row is designated as a Header. A header row can represent a blank or header row.Note. Supported mapping fields for H line types include; Code, Name, and Line Type.|
|RA||The row is designated as a Reference Account.|
|RC||The row is designated as a Reference Cube.|
|L-HIST||Replaces destination mapping available in the Host Analytics application. An L-HIST line identifies that line as a destination account. Destination accounts contains segment mapping details. For example, you might map accounts to pull history data.The destination history row line item type follows the associated line item row. You can have multiple L-HIST lines associated with a single L posting line. The All option is supported in the segment selections.|
|C-HIST||Behaves the same as the L-Hist line type.. The destination history row line type follows the associated C (calculated) line item row. You can have multiple C-Hist lines associated with a single C-HIST line.|
|RA-MULT||Replaces reference account mapping available in the Host Analytics application. This line type will be required if there are multiple references for a single RA line in a template. For example, if you are referencing multiple payroll accounts associated with salary (salary, bonus, overtime) you will achieve this with a single RA line referencing salary and then two additional RA-MULT lines referencing bonus and overtime.The RA-MULT reference account row follows the associated RA reference account row. You can have multiple RA-MULT lines associated with a single RA line. The All option is supported in the segment selections. Wildcards are supported on the Account segment for RA-MULT lines.|
6) Below is an example of a completed template with mappings for both destination and reference accounts.
7) The final step is to publish the completed template back to Host. Click the Admin button and select “AdminPublishTemplate” from the drop down list. Then select “Publish” for the template you want to publish back to Host and select “Run” under Admin Action.
The copy and paste function in AirliftXL provides a faster and more efficient way to map a large number of accounts on GTSC budget templates compared to the account mapping option within Host Analytics. As shown below in Host Analytics, the user has to select what type of account mapping they want from the “Mappings” menu. Then the user has to select each dimension from a drop down list. This must be repeated for each account the user maps.
The copy and paste function in AirliftXL eliminates this by allowing the user to map multiple accounts at once.