Speaking the language of business intelligence with an Australian accent

Wednesday, January 16, 2008

Time Intelligence Filter Display Caption Tip

If you don't provide a caption for an item when creating your Time Intelligence filter the TI engine will simply populate the name of the member that the STPS formula relates to.

For example creating a TI filter as seen below with no caption values...

TIFilterDialogNoCaptions

... will result in a filter populated like this

TIFilterNoCaptions 

The only caveat to the "no caption" approach is if you've stipulated a STPS formula that returns a range of members e.g. Month-7:Month-1. In these cases you should provide a caption otherwise the formula itself will appear in the filter. As you can see in the shot above, the items that get a non-geek-readable name are the range formulas that return more than one member.

On the other hand, if you provide captions...

TIFilterDialogWithCaptions

The captions will be displayed accordingly...

TIFilterCaptions

The use of STPS formula captions is not an all or nothing deal. Mix and match with or without captions as required.

TIFilterCaptionsMixture

For more Time Intelligence / STPS reading have a look a David Francis' excellent post on the topic.

2 comments:

Anonymous said...

Is there any way to display the months that are included in the filter. For example, if I choose the Year-to-Date option from the filter (Year.FirstMonth:Month), is there a way to display "January, February, March, April, May, June, July, August, September, October, November" in the Information bar or otherwise in ther report?

Nick Barclay said...

the STPS Year.FirstMonth:Month formula should return a set of values. You can apply that set to a report, scorecard endpoint within the dashboard. This would display all the months from that formula.

HTH,
Nick