Clever Geek Handbook

Finding a KPI cell from Cellset when querying SQL Server Analysis Services

Given an MDX query that can return KPI values, is there a way to query the cells in a cellset to determine if they are actually KPIs? This way I can display trend / state images in the results instead of 0. -1, etc.

0


source to share


1 answer


What would it mean that the value was a KPI? Only you know that!

But if the metric names included the letters "KPIs", perhaps you might find that (some VB features like InStr can be used in MDX if in Microsoft Analysis Services, but it would be easier to just check the name of the whole measure).



Another way would be to set the properties of an item in the cube and make the MDX act differently based on that.

0


source






More articles:


All Articles