Hello,
Brand new to both Data Point as I'm tasked to convert our Hyperion (Brio) reports. Our Hyperion reports have several calculations which were created in the Result Set once the query has been processed. Is that possible in Data Point or do they all have to be created in the original query.
Thank you!
Sorry for the delayed response!! Toad Data Point differs from Hyperion in where you can add calculated fields. In short, you can create calculated fields in more than one area - either as part of the query or post-query in a transformation and cleanse step, pivot step, or dimensional view step. The "result set" that you get as the result of the query is not the place in Toad Data Point to create a calculated field as it is in Hyperion.