Table rows count

Solved440 viewsCube dataminercube Tables
2
0 Comments

Hi all,

Is there an indicator in DataMiner Cube tables showing rows count, or is there a way to find rows count without having to implement a custom solution for that?

Alija Kusur [SLC] [DevOps Advocate] Selected answer as best 17th May 2024

2 Answers

1
16.29K 1 Comment

Hi Alija,

You could use a GQI query to get data from this a table. From there you could aggregate and count the number of rows.

For debugging purposes, you could also use the client test tool row-count.

Hope it helps.

Alija Kusur [SLC] [DevOps Advocate] Selected answer as best 17th May 2024
Alija Kusur [SLC] [DevOps Advocate] commented

Hi Miguel, Thanks for your answer. I tried client test tool, and really liked it since it provides all tables row count, so it makes it easy comparing count between different tables, that I had to do in my case.
1
8.30K 1 Comment

Hi Alija,

Don't think there is a way to see the amount of rows in Cube itself. But maybe you could take an export of the table to figure that out.

Alija Kusur [SLC] [DevOps Advocate] Unselected an answer 17th May 2024
Alija Kusur [SLC] [DevOps Advocate] commented

Hi Tom, Export for sure is a nice, quick and easy way for getting a rows count, thanks for pointing it out.