What is the industry term for superset of “metrics” and “dimensions”? [on hold]
Clash Royale CLAN TAG#URR8PPP
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty margin-bottom:0;
up vote
3
down vote
favorite
If I want to refer to measures/metrics and dimensions with a single term, what would be a good industry-accepted expression?
Metrics is used commonly in UIs as well such as Google Analytics or Tableau.
The context for my question is for a UI. I'd like to group both of them and refer to them with an industry-accepted name, if one exists.
database-design terminology application-design dimensional-modeling
New contributor
put on hold as unclear what you're asking by LowlyDBA, McNets, Mr.Brownstone, hot2use, mustaccio yesterday
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
up vote
3
down vote
favorite
If I want to refer to measures/metrics and dimensions with a single term, what would be a good industry-accepted expression?
Metrics is used commonly in UIs as well such as Google Analytics or Tableau.
The context for my question is for a UI. I'd like to group both of them and refer to them with an industry-accepted name, if one exists.
database-design terminology application-design dimensional-modeling
New contributor
put on hold as unclear what you're asking by LowlyDBA, McNets, Mr.Brownstone, hot2use, mustaccio yesterday
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
Welcome to the site BTW. I edited the details from your comments in the question. Feel free to roll back my edits or edit the question yourself if I got it wrong or if you want to add more details yourself.
– Tom V
2 days ago
add a comment |
up vote
3
down vote
favorite
up vote
3
down vote
favorite
If I want to refer to measures/metrics and dimensions with a single term, what would be a good industry-accepted expression?
Metrics is used commonly in UIs as well such as Google Analytics or Tableau.
The context for my question is for a UI. I'd like to group both of them and refer to them with an industry-accepted name, if one exists.
database-design terminology application-design dimensional-modeling
New contributor
If I want to refer to measures/metrics and dimensions with a single term, what would be a good industry-accepted expression?
Metrics is used commonly in UIs as well such as Google Analytics or Tableau.
The context for my question is for a UI. I'd like to group both of them and refer to them with an industry-accepted name, if one exists.
database-design terminology application-design dimensional-modeling
database-design terminology application-design dimensional-modeling
New contributor
New contributor
edited 2 days ago
MDCCL
6,61531743
6,61531743
New contributor
asked 2 days ago
Will E
192
192
New contributor
New contributor
put on hold as unclear what you're asking by LowlyDBA, McNets, Mr.Brownstone, hot2use, mustaccio yesterday
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
put on hold as unclear what you're asking by LowlyDBA, McNets, Mr.Brownstone, hot2use, mustaccio yesterday
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
Welcome to the site BTW. I edited the details from your comments in the question. Feel free to roll back my edits or edit the question yourself if I got it wrong or if you want to add more details yourself.
– Tom V
2 days ago
add a comment |
Welcome to the site BTW. I edited the details from your comments in the question. Feel free to roll back my edits or edit the question yourself if I got it wrong or if you want to add more details yourself.
– Tom V
2 days ago
Welcome to the site BTW. I edited the details from your comments in the question. Feel free to roll back my edits or edit the question yourself if I got it wrong or if you want to add more details yourself.
– Tom V
2 days ago
Welcome to the site BTW. I edited the details from your comments in the question. Feel free to roll back my edits or edit the question yourself if I got it wrong or if you want to add more details yourself.
– Tom V
2 days ago
add a comment |
2 Answers
2
active
oldest
votes
up vote
6
down vote
Dimensions and Measures are the two main components of cubes. The dimensions are basically ways to look at the data while the measures are the data.
When writing MDX the measures are a member of the [Measures]
dimension but that is mostly a syntax convention.
As for a common name, I would say they both are partly definitions of a cube design. The measures define the values and the dimensions define how you slice or aggregate the measures.
The combined result of a query across dimension members and measures is called a cellset but that term is used for a result rather than a cube definition (which is what measures and dimensions are).
If there even is a common term for the combination of dimensions and measures it would be physical aspects of data aggregation
If I were to design a UI where I list both in an interface for users to add a report I would probably call them 'report items' or 'data components' or something but I think the clearest for an end user would be to follow what Excel does and label them 'rows' or 'columns' and 'values' where things you can add to rows/columns are the dimensions and values are the measures.
I don't think it's any clearer to an end user to try and find a common name and from a UI design perspective I would make a distinction between things they should put on an axis and 'values'.
add a comment |
up vote
0
down vote
I would call the screen "Measuring" and there you can define your "Dimensions", like X, Y, Z, time and then use the dimensions to perform "Measures" (is that a word?) or "Measurements" like 5 meters, 20 seconds.
New contributor
1
Hi, Welcome to the site. Measures is a known term in multidimensional databases. I'm not sure your answer is addressing the question. Maybe you could expand on it by adding more explanation?
– Tom V
yesterday
It's possible that your explanation will help the OP to understand better what each of those is but the question wasn't about this. The OP is looking for a single umbrella term for both measures and dimensions ("I want to refer to measures/metrics and dimensions with a single term").
– Andriy M
yesterday
Andriy M is exactly correct. Surprisingly, there doesn't seem to be a commonly agreed-upon term for this?
– Will E
yesterday
add a comment |
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
6
down vote
Dimensions and Measures are the two main components of cubes. The dimensions are basically ways to look at the data while the measures are the data.
When writing MDX the measures are a member of the [Measures]
dimension but that is mostly a syntax convention.
As for a common name, I would say they both are partly definitions of a cube design. The measures define the values and the dimensions define how you slice or aggregate the measures.
The combined result of a query across dimension members and measures is called a cellset but that term is used for a result rather than a cube definition (which is what measures and dimensions are).
If there even is a common term for the combination of dimensions and measures it would be physical aspects of data aggregation
If I were to design a UI where I list both in an interface for users to add a report I would probably call them 'report items' or 'data components' or something but I think the clearest for an end user would be to follow what Excel does and label them 'rows' or 'columns' and 'values' where things you can add to rows/columns are the dimensions and values are the measures.
I don't think it's any clearer to an end user to try and find a common name and from a UI design perspective I would make a distinction between things they should put on an axis and 'values'.
add a comment |
up vote
6
down vote
Dimensions and Measures are the two main components of cubes. The dimensions are basically ways to look at the data while the measures are the data.
When writing MDX the measures are a member of the [Measures]
dimension but that is mostly a syntax convention.
As for a common name, I would say they both are partly definitions of a cube design. The measures define the values and the dimensions define how you slice or aggregate the measures.
The combined result of a query across dimension members and measures is called a cellset but that term is used for a result rather than a cube definition (which is what measures and dimensions are).
If there even is a common term for the combination of dimensions and measures it would be physical aspects of data aggregation
If I were to design a UI where I list both in an interface for users to add a report I would probably call them 'report items' or 'data components' or something but I think the clearest for an end user would be to follow what Excel does and label them 'rows' or 'columns' and 'values' where things you can add to rows/columns are the dimensions and values are the measures.
I don't think it's any clearer to an end user to try and find a common name and from a UI design perspective I would make a distinction between things they should put on an axis and 'values'.
add a comment |
up vote
6
down vote
up vote
6
down vote
Dimensions and Measures are the two main components of cubes. The dimensions are basically ways to look at the data while the measures are the data.
When writing MDX the measures are a member of the [Measures]
dimension but that is mostly a syntax convention.
As for a common name, I would say they both are partly definitions of a cube design. The measures define the values and the dimensions define how you slice or aggregate the measures.
The combined result of a query across dimension members and measures is called a cellset but that term is used for a result rather than a cube definition (which is what measures and dimensions are).
If there even is a common term for the combination of dimensions and measures it would be physical aspects of data aggregation
If I were to design a UI where I list both in an interface for users to add a report I would probably call them 'report items' or 'data components' or something but I think the clearest for an end user would be to follow what Excel does and label them 'rows' or 'columns' and 'values' where things you can add to rows/columns are the dimensions and values are the measures.
I don't think it's any clearer to an end user to try and find a common name and from a UI design perspective I would make a distinction between things they should put on an axis and 'values'.
Dimensions and Measures are the two main components of cubes. The dimensions are basically ways to look at the data while the measures are the data.
When writing MDX the measures are a member of the [Measures]
dimension but that is mostly a syntax convention.
As for a common name, I would say they both are partly definitions of a cube design. The measures define the values and the dimensions define how you slice or aggregate the measures.
The combined result of a query across dimension members and measures is called a cellset but that term is used for a result rather than a cube definition (which is what measures and dimensions are).
If there even is a common term for the combination of dimensions and measures it would be physical aspects of data aggregation
If I were to design a UI where I list both in an interface for users to add a report I would probably call them 'report items' or 'data components' or something but I think the clearest for an end user would be to follow what Excel does and label them 'rows' or 'columns' and 'values' where things you can add to rows/columns are the dimensions and values are the measures.
I don't think it's any clearer to an end user to try and find a common name and from a UI design perspective I would make a distinction between things they should put on an axis and 'values'.
edited 2 days ago
answered 2 days ago
Tom V
13.7k74474
13.7k74474
add a comment |
add a comment |
up vote
0
down vote
I would call the screen "Measuring" and there you can define your "Dimensions", like X, Y, Z, time and then use the dimensions to perform "Measures" (is that a word?) or "Measurements" like 5 meters, 20 seconds.
New contributor
1
Hi, Welcome to the site. Measures is a known term in multidimensional databases. I'm not sure your answer is addressing the question. Maybe you could expand on it by adding more explanation?
– Tom V
yesterday
It's possible that your explanation will help the OP to understand better what each of those is but the question wasn't about this. The OP is looking for a single umbrella term for both measures and dimensions ("I want to refer to measures/metrics and dimensions with a single term").
– Andriy M
yesterday
Andriy M is exactly correct. Surprisingly, there doesn't seem to be a commonly agreed-upon term for this?
– Will E
yesterday
add a comment |
up vote
0
down vote
I would call the screen "Measuring" and there you can define your "Dimensions", like X, Y, Z, time and then use the dimensions to perform "Measures" (is that a word?) or "Measurements" like 5 meters, 20 seconds.
New contributor
1
Hi, Welcome to the site. Measures is a known term in multidimensional databases. I'm not sure your answer is addressing the question. Maybe you could expand on it by adding more explanation?
– Tom V
yesterday
It's possible that your explanation will help the OP to understand better what each of those is but the question wasn't about this. The OP is looking for a single umbrella term for both measures and dimensions ("I want to refer to measures/metrics and dimensions with a single term").
– Andriy M
yesterday
Andriy M is exactly correct. Surprisingly, there doesn't seem to be a commonly agreed-upon term for this?
– Will E
yesterday
add a comment |
up vote
0
down vote
up vote
0
down vote
I would call the screen "Measuring" and there you can define your "Dimensions", like X, Y, Z, time and then use the dimensions to perform "Measures" (is that a word?) or "Measurements" like 5 meters, 20 seconds.
New contributor
I would call the screen "Measuring" and there you can define your "Dimensions", like X, Y, Z, time and then use the dimensions to perform "Measures" (is that a word?) or "Measurements" like 5 meters, 20 seconds.
New contributor
New contributor
answered 2 days ago
user165107
1
1
New contributor
New contributor
1
Hi, Welcome to the site. Measures is a known term in multidimensional databases. I'm not sure your answer is addressing the question. Maybe you could expand on it by adding more explanation?
– Tom V
yesterday
It's possible that your explanation will help the OP to understand better what each of those is but the question wasn't about this. The OP is looking for a single umbrella term for both measures and dimensions ("I want to refer to measures/metrics and dimensions with a single term").
– Andriy M
yesterday
Andriy M is exactly correct. Surprisingly, there doesn't seem to be a commonly agreed-upon term for this?
– Will E
yesterday
add a comment |
1
Hi, Welcome to the site. Measures is a known term in multidimensional databases. I'm not sure your answer is addressing the question. Maybe you could expand on it by adding more explanation?
– Tom V
yesterday
It's possible that your explanation will help the OP to understand better what each of those is but the question wasn't about this. The OP is looking for a single umbrella term for both measures and dimensions ("I want to refer to measures/metrics and dimensions with a single term").
– Andriy M
yesterday
Andriy M is exactly correct. Surprisingly, there doesn't seem to be a commonly agreed-upon term for this?
– Will E
yesterday
1
1
Hi, Welcome to the site. Measures is a known term in multidimensional databases. I'm not sure your answer is addressing the question. Maybe you could expand on it by adding more explanation?
– Tom V
yesterday
Hi, Welcome to the site. Measures is a known term in multidimensional databases. I'm not sure your answer is addressing the question. Maybe you could expand on it by adding more explanation?
– Tom V
yesterday
It's possible that your explanation will help the OP to understand better what each of those is but the question wasn't about this. The OP is looking for a single umbrella term for both measures and dimensions ("I want to refer to measures/metrics and dimensions with a single term").
– Andriy M
yesterday
It's possible that your explanation will help the OP to understand better what each of those is but the question wasn't about this. The OP is looking for a single umbrella term for both measures and dimensions ("I want to refer to measures/metrics and dimensions with a single term").
– Andriy M
yesterday
Andriy M is exactly correct. Surprisingly, there doesn't seem to be a commonly agreed-upon term for this?
– Will E
yesterday
Andriy M is exactly correct. Surprisingly, there doesn't seem to be a commonly agreed-upon term for this?
– Will E
yesterday
add a comment |
Welcome to the site BTW. I edited the details from your comments in the question. Feel free to roll back my edits or edit the question yourself if I got it wrong or if you want to add more details yourself.
– Tom V
2 days ago