Is there any documentation on the "computed column" option in a report data set's definition?

Question

I’ve checked BoL and the “add data set” section shows “advanced” but not “computed column” option.

When creating/editing a data set and selecting “computed columns”, the prompt text says “

#Data of the data set is present in data frame with name data.

#You can return dataframe or individual vectores and it will be added into the data set.”

I’d like to compute a column based on two columns that come out of “EXEC Lic_CUR_GetLicenseUsage 29” (part of the license summary report but cannot find any syntax.

icon

Best answer by Chris Sunderland 17 May 2021, 21:58

View original

Chris Sunderland · Accepted Answer

From the sound of your request, you probably want to use a Post Query Filter here. The Computed Columns section is for R scripts.

With the Post Query Filter, you can write another SQL query that executes against your stored procedure results and creates a view around it.

So you could write something like

select col1,
col2,
col3,
(col4 + col5) / 100 As ComputedColumn
from $this$

Here is some documentation post query filters

https://documentation.commvault.com/commvault/v11_sp20/article?p=45057_1.htm

Amanda Tesla · Answer

We are missing information about that Compute Column section for Database data sets. We’ll have to speak to the Development/Test team to gatherinformation about it.Icreated MR317336 so we can add Compute Column to the Report Builder documentation. Thanks for identifying this gap

Is there any documentation on the "computed column" option in a report data set's definition?

4 replies

Reply

Reply

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded