At a client, they are interested in trying out some data cubes, so I spun up an instance of SSAS and gave them a demo of some of the awesome opportunities that cubes unlock – but found an interesting puzzle trying to cube-ify some of their data. The client sells subscriptions for their services – and their subscriptions can be in different statuses at different times. Whether or not they knew it, their subscriptions where a slowly changing dimension. And various departments wanted to know how many ......