I have begun testing the new functionality that allows us to use an existing GI as the data source for a new GI. It seems very powerful, and will certainly solve a number of reporting challenges, but I’m struggling with the naming scheme a bit.
Specifically, in the base GI, I have a number of columns that are formulas. I need to reference those columns in the summary/child GI, but the names are simply the original base table plus a GUID to make them unique:
The only method I’ve found for determining which “Formula” is which column is to add each one individually, run the summary/child GI, and use the resulting data to identify the column.
Obviously, that is horribly inefficient, and I’d love to know of a better way.
Has anyone found a method of mapping these formulas names to the source column/formula in the base GI?
