{"id":263,"date":"2015-11-13T18:25:57","date_gmt":"2015-11-13T18:25:57","guid":{"rendered":"http:\/\/192.168.200.82\/?page_id=263"},"modified":"2023-01-13T11:58:50","modified_gmt":"2023-01-13T11:58:50","slug":"manage-kpi","status":"publish","type":"page","link":"https:\/\/help.bwtech.com\/?page_id=263","title":{"rendered":"Manage KPI"},"content":{"rendered":"<div id=\"toc_container\" class=\"no_bullets\"><p class=\"toc_title\">Contents<\/p><ul class=\"toc_list\"><li><a href=\"#MANAGE_KPI\"><span class=\"toc_number toc_depth_1\">1<\/span> MANAGE KPI<\/a><\/li><li><a href=\"#Overview\"><span class=\"toc_number toc_depth_1\">2<\/span> Overview<\/a><ul><li><a href=\"#How_to_use\"><span class=\"toc_number toc_depth_2\">2.1<\/span> How to use<\/a><ul><li><a href=\"#Single_vendortech_KPIs\"><span class=\"toc_number toc_depth_3\">2.1.1<\/span> Single vendor\/tech KPIs\n\u00a0<\/a><ul><li><a href=\"#Choose_a_network_element\"><span class=\"toc_number toc_depth_4\">2.1.1.1<\/span> Choose a network element\n\u00a0<\/a><\/li><li><a href=\"#Create_a_new_KPI\"><span class=\"toc_number toc_depth_4\">2.1.1.2<\/span> Create a new KPI\u00a0\n\u00a0<\/a><\/li><li><a href=\"#Edit_an_existing_KPI\"><span class=\"toc_number toc_depth_4\">2.1.1.3<\/span> Edit an existing KPI\u00a0<\/a><\/li><li><a href=\"#Export_a_KPI\"><span class=\"toc_number toc_depth_4\">2.1.1.4<\/span> Export a KPI\u00a0\u00a0<\/a><\/li><li><a href=\"#Delete_a_KPI\"><span class=\"toc_number toc_depth_4\">2.1.1.5<\/span> Delete a KPI\u00a0<\/a><\/li><li><a href=\"#Special_functions\"><span class=\"toc_number toc_depth_4\">2.1.1.6<\/span> \nSpecial functions<\/a><\/li><\/ul><\/li><\/ul><\/li><li><a href=\"#_Multivendor_KPIs\"><span class=\"toc_number toc_depth_2\">2.2<\/span> \u00a0\nMultivendor KPIs\u00a0<\/a><ul><li><a href=\"#Create_multivendor_KPIs\"><span class=\"toc_number toc_depth_3\">2.2.1<\/span> Create multivendor KPIs\u00a0<\/a><ul><li><a href=\"#NetChart_standard_formula\"><span class=\"toc_number toc_depth_4\">2.2.1.1<\/span> \nNetChart standard formula\u00a0<\/a><\/li><li><a href=\"#NetChart_customized_formula\"><span class=\"toc_number toc_depth_4\">2.2.1.2<\/span> NetChart customized formula\n\u00a0<\/a><\/li><\/ul><\/li><li><a href=\"#Editdelete_multivendor_KPIs\"><span class=\"toc_number toc_depth_3\">2.2.2<\/span> Edit\/delete multivendor KPIs\u00a0\u00a0<\/a><\/li><\/ul><\/li><li><a href=\"#Formula_Oracle_x_MySQL\"><span class=\"toc_number toc_depth_2\">2.3<\/span> Formula Oracle x MySQL\n\u00a0<\/a><\/li><li><a href=\"#Ceate_KPIs_importing_a_text_file\"><span class=\"toc_number toc_depth_2\">2.4<\/span> Ceate KPIs importing a text file\u00a0<\/a><ul><li><a href=\"#Export_KPIs\"><span class=\"toc_number toc_depth_3\">2.4.1<\/span> Export KPIs<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/div>\n<h1 style=\"text-align: center;\"><span id=\"MANAGE_KPI\"><span data-contrast=\"none\"><a id=\"CREATE A NEW KPI\"><\/a>MANAGE KPI<\/span><\/span><\/h1>\n<p>&nbsp;<\/p>\n<h1><span id=\"Overview\"><span data-contrast=\"none\">Overview<\/span><\/span><\/h1>\n<p><span data-contrast=\"auto\">Manage your own customized KPI directly in the interface or by importing a text file.<\/span><\/p>\n<h2 id=\"how-to-use\"><span id=\"How_to_use\"><span data-contrast=\"none\">How to use<\/span><\/span><\/h2>\n<p><span style=\"font-weight: 400;\" data-contrast=\"auto\">Log in to your NetChart account.<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" width=\"497\" height=\"508\" class=\"alignnone size-full wp-image-2884 \" src=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_6372691425a0c.jpeg\" alt=\"\" srcset=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_6372691425a0c.jpeg 497w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_6372691425a0c-294x300.jpeg 294w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_6372691425a0c-60x60.jpeg 60w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_6372691425a0c-147x150.jpeg 147w\" sizes=\"(max-width: 497px) 100vw, 497px\" \/><\/p>\n<h3 id=\"single-vendor-\/-tech-kpis\"><span id=\"Single_vendortech_KPIs\"><span data-contrast=\"none\">Single vendor\/tech KPIs<\/span><br \/>\n<span data-ccp-props=\"{&quot;134245418&quot;:true,&quot;201341983&quot;:0,&quot;335559738&quot;:40,&quot;335559739&quot;:0,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><\/h3>\n<p><span data-contrast=\"auto\">Learn how to create KPI formulas for single vendor\/tech.<\/span><br \/>\n<span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;201341983&quot;:0,&quot;335551550&quot;:1,&quot;335551620&quot;:1,&quot;335559685&quot;:0,&quot;335559737&quot;:0,&quot;335559738&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<h4 id=\"choose-a-network-element\"><span id=\"Choose_a_network_element\"><span data-contrast=\"none\">C<span class=\"TextRun SCXW247925647 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW247925647 BCX0\" data-ccp-charstyle=\"T\u00edtulo 3 Char\">hoose a network element<\/span><\/span><\/span><br \/>\n<span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;134245418&quot;:true,&quot;201341983&quot;:0,&quot;335551550&quot;:1,&quot;335551620&quot;:1,&quot;335559685&quot;:0,&quot;335559737&quot;:0,&quot;335559738&quot;:40,&quot;335559739&quot;:0,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><\/h4>\n<p><span data-contrast=\"auto\">Because KPI formulas are specific for each vendor\/tech, the first thing you need to do is choose a network element from the desired vendor\/tech.\u00a0<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;201341983&quot;:0,&quot;335551550&quot;:1,&quot;335551620&quot;:1,&quot;335559685&quot;:0,&quot;335559737&quot;:0,&quot;335559738&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">First, click on the <span style=\"color: #0000ff;\"><b>+<\/b><\/span><span data-contrast=\"auto\"> icon next to the desired vendor\/tech to see the network elements available. Select a network element to create a KPI from the desired vendor\/tech.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><\/p>\n<p><img loading=\"lazy\" width=\"750\" height=\"707\" class=\"size-full wp-image-2885 aligncenter\" src=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637269d102b4b.png\" alt=\"\" srcset=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637269d102b4b.png 750w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637269d102b4b-300x283.png 300w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637269d102b4b-60x57.png 60w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637269d102b4b-150x141.png 150w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/p>\n<p><span class=\"TextRun SCXW80401245 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW80401245 BCX0\">Select <span style=\"color: #0000ff;\"><b>Custom<\/b><\/span> <span class=\"TextRun SCXW80401245 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW80401245 BCX0\">&gt; <span style=\"color: #0000ff;\"><b>Manage <\/b> <\/span><span class=\"TextRun SCXW80401245 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"> <span class=\"NormalTextRun SCXW80401245 BCX0\">&gt;<\/span> <span style=\"color: #0000ff;\"><b>KPI<\/b><\/span><span class=\"TextRun SCXW80401245 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW80401245 BCX0\">.<\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" width=\"1191\" height=\"622\" class=\"size-full wp-image-2886 aligncenter\" src=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726bce9ef70.png\" alt=\"\" srcset=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726bce9ef70.png 1191w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726bce9ef70-300x157.png 300w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726bce9ef70-1024x535.png 1024w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726bce9ef70-768x401.png 768w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726bce9ef70-60x31.png 60w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726bce9ef70-150x78.png 150w\" sizes=\"(max-width: 1191px) 100vw, 1191px\" \/><\/p>\n<h4><span id=\"Create_a_new_KPI\"><a id=\"create-a-new-kpi\"><\/a>C<span class=\"TextRun SCXW247392346 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW247392346 BCX0\" data-ccp-parastyle=\"heading 3\">reate a new<\/span><span class=\"NormalTextRun SCXW247392346 BCX0\" data-ccp-parastyle=\"heading 3\"> KPI<\/span><\/span><span class=\"LineBreakBlob BlobObject DragDrop SCXW247392346 BCX0\"><span class=\"SCXW247392346 BCX0\">\u00a0<\/span><br class=\"SCXW247392346 BCX0\" \/><\/span><br \/>\n<span data-ccp-props=\"{&quot;134245418&quot;:true,&quot;201341983&quot;:0,&quot;335559738&quot;:40,&quot;335559739&quot;:0,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><\/h4>\n<p><span data-contrast=\"auto\">Set the KPI properties following the steps below:<\/span><\/p>\n<p><img loading=\"lazy\" width=\"1380\" height=\"465\" class=\"size-full wp-image-2887 aligncenter\" src=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c13448b5.png\" alt=\"\" srcset=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c13448b5.png 1380w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c13448b5-300x101.png 300w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c13448b5-1024x345.png 1024w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c13448b5-768x259.png 768w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c13448b5-60x20.png 60w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c13448b5-150x51.png 150w\" sizes=\"(max-width: 1380px) 100vw, 1380px\" \/><\/p>\n<p><span data-contrast=\"auto\"><strong>1-<\/strong> Select <span style=\"color: #0000ff;\"><b>New<\/b><\/span><span data-contrast=\"auto\"> to make sure all the fields are empty and ready to be filled.<\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span data-contrast=\"auto\"><strong>2-<\/strong> Define who can see the created KPI. Select <span style=\"color: #0000ff;\"><b>Public<\/b><\/span><span data-contrast=\"auto\"> to make it visible to anyone.<\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span data-contrast=\"auto\"><strong>3-<\/strong> Write the KPI ID. The ID is a short exclusive text to identify the KPI for the vendor\/tech selected.\u00a0 Ex.: <\/span><b><span data-contrast=\"auto\">Ava_sr<\/span><\/b><span data-contrast=\"auto\"> could be the ID for an Availability success ratio KPI.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\"><br \/>\n<span style=\"color: #ff0000;\"><b><br \/>\nNOTE: <\/b><\/span> Spaces will be replaced by _ and other special characters will be removed.<br \/>\n<\/span><\/p>\n<p><strong>4-<\/strong> Write the KPI name. The name is a more descriptive text. Ex.: <b><span data-contrast=\"auto\">Availability success ratio<\/span><\/b><span data-contrast=\"auto\">.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span data-contrast=\"auto\"><strong>5-<\/strong> Choose <span style=\"color: #0000ff;\"><b>GOOD<\/b><\/span> if the bigger the value, the better, or <span style=\"color: #0000ff;\"><b>BAD<\/b><\/span>\u00a0if the bigger the value, the worse. <\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span data-contrast=\"auto\"><strong>6-<\/strong> Write a threshold value for the KPI. Ex.: If you write 50, it means that the KPI should not cross 50.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span data-contrast=\"none\"><strong>7-<\/strong> Write the KPI Unit. It can be in percentage, number of attempts, seconds, etc.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span data-contrast=\"none\"><strong>8-<\/strong> Write the KPI category. Ex.: availability, accessibility, etc.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span style=\"color: #ff0000;\"><b>NOTE: <\/b><\/span><span data-contrast=\"auto\">Items 5, 6, 7 and 8 are optional.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span data-contrast=\"none\">After that, write an optional detailed description and any pertinent notes for the KPI in the correct fields.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" width=\"832\" height=\"453\" class=\"size-full wp-image-2888 aligncenter\" src=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c396c32b.png\" alt=\"\" srcset=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c396c32b.png 832w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c396c32b-300x163.png 300w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c396c32b-768x418.png 768w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c396c32b-60x33.png 60w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c396c32b-150x82.png 150w\" sizes=\"(max-width: 832px) 100vw, 832px\" \/><\/p>\n<p><span data-contrast=\"auto\">Continue filling in the KPI properties.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"6\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">Under <span style=\"color: #0000ff;\"><b>Performance<\/b><\/span><span data-contrast=\"auto\">, see the a<\/span><span data-contrast=\"none\">vailable tables of performance to the selected vendor\/tech and choose the desired counter by dragging and dropping them in the <span style=\"color: #0000ff;\"><b>Counters<\/b><\/span><span data-contrast=\"none\"> field.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" width=\"1129\" height=\"346\" class=\"size-full wp-image-2889 aligncenter\" src=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c49a7783.png\" alt=\"\" srcset=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c49a7783.png 1129w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c49a7783-300x92.png 300w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c49a7783-1024x314.png 1024w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c49a7783-768x235.png 768w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c49a7783-60x18.png 60w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c49a7783-150x46.png 150w\" sizes=\"(max-width: 1129px) 100vw, 1129px\" \/><\/p>\n<ul style=\"font-weight: 400;\">\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"6\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"none\">In the <span style=\"color: #0000ff;\"><b>Counters<\/b><\/span><span data-contrast=\"none\"> field, write\/edit the KPI formula in line.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"6\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-contrast=\"none\">Inside the <span style=\"color: #0000ff;\"><b>Tables<\/b><\/span><span data-contrast=\"none\"> field, write the performance table related to the formula with an alias (as a, b, etc).<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"6\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-contrast=\"none\">In the <span style=\"color: #0000ff;\"><b>Where Restriction<\/b><\/span><span data-contrast=\"none\"> field, write the conditional statement, in case you want to restrict the results based on any counter.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"6\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"4\" data-aria-level=\"1\"><span data-contrast=\"auto\">Check the <span style=\"color: #0000ff;\"><b>Formula contains subKPIs<\/b><\/span><span data-contrast=\"auto\"> box if it contains other KPIs (i.e.: (rnc_727a + rnc_183c)\/2).<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" width=\"1207\" height=\"412\" class=\"size-full wp-image-2890 aligncenter\" src=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c626a96f.png\" alt=\"\" srcset=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c626a96f.png 1207w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c626a96f-300x102.png 300w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c626a96f-1024x350.png 1024w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c626a96f-768x262.png 768w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c626a96f-60x20.png 60w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c626a96f-150x51.png 150w\" sizes=\"(max-width: 1207px) 100vw, 1207px\" \/><\/p>\n<p><span class=\"TextRun SCXW80401245 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW80401245 BCX0\"><span class=\"TextRun SCXW80401245 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW80401245 BCX0\"><span class=\"TextRun SCXW80401245 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"TextRun SCXW80401245 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW80401245 BCX0\"><span class=\"TextRun SCXW8380602 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span style=\"color: #ff0000;\"><b>NOTE: <\/b><\/span><\/span> <span class=\"TextRun SCXW8380602 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW8380602 BCX0\">Normally the KPI Formula is a SUM or AVG<\/span><span class=\"NormalTextRun SCXW8380602 BCX0\"> (average)<\/span><span class=\"NormalTextRun SCXW8380602 BCX0\"> of <\/span><span class=\"NormalTextRun SCXW8380602 BCX0\">a <\/span><span class=\"NormalTextRun SCXW8380602 BCX0\">few counters. If counters from more than one table <\/span><span class=\"NormalTextRun SCXW8380602 BCX0\">are<\/span><span class=\"NormalTextRun SCXW8380602 BCX0\"> used, it is necessary to put an alias of the table in front of each counter. (<\/span><span class=\"NormalTextRun SCXW8380602 BCX0\">i<\/span><span class=\"NormalTextRun SCXW8380602 BCX0\">.e.: <\/span><span class=\"NormalTextRun ContextualSpellingAndGrammarErrorV2Themed SCXW8380602 BCX0\">a.counter<\/span><span class=\"NormalTextRun SCXW8380602 BCX0\">1; <\/span><span class=\"NormalTextRun ContextualSpellingAndGrammarErrorV2Themed SCXW8380602 BCX0\">qos.counter<\/span><span class=\"NormalTextRun SCXW8380602 BCX0\">2.) In this case, the alias should be also present in the statistic table description.<\/span><\/span><span class=\"LineBreakBlob BlobObject DragDrop SCXW8380602 BCX0\"><span class=\"SCXW8380602 BCX0\">\u00a0<\/span><br class=\"SCXW8380602 BCX0\" \/><\/span><span class=\"LineBreakBlob BlobObject DragDrop SCXW8380602 BCX0\"><span class=\"SCXW8380602 BCX0\">\u00a0<\/span><br class=\"SCXW8380602 BCX0\" \/><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/p>\n<p><span class=\"TextRun SCXW80401245 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW80401245 BCX0\"><span class=\"TextRun SCXW80401245 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW80401245 BCX0\"><span class=\"TextRun SCXW80401245 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"TextRun SCXW80401245 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW80401245 BCX0\"><span class=\"TextRun SCXW8380602 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW8380602 BCX0\">Select <\/span><\/span><span class=\"TextRun SCXW8380602 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span style=\"color: #0000ff;\"><b>Save<\/b><\/span><span class=\"TextRun SCXW8380602 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW8380602 BCX0\"> to finish the creation of the KPI.<\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/p>\n<h4><img loading=\"lazy\" width=\"1056\" height=\"466\" class=\"size-full wp-image-2891 aligncenter\" src=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c7a87b8a.png\" alt=\"\" srcset=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c7a87b8a.png 1056w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c7a87b8a-300x132.png 300w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c7a87b8a-1024x452.png 1024w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c7a87b8a-768x339.png 768w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c7a87b8a-60x26.png 60w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c7a87b8a-150x66.png 150w\" sizes=\"(max-width: 1056px) 100vw, 1056px\" \/><\/h4>\n<h4><span id=\"Edit_an_existing_KPI\"><span data-contrast=\"none\"><a id=\"edit-an-existing-kpi\"><\/a>E<span class=\"TextRun SCXW67001039 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW67001039 BCX0\" data-ccp-parastyle=\"heading 3\">dit an existing<\/span><span class=\"NormalTextRun SCXW67001039 BCX0\" data-ccp-parastyle=\"heading 3\"> KPI<\/span><\/span><span class=\"EOP SCXW67001039 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559738&quot;:40,&quot;335559739&quot;:0,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><\/span><\/h4>\n<p><span data-contrast=\"auto\">Edit the properties of an existing KPI by following the steps below:<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;201341983&quot;:0,&quot;335551550&quot;:1,&quot;335551620&quot;:1,&quot;335559685&quot;:0,&quot;335559737&quot;:0,&quot;335559738&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" width=\"1269\" height=\"667\" class=\"size-full wp-image-2892 alignright\" src=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c983bff0.png\" alt=\"\" srcset=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c983bff0.png 1269w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c983bff0-300x158.png 300w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c983bff0-1024x538.png 1024w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c983bff0-768x404.png 768w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c983bff0-60x32.png 60w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726c983bff0-150x79.png 150w\" sizes=\"(max-width: 1269px) 100vw, 1269px\" \/><\/p>\n<p><span class=\"TextRun SCXW80401245 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW80401245 BCX0\"><span class=\"TextRun SCXW80401245 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW80401245 BCX0\"><span class=\"TextRun SCXW80401245 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"TextRun SCXW80401245 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW80401245 BCX0\"><span class=\"EOP SCXW8380602 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/p>\n<p><b><span data-contrast=\"auto\">1- <\/span><\/b><span data-contrast=\"auto\">Select the desired visibility. Choose <span style=\"color: #0000ff;\"><b>PUB<\/b><\/span> to filter for public KPIs available, <span style=\"color: #0000ff;\"><b>ALL<\/b><\/span>\u00a0to filter for all KPIs, or a user\u2019s name for private KPIs. <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559685&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><b><span data-contrast=\"auto\">2- <\/span><\/b><span data-contrast=\"auto\">Choose the desired KPI.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559685&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><b><span data-contrast=\"auto\">3- <\/span><\/b><span data-contrast=\"auto\">Select <span style=\"color: #0000ff;\"><b>Load<\/b><\/span><span data-contrast=\"auto\">.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559685&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><\/p>\n<p><b><span data-contrast=\"auto\">4-<\/span><\/b><span data-contrast=\"auto\"> Edit the desired properties in their corresponding fields.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559685&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><b><span data-contrast=\"auto\">5-<\/span><\/b><span data-contrast=\"auto\"> Select <span style=\"color: #0000ff;\"><b>Save<\/b><\/span> <span data-contrast=\"auto\">to apply the changes made.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559685&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><\/p>\n<h4><span id=\"Export_a_KPI\"><span data-contrast=\"none\">E<span class=\"TextRun SCXW261318614 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW261318614 BCX0\" data-ccp-parastyle=\"heading 3\">xport a<\/span><span class=\"NormalTextRun SCXW261318614 BCX0\" data-ccp-parastyle=\"heading 3\"> KPI<\/span><\/span><span class=\"LineBreakBlob BlobObject DragDrop SCXW261318614 BCX0\"><span class=\"SCXW261318614 BCX0\">\u00a0<\/span><br class=\"SCXW261318614 BCX0\" \/><\/span><\/span><span data-ccp-props=\"{&quot;134245418&quot;:true,&quot;201341983&quot;:0,&quot;335559738&quot;:40,&quot;335559739&quot;:0,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><\/h4>\n<p><span data-contrast=\"auto\">Select <span style=\"color: #0000ff;\"><b>Export<\/b><\/span><span data-contrast=\"auto\"> to export the currently selected KPI into a text file (TXT).<\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" width=\"919\" height=\"411\" class=\"size-full wp-image-2893 aligncenter\" src=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726ce309e1b.png\" alt=\"\" srcset=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726ce309e1b.png 919w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726ce309e1b-300x134.png 300w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726ce309e1b-768x343.png 768w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726ce309e1b-60x27.png 60w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726ce309e1b-150x67.png 150w\" sizes=\"(max-width: 919px) 100vw, 919px\" \/><\/p>\n<p aria-level=\"3\"><span data-ccp-props=\"{&quot;134245418&quot;:true,&quot;201341983&quot;:0,&quot;335559738&quot;:40,&quot;335559739&quot;:0,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<h4><span id=\"Delete_a_KPI\"><span data-contrast=\"none\"><a id=\"delete-a-kpi\"><\/a>D<span class=\"TextRun SCXW139609697 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW139609697 BCX0\" data-ccp-parastyle=\"heading 3\">elete a<\/span><span class=\"NormalTextRun SCXW139609697 BCX0\" data-ccp-parastyle=\"heading 3\"> KPI<\/span><\/span><span class=\"LineBreakBlob BlobObject DragDrop SCXW139609697 BCX0\"><span class=\"SCXW139609697 BCX0\">\u00a0<\/span><br class=\"SCXW139609697 BCX0\" \/><\/span><\/span><\/span><\/h4>\n<p><span data-contrast=\"auto\">After choosing the KPI you want to delete, select <span style=\"color: #0000ff;\"><b>Load<\/b><\/span> and then, <span style=\"color: #0000ff;\"><b>Delete<\/b><\/span><span data-contrast=\"auto\">. Select <span style=\"color: #0000ff;\"><b>OK<\/b><\/span><span data-contrast=\"auto\"> to confirm the action or <span style=\"color: #0000ff;\"><b>Cancel<\/b><\/span><span data-contrast=\"auto\"> to give up on the action.<\/span><\/span><\/span><\/span><\/p>\n<p id=\"zGVMDDo\"><img loading=\"lazy\" width=\"1307\" height=\"590\" class=\"alignnone size-full wp-image-3021 \" src=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637509d76d0f7.png\" alt=\"\" srcset=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637509d76d0f7.png 1307w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637509d76d0f7-300x135.png 300w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637509d76d0f7-1024x462.png 1024w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637509d76d0f7-768x347.png 768w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637509d76d0f7-60x27.png 60w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637509d76d0f7-150x68.png 150w\" sizes=\"(max-width: 1307px) 100vw, 1307px\" \/><\/p>\n<h4><span id=\"Special_functions\"><span data-contrast=\"none\"><br \/>\nS<span class=\"TextRun SCXW89119221 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW89119221 BCX0\" data-ccp-parastyle=\"heading 3\">pecial functions<\/span><\/span><\/span><\/span><\/h4>\n<p aria-level=\"3\"><span data-ccp-props=\"{&quot;134245418&quot;:true,&quot;201341983&quot;:0,&quot;335559738&quot;:40,&quot;335559739&quot;:0,&quot;335559740&quot;:259}\">\u00a0<\/span><span data-contrast=\"auto\">You can use the following functions when editing your formula:<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" width=\"1063\" height=\"367\" class=\"size-full wp-image-2895 aligncenter\" src=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726d2303c79.png\" alt=\"\" srcset=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726d2303c79.png 1063w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726d2303c79-300x104.png 300w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726d2303c79-1024x354.png 1024w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726d2303c79-768x265.png 768w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726d2303c79-60x21.png 60w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726d2303c79-150x52.png 150w\" sizes=\"(max-width: 1063px) 100vw, 1063px\" \/><\/p>\n<p><b><span data-contrast=\"auto\">Example:<\/span><\/b><span data-contrast=\"auto\"> sum (RSSI_to_mW(tableAlias.the_counter)) &#8211; returns the sum of all values for the element in mW.<\/span><br \/>\n<span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<h2><span id=\"_Multivendor_KPIs\"><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><br \/>\n<span data-contrast=\"none\">M<span class=\"NormalTextRun SCXW55514955 BCX0\" data-ccp-parastyle=\"heading 2\">ultivendor<\/span><span class=\"NormalTextRun SCXW55514955 BCX0\" data-ccp-parastyle=\"heading 2\"> KPIs<\/span><\/span><span data-ccp-props=\"{&quot;134245418&quot;:true,&quot;201341983&quot;:0,&quot;335559738&quot;:40,&quot;335559739&quot;:0,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><\/h2>\n<p><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;201341983&quot;:0,&quot;335551550&quot;:1,&quot;335551620&quot;:1,&quot;335559685&quot;:0,&quot;335559737&quot;:0,&quot;335559738&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><span data-contrast=\"none\">Learn how to create Multivendor KPIs.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;201341983&quot;:0,&quot;335551550&quot;:1,&quot;335551620&quot;:1,&quot;335559685&quot;:0,&quot;335559737&quot;:0,&quot;335559738&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<h3><\/h3>\n<h3><span id=\"Create_multivendor_KPIs\"><span data-contrast=\"none\">C<span class=\"TextRun SCXW144490047 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW144490047 BCX0\" data-ccp-parastyle=\"heading 3\">reate multivendor<\/span><span class=\"NormalTextRun SCXW144490047 BCX0\" data-ccp-parastyle=\"heading 3\"> KPIs<\/span><\/span><span class=\"EOP SCXW144490047 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559738&quot;:40,&quot;335559739&quot;:0,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><\/span><\/h3>\n<p><span data-contrast=\"none\">There are two types of formula for processing Multivendor KPIs: the standard one and the customized one. <\/span><\/p>\n<h4><span id=\"NetChart_standard_formula\"><span data-ccp-props=\"{&quot;134245418&quot;:true,&quot;201341983&quot;:0,&quot;335559738&quot;:40,&quot;335559739&quot;:0,&quot;335559740&quot;:259}\"><br \/>\n<\/span><span class=\"TextRun SCXW61500533 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SpellingErrorV2Themed SCXW61500533 BCX0\" data-ccp-parastyle=\"heading 4\">Net<\/span><span class=\"NormalTextRun SpellingErrorV2Themed SCXW61500533 BCX0\" data-ccp-parastyle=\"heading 4\">C<\/span><span class=\"NormalTextRun SpellingErrorV2Themed SCXW61500533 BCX0\" data-ccp-parastyle=\"heading 4\">hart<\/span><span class=\"NormalTextRun SCXW61500533 BCX0\" data-ccp-parastyle=\"heading 4\"> standard formula<\/span><\/span><span class=\"LineBreakBlob BlobObject DragDrop SCXW61500533 BCX0\"><span class=\"SCXW61500533 BCX0\">\u00a0<\/span><br class=\"SCXW61500533 BCX0\" \/><\/span><\/span><\/h4>\n<p><span data-contrast=\"none\">Multivendor standard KPIs are the ones that share the same KPI_ID in two or more vendors\/techs.<\/span><br \/>\n<span data-contrast=\"none\">This means that if you want to analyze the availability KPIs for Ericsson and Huawei, you must create both KPIs with the same name for each vendor.<\/span><\/p>\n<p><span data-contrast=\"none\">The data sum in Multivendor is not direct, that is, the system does not take each column value and sum it.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"none\">First of all, NetChart breaks each KPI from each tech into numerator and denominator. This happens because each vendor has its own formula to calculate the KPI and different ways to show this data.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">Then, the system sums all the numerators and all the denominators. Only after that, it makes the division: numerator sum\/denominator sum. This is the formula that gives the final value of the KPI for the tech.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<h4><span id=\"NetChart_customized_formula\"><span class=\"NormalTextRun SpellingErrorV2Themed SpellingErrorHighlight SCXW65979214 BCX0\" data-ccp-parastyle=\"heading 4\">Net<\/span><span class=\"NormalTextRun SpellingErrorV2Themed SpellingErrorHighlight SCXW65979214 BCX0\" data-ccp-parastyle=\"heading 4\">C<\/span><span class=\"NormalTextRun SpellingErrorV2Themed SpellingErrorHighlight SCXW65979214 BCX0\" data-ccp-parastyle=\"heading 4\">hart<\/span><span class=\"NormalTextRun SCXW65979214 BCX0\" data-ccp-parastyle=\"heading 4\"> customized formula<\/span><br \/>\n<span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;134245418&quot;:true,&quot;201341983&quot;:0,&quot;335551550&quot;:1,&quot;335551620&quot;:1,&quot;335559685&quot;:0,&quot;335559737&quot;:0,&quot;335559738&quot;:40,&quot;335559739&quot;:0,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><\/h4>\n<p><span data-contrast=\"auto\">This feature allows for the creation of a Multivendor formula that combines Multivendor standard KPIs.\u00a0\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"none\">First, select a Multivendor region.<\/span><\/p>\n<p><img loading=\"lazy\" width=\"591\" height=\"667\" class=\"alignnone size-full wp-image-2896 \" src=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726d7fdc24f.png\" alt=\"\" srcset=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726d7fdc24f.png 591w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726d7fdc24f-266x300.png 266w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726d7fdc24f-53x60.png 53w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726d7fdc24f-133x150.png 133w\" sizes=\"(max-width: 591px) 100vw, 591px\" \/><\/p>\n<p><span data-contrast=\"auto\">After that, proceed with the creation of the Multivendor KPIs.<\/span><\/p>\n<p><span data-contrast=\"auto\">This process follows the same steps as the ones for the creation of Standard KPIs. <span class=\"NormalTextRun SCXW219212696 BCX0\">To <\/span><span class=\"NormalTextRun SCXW219212696 BCX0\">view<\/span><span class=\"NormalTextRun SCXW219212696 BCX0\">\u00a0the step by step, <\/span><span class=\"NormalTextRun SCXW219212696 BCX0\">refer to the <\/span><\/span><a href=\"#create-a-new-kpi\"><span data-contrast=\"none\">Create a new KPI <\/span><\/a><span data-contrast=\"none\">section.<\/p>\n<p>For the formula, notice that the <span style=\"color: #0000ff;\"><b>Performance <\/b><\/span>field is empty. This is because there are no Multivendor counters.<\/span><\/p>\n<p><span data-contrast=\"none\">Make sure to check the <span style=\"color: #0000ff;\"><b>Formula contains subKPIs<\/b><\/span><span data-contrast=\"none\"> box when creating the formula combining the Multivendor standard KPI IDs<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559685&quot;:0,&quot;335559737&quot;:0,&quot;335559738&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><\/p>\n<p><img loading=\"lazy\" width=\"1436\" height=\"782\" class=\"alignnone size-full wp-image-2897 \" src=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726d9027cb2.png\" alt=\"\" srcset=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726d9027cb2.png 1436w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726d9027cb2-300x163.png 300w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726d9027cb2-1024x558.png 1024w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726d9027cb2-768x418.png 768w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726d9027cb2-60x33.png 60w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63726d9027cb2-150x82.png 150w\" sizes=\"(max-width: 1436px) 100vw, 1436px\" \/><\/p>\n<p><span data-contrast=\"none\"><br \/>\nSince the <span style=\"color: #0000ff;\"><b>Tables<\/b><\/span><span data-contrast=\"none\"> and <span style=\"color: #0000ff;\"><b>Where Restriction<\/b><\/span><span data-contrast=\"none\"> fields are used only for single vendor\/tech counters, they must not be filled in when creating Multivendor KPI formulas.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559685&quot;:0,&quot;335559737&quot;:0,&quot;335559738&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><\/span><\/p>\n<p aria-level=\"3\"><span data-ccp-props=\"{&quot;134245418&quot;:true,&quot;201341983&quot;:0,&quot;335559738&quot;:40,&quot;335559739&quot;:0,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<h3><span id=\"Editdelete_multivendor_KPIs\"><span data-contrast=\"none\">E<span class=\"TextRun SCXW116546203 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW116546203 BCX0\" data-ccp-parastyle=\"heading 3\">dit\/delete multivendor <\/span><span class=\"NormalTextRun SCXW116546203 BCX0\" data-ccp-parastyle=\"heading 3\">KPIs<\/span><\/span><span class=\"LineBreakBlob BlobObject DragDrop SCXW116546203 BCX0\"><span class=\"SCXW116546203 BCX0\">\u00a0<\/span><br class=\"SCXW116546203 BCX0\" \/><\/span><\/span><span data-ccp-props=\"{&quot;134245418&quot;:true,&quot;201341983&quot;:0,&quot;335559738&quot;:40,&quot;335559739&quot;:0,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><\/h3>\n<p><span data-contrast=\"auto\">The editing and exclusion of Multivendor KPIs follow the same procedures from the Single vendor\/tech ones. To obtain more information on how to edit or delete KPIs, refer to the\u00a0 <\/span><a href=\"#edit-an-existing-kpi\"><span data-contrast=\"none\">Edit an existing KPI<\/span><\/a> and <a href=\"#delete-a-kpi\"><span data-contrast=\"none\">Delete a <\/span><span data-contrast=\"none\">KPI<\/span><\/a> sections.<\/p>\n<p>&nbsp;<\/p>\n<h2><span id=\"Formula_Oracle_x_MySQL\"><span data-contrast=\"none\">Formula Oracle x MySQL<\/span><br \/>\n<span data-ccp-props=\"{&quot;134245418&quot;:true,&quot;201341983&quot;:0,&quot;335559738&quot;:40,&quot;335559739&quot;:0,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><\/h2>\n<p><span data-contrast=\"auto\">NetChart uses the database MySQL, so some KPI formulas need to be converted from the Oracle database. Almost all functions have the same syntax, such as SUM, AVG, MAX, MIN, POW, ROUND, but there are some differences like NVL, DECODE, etc. Therefore, sometimes, adaptations are necessary. <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">See an example of where this adaptation was necessary. Observe that the formulas are exactly the same.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">Original formula:<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><b><span data-contrast=\"auto\">nvl(decode(sum(NBR_OF_RLS),0,NULL, round(10*log(10,( SUM( (0.001 * power( 10, ( (-10+(AVE_TRX_FOR_RL_IN_CELL\/2 ) )\/10) ) ) * (NBR_OF_RLS) ) \/SUM(NBR_OF_RLS ) ) \/0.001 ) ,2) ),0)<\/span><\/b><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><b><span data-contrast=\"auto\">nvl(x,y)<\/span><\/b><span data-contrast=\"auto\"> &#8211; Oracle function that substitutes result of formula with <\/span><b><span data-contrast=\"auto\">y<\/span><\/b><span data-contrast=\"auto\"> if <\/span><b><span data-contrast=\"auto\">x <\/span><\/b><span data-contrast=\"auto\">= null.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">It must be removed because NetChart will return the result as 0 in cases where the KPI value is null.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">Removing <\/span><b><span data-contrast=\"auto\">nvl<\/span><\/b><span data-contrast=\"auto\"> part from KPI:<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><b><span data-contrast=\"auto\">decode(sum(NBR_OF_RLS),0,NULL, round(10*log(10,( SUM( (0.001 * power( 10, ( (-10+(AVE_TRX_FOR_RL_IN_CELL\/2 ) )\/10) ) ) * (NBR_OF_RLS) ) \/SUM(NBR_OF_RLS ) ) \/0.001 ) ,2) )<\/span><\/b><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><b><span data-contrast=\"auto\">decode(x, y, z, w)<\/span><\/b><span data-contrast=\"auto\"> &#8211; Oracle function. If <\/span><b><span data-contrast=\"auto\">x=y<\/span><\/b><span data-contrast=\"auto\"> result is<\/span><b><span data-contrast=\"auto\"> z<\/span><\/b><span data-contrast=\"auto\">, otherwise result is <\/span><b><span data-contrast=\"auto\">w<\/span><\/b><span data-contrast=\"auto\">. The purpose here is to check if <\/span><b><span data-contrast=\"auto\">NBR_OF_RLS <\/span><\/b><span data-contrast=\"auto\">is zero. If yes, formula result is null, otherwise result is round ( &#8230; ).<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">It can be removed, because in MySQL, this part is not needed.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><b><span data-contrast=\"auto\">round(10*log(10,( SUM( (0.001 * power( 10, ( (-10+(AVE_TRX_FOR_RL_IN_CELL\/2 ) )\/10) ) ) * (NBR_OF_RLS) ) \/SUM(NBR_OF_RLS ) ) \/0.001 ) ,2)<\/span><\/b><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">The<\/span><b><span data-contrast=\"auto\"> round, log, SUM <\/span><\/b><span data-contrast=\"auto\">and <\/span><b><span data-contrast=\"auto\">power <\/span><\/b><span data-contrast=\"auto\">functions have the same syntax in MySQL as in Oracle, so the formula above can be used as it is.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">It\u2019s exactly the same as in NetChart (the only difference is that NetChart formula is using table alias <\/span><b><span data-contrast=\"auto\">t33<\/span><\/b><span data-contrast=\"auto\">):<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><b><span data-contrast=\"auto\">round( 10*log(10, ( SUM( (0.001*power( 10,( (-10+(t33.AVE_TRX_FOR_RL_IN_CELL\/2 ) )\/10 ) ) ) * (t33.NBR_OF_RLS) ) \/SUM( t33.NBR_OF_RLS ) ) \/0.001 ) ,2)<\/span><\/b><\/p>\n<p>&nbsp;<\/p>\n<h2><span id=\"Ceate_KPIs_importing_a_text_file\"><span data-contrast=\"none\">C<span class=\"TextRun SCXW189174188 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW189174188 BCX0\" data-ccp-parastyle=\"heading 2\">e<\/span><span class=\"NormalTextRun SCXW189174188 BCX0\" data-ccp-parastyle=\"heading 2\">ate<\/span> <span class=\"NormalTextRun SCXW189174188 BCX0\" data-ccp-parastyle=\"heading 2\">KPI<\/span><span class=\"NormalTextRun SCXW189174188 BCX0\" data-ccp-parastyle=\"heading 2\">s<\/span> <span class=\"NormalTextRun SCXW189174188 BCX0\" data-ccp-parastyle=\"heading 2\">importing <\/span><span class=\"NormalTextRun SCXW189174188 BCX0\" data-ccp-parastyle=\"heading 2\">a <\/span><span class=\"NormalTextRun SCXW189174188 BCX0\" data-ccp-parastyle=\"heading 2\">text file<\/span><\/span><span class=\"EOP SCXW189174188 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559738&quot;:40,&quot;335559739&quot;:0,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><\/span><\/h2>\n<p><span data-contrast=\"auto\">To create one or more KPIs by importing a text file,<\/span><br \/>\n<span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"4\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">Choose the vendor\/tech and the network element.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"4\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-contrast=\"auto\">Select <span style=\"color: #0000ff;\"><b>Custom<\/b><\/span><span data-contrast=\"auto\"> &gt; <span style=\"color: #0000ff;\"><b>Import<\/b><\/span><span data-contrast=\"auto\"> &gt;<span style=\"color: #0000ff;\"><b>KPIs<\/b><\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><\/span><\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" width=\"1511\" height=\"679\" class=\"alignnone size-full wp-image-2898 \" src=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637272be1a34c.png\" alt=\"\" srcset=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637272be1a34c.png 1511w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637272be1a34c-300x135.png 300w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637272be1a34c-1024x460.png 1024w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637272be1a34c-768x345.png 768w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637272be1a34c-60x27.png 60w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637272be1a34c-150x67.png 150w\" sizes=\"(max-width: 1511px) 100vw, 1511px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\"><span class=\"TextRun SCXW199769659 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW199769659 BCX0\">Follow the steps below to continue with the process.<\/span><\/span><\/span><\/p>\n<p><img loading=\"lazy\" width=\"1272\" height=\"196\" class=\"alignnone size-full wp-image-2899 \" src=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637272d3c3f24.png\" alt=\"\" srcset=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637272d3c3f24.png 1272w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637272d3c3f24-300x46.png 300w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637272d3c3f24-1024x158.png 1024w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637272d3c3f24-768x118.png 768w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637272d3c3f24-60x9.png 60w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637272d3c3f24-150x23.png 150w\" sizes=\"(max-width: 1272px) 100vw, 1272px\" \/><\/p>\n<p><b><span data-contrast=\"none\">1 \u2013<span style=\"color: #0000ff;\"><b>Click here to download the Import KPIs template<\/b><\/span><span data-contrast=\"none\">.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><\/b><\/p>\n<p><span data-contrast=\"none\">Fill in the template with the information of the KPIs to be created\/updated, separating each one per line in the spreadsheet. <\/span><span data-contrast=\"auto\">You can download the .TXT template file, edit the KPIs in an EXCEL spreadsheet, save it as .TXT file and upload it.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><b><span data-contrast=\"none\">2 \u2013<\/span><\/b><span data-contrast=\"none\"> Check this box to replace the KPI if it already exists.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><b><span data-contrast=\"none\">3 \u2013<\/span><\/b><span data-contrast=\"none\"> Check this box to include the KPI as private.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><b><span data-contrast=\"none\">4 \u2013<\/span><\/b><span data-contrast=\"none\"> Select <span style=\"color: #0000ff;\"><b>Choose File<\/b><\/span> <span data-contrast=\"none\">to import the KPI file.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><\/p>\n<p><b><span data-contrast=\"none\">5 \u2013<\/span><\/b><span data-contrast=\"none\"> Select <span style=\"color: #0000ff;\"><b>Go<\/b><\/span><span data-contrast=\"auto\"> to create the KPIs.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<h3><span id=\"Export_KPIs\"><span data-contrast=\"none\">Export KPIs<\/span><\/span><\/h3>\n<p><span data-contrast=\"auto\">To export the KPIs available on NetChart\u00a0 by importing a text file, you need to:<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"9\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">Choose the vendor\/tech and network element.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"9\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">Click on <span style=\"color: #0000ff;\"><b>Custom<\/b><\/span><span data-contrast=\"auto\"> &gt; <span style=\"color: #0000ff;\"><b>Export<\/b><\/span><span data-contrast=\"auto\"> &gt; <span style=\"color: #0000ff;\"><b>KPIs<\/b><\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><\/span><\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" width=\"1418\" height=\"629\" class=\"alignnone size-full wp-image-2900 \" src=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637272f22943b.png\" alt=\"\" srcset=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637272f22943b.png 1418w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637272f22943b-300x133.png 300w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637272f22943b-1024x454.png 1024w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637272f22943b-768x341.png 768w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637272f22943b-60x27.png 60w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_637272f22943b-150x67.png 150w\" sizes=\"(max-width: 1418px) 100vw, 1418px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\"><span class=\"EOP SCXW199769659 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\"><span class=\"TextRun SCXW111361333 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW111361333 BCX0\">The displayed KPIs are loaded according to the selected network element in the treeview.<\/span><\/span><\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<p id=\"spTeMMS\"><img loading=\"lazy\" width=\"1310\" height=\"573\" class=\"alignnone size-full wp-image-3024 \" src=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63750bc4c9f92.png\" alt=\"\" srcset=\"https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63750bc4c9f92.png 1310w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63750bc4c9f92-300x131.png 300w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63750bc4c9f92-1024x448.png 1024w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63750bc4c9f92-768x336.png 768w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63750bc4c9f92-60x26.png 60w, https:\/\/help.bwtech.com\/wp-content\/uploads\/2022\/11\/img_63750bc4c9f92-150x66.png 150w\" sizes=\"(max-width: 1310px) 100vw, 1310px\" \/><\/p>\n<p><b><span data-contrast=\"auto\">1 \u2013<\/span><\/b><span data-contrast=\"auto\"> Select the KPIs.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span style=\"color: #ff0000;\"><b>NOTE: <\/b><\/span><span data-contrast=\"auto\">Hold &#8216;Ctrl&#8217; to select multiple KPIs.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><b><span data-contrast=\"auto\">2 \u2013<\/span><\/b><span data-contrast=\"auto\"> Press <span style=\"color: #0000ff;\"><b>Enter<\/b><\/span> on your keyboard to move the KPIs to the <span style=\"color: #0000ff;\"><b>Selected KPIs<\/b><\/span> field.\u00a0<\/span><\/p>\n<p><b><span data-contrast=\"auto\">3 \u2013 <\/span><\/b><span data-contrast=\"auto\">Select <span style=\"color: #0000ff;\"><b>Go<\/b><\/span> to export the KPIs.<\/span><\/p>\n<p><span data-contrast=\"auto\"><br \/>\n<span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><br \/>\n<span data-contrast=\"none\">Common errors<\/span><br \/>\n<span data-ccp-props=\"{&quot;134245418&quot;:true,&quot;201341983&quot;:0,&quot;335559738&quot;:40,&quot;335559739&quot;:0,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"8\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><b><span data-contrast=\"auto\">Missed alias:<\/span><\/b><span data-contrast=\"auto\"> Make sure that all counters have table alias if it&#8217;s used.<\/span><\/li>\n<\/ul>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"8\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><b><span data-contrast=\"auto\">Missed aggregation:<\/span><\/b><span data-contrast=\"auto\"> Make sure that there is a function to aggregate counters (SUM, AVG, MIN, MAX).<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"8\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"2\" data-aria-level=\"1\"><b><span data-contrast=\"auto\">Missed Sub KPIs checkbox:<\/span><\/b><span data-contrast=\"auto\"> Make sure that the <span style=\"color: #0000ff;\"><b>Formula contains subKPIs<\/b><\/span><span data-contrast=\"auto\"> checkbox is selected when there are other KPIs present in the formula.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><\/li>\n<\/ul>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\"><span class=\"EOP SCXW199769659 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contents1 MANAGE KPI2 Overview2.1 How to use2.1.1 Single vendor\/tech KPIs \u00a02.1.1.1 Choose a network element \u00a02.1.1.2 Create a new KPI\u00a0 \u00a02.1.1.3 Edit an existing KPI\u00a02.1.1.4 Export a KPI\u00a0\u00a02.1.1.5 Delete a KPI\u00a02.1.1.6 Special functions2.2 \u00a0 Multivendor KPIs\u00a02.2.1 Create multivendor KPIs\u00a02.2.1.1 NetChart standard formula\u00a02.2.1.2 NetChart customized formula \u00a02.2.2 Edit\/delete multivendor KPIs\u00a0\u00a02.3 Formula Oracle x MySQL \u00a02.4 Ceate [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":101,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/help.bwtech.com\/index.php?rest_route=\/wp\/v2\/pages\/263"}],"collection":[{"href":"https:\/\/help.bwtech.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/help.bwtech.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/help.bwtech.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/help.bwtech.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=263"}],"version-history":[{"count":58,"href":"https:\/\/help.bwtech.com\/index.php?rest_route=\/wp\/v2\/pages\/263\/revisions"}],"predecessor-version":[{"id":3224,"href":"https:\/\/help.bwtech.com\/index.php?rest_route=\/wp\/v2\/pages\/263\/revisions\/3224"}],"up":[{"embeddable":true,"href":"https:\/\/help.bwtech.com\/index.php?rest_route=\/wp\/v2\/pages\/101"}],"wp:attachment":[{"href":"https:\/\/help.bwtech.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=263"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}