Using Excel or Access to retrieve KPIs/Counters from U2020 or PRS in Huawei

Hello Experts.

How to use Excel or Access to retrieve KPIs or Counters from U2020 or PRS in Huawei?

Can you please give more details?

What do you need exactly…

Sure:

I would like Excel to conect to Huawei KPI database and get data directly.

(I use Excel to do that in Ericsson ENIQ).

Hummm, it’s a very good question!

Huawei uses it’s tools to query the KPI database.

But, by any chance (to Huawei Experts): is there a way to query via SQL or similar the Huawei RAN KPI Database?

Yes, you can do that!

Just have the communication with OSS Admin, and they can save a daily report counters to a specific directory that you choose, and then you can make your macro accordingly.

But it’s not like Ericsson ENM I believe.

It’s been a while I did this with a template from GTAC.

Let me check and back here later to answer.