Here are a couple ways to take HyperCube data and transform it into something more useable.
I want to start this artcile off by mentioning that this only works for flat json, meaning non-nested json hierarchies. It is possible to leverage this for nested json but takes a bit more elbow grease and knowledge of the schema. Since my intention is to keep these posts brief, I’ll save that for a more in-depth stand alone article.