I am testing Alteryx for applicability of various use cases. We use Essbase a lot so I am trying to manipulate the cube data to generate calcs and subsequent reports.
My current issue is that I need to generate a calculation off a field that may or may not exist based on the filters used to retrieve the data. Different months, different lines of business, etc. I know there could be ways to set up a static list of necessary fields and populate missing ones with a zero.
However, since the Essbase hierarchies may change I need something a bit more flexible.
I am pivoting the data to do calcs on the rows.
I was hoping to find something like an IF Exists function to use against the fields before processing the calc.
