Solved

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


Userlevel 2
Badge +5

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

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

 

 

View original

4 replies

Userlevel 7
Badge +15

Hey @Mike London UK , thanks for the post!

I’ll share this with our documentation team and get something for you.

@Seema Ghai 

Userlevel 1
Badge +1

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

 

 

Userlevel 1
Badge +2

@Mike London UK We will review and update the documentation to include any missing information. 

@Amanda Tesla

Badge

We are missing information about that Compute Column section for Database data sets. We’ll have to speak to the Development/Test team to gather information about it. I created MR 317336 so we can add Compute Column to the Report Builder documentation. Thanks for identifying this gap :slight_smile:

Reply