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.
Best answer by Chris Sunderland
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
(col4 + col5) / 100 As ComputedColumn
Here is some documentation post query filters