Sorting a List of Values Non-Alphanumerically

To sort a list of values (in a prompt in Webi) alphabetically is simple stuff. But sorting in some non-alpha way is a little trickier. In this example, I have a list of four product categories, which should be shown in a particular order: Bikes, Accessories, Components, Clothing. This is obviously not alphabetical. To get the members (values) of a dimension to sort in a specific order, follow these steps:


Read more »

Cascading Prompts

Prompting a user, when they run a Webi report, to select from a list of values, is easy stuff. But sometimes you may want to provide your users with a hierarchical structure in a prompt. This is easy to set up, but asked often enough that I thought a quick post couldn't hurt.

Read more »