OTBI report referencing Worksheet Columns and carrying out calculations

Summary:

Hello we have a requirement to generate a report referencing worksheet columns and perform some computations around the same ,which can then be used for upload. Took a look at the OTBI comp Subject area , seems doable, however can someone pls confirm?

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):