we are looking to create a LIVE table of services for a customer as below, either in Cube or in Dataminer Dashboards web module.
We can see this information in Nimbra Manager services across 3 tables (Source Table, Destination Table, Source route table), but wondering how to fetch them together in correlation to each source and display them in Dashboards as a single table.
Service name
Source
Destination
Cable system path
(Currently used Source route name)
Service bandwidth
Service Status
Service1
Source1
Dest1
SR1
X Mbps
Oper Up - Green
Service1
Source1
Dest2
SR2
X Mbps
Oper Up - Green
Service1
Source1
Dest3
SR3
X Mbps
Oper Up - Green
Please point us to help/documentation that would help us build this table.
Hi Ashwini,
You are probably looking to do joins with GQI. If you are not familiar with this you can have a look at the following course (joins from 9:20): Queries - DataMiner Dojo
This is part of a full course that could be helpful to get started with dashboards.