Document toolboxDocument toolbox

Code Search

K can help you identify measures, procedures, and other code that match a specific search criteria

The K code search application search a source object’s code that match a specific search criteria. Common scenarios where code search would be helpful include:

  • Identifying measures that use hard coded logic require a change

  • Identifying procedures that that use a specific variable or filter condition


Code search extract

Once you generate the extract, you will be taken to the results page. Your extract will be available to download after a short wait.

 

The extract includes the following details

Columns

Description

Example

Columns

Description

Example

object_type

type of object

dataset_field

object_name

name of the object

fy_flag

sub_type

sub type of the object

measure

source_type

source of the object

powerbi

location

location of the object

power bi / my workspace

code

code recorded for the object

IF(REF_DATE[FISCAL_YEAR] = YEAR(TODAY()) + TRUNC(MONTH(TODAY())/7), 1, 0)

total_usage

total usage of the object

10

code_url

url in K

 

active

object state in K

true

We are constantly improving our extracts. Reach out to let us know what other details will be helpful for your code search use case.


Helpful Tips

  • Code search extracts are only available for 7 days. Remember to download a copy of the impact assessment for future reference.

  • If you click on the Rerun button and choose not to change any of the impact assessment criteria, the current extract will be over-written.