Today let’s talk about changing the metric alias name in the SQL that MicroStrategy generates.
Sometimes you need to debug the query and you see something like this:
select name_pu as name, sum(salary) as #MAS01MQW from Fact_Table group by name_pu
If you have a lot of metric inside your report, it is very hard to know where is a specific metric in the query.
You can change that machine metric alias name to a human metric alias name using Metric Column Name.
To do that, you just have to:
1. Edit your metric;
2. Go to Tools;
3. Go to Advanced Settings;
4. Choose “Metric Column Option”
Then, you just have to type a different name in the “Column Name used in table SQL creation“, like the image below:
Now your SQL is going to be something like this:
select name_pu as name, sum(salary) as Name_of_Metric from Fact_Table group by name_pu
Hope it helps!
God bless you!