03 Nov 2021 12:56 AM - last edited on 01 Dec 2021 12:12 AM by MaciejNeumann
I notice that the native dashboarding in Dynatrace and default metrics are not sufficient in some cases.
We are limited in the UI to the last 100 dimensions in the MDA.
If I want all the dimensions, I must use API to extract data ...
What is for your the best way to display this data?
Using a third party: Excel, PowerBI, Grafana....?
Is there any way to have the API calls showed on Dynatrace?
Thanks for your time and suggestion,
Good day for all.
I have heard of customers using all of those options to display the data. With your 100 dimension limitation, what exactly are you trying to chart or graph? Depending on the data you are trying to populate, could you make it one more step granular. For example Host CPU in Prod, Break it out by Environment, or Application Name?
Also if you use the table format, I don't think you are limited to 100 entities.
Thanks for replying.
When I filter in the multidimensional analysis, the number is 173 different dimensions in the last 6Hours.
I created a calculated metric based on that but when i use this Calculated metric in Dashboard, the number never exceed 101 (it seems to have a limitation at 100).
Is it better to understand?
thanks for your time
First off, THX @ChadTurner for chiming in :)!
Second, may I ask some additional follow up questions to better understand what you want to achieve?
Thanks @zietho for your message.
See my Screenshots,
I want to display this 172 value (172 dimensions)
If you can see the tile, the max reached is 101 (100 dimensions as max)
Thanks for your help.
I have almost the same issue. I have a Request Attribute defined and want to use that in the multidimensional analysis. Sadly with all possible filtering i have always 101 dimensions and so i can not create a custom metric 😥. I tried to filter it all ways, but i had to give it up. Would be great if there is a solution for that.
If you have a BI tool
Power BI, Excel + Json, Grafana, you can use the API call to get all the dimensions....
Dynatrace Managed can do a lot, but you also pay something for it and in my eyes it would not be logical to use three more tools for it if you already have one that can handle it without problems.
But what I know, Dynatrace put a limitation in the UI because the multidimensional analysis is make a huge calculation, and if they open for the for result, the cluster can be impacted.
And by the way, You can use only one tool Excel to see the result, no need to use the Three.
I am just the naive Dashboarding PM but out of curiosity, which API are you referring to exactly? Because the top 100 dimension limitation is a (calculated) metric limitation and it should be a limitation both, when you query the data in the Dynatrace UI and when you query it via the metrics API.
I use this call:
Count Dimensions (Metrics - Query and ingest metrics)
But the most important think is how the metric is built:
And the Request Attributes is:
At The End, The number of dimension will be the different value of my Request Attributes.
In the UI, I have only the last 100 dimension, but with this call I have all of them.
Have a good day.