cPlan Metadata Samples

Spectre has a metadata input tag which can be used to retrieve information about a data source:

metadata {
      cbase-input "Accounts.cbase"
    }

There is an optional type tag that allows you to fetch defined properties. These types are:

calcs, dimensions, and inputs.

You can retrieve the basic metadata from a cBase with the following Dive. If a type is not included, the default is calcs.

dive {
  cplan {
    metadata {
      cbase-input "/cbases/014-simple-build_productlookup.cbase"
    }
  }
  detail-window {
    all-cbase-columns
  }
}

Sample metadata calcs results:

Sample basic metadata for a cBase

With this Dive:

dive {
  cplan {
    metadata type="dimensions" {
      cbase-input "/cbases/014-simple-build_productlookup.cbase"
    }
  }
  detail-window {
    all-cbase-columns
  }
}

The Dive window with the metadata for dimensions is as follows:

Metadata for Dimensions in cBase

Using a multilevel cPlan:

dive {
  cplan {
    metadata type="inputs" {
      cplan {
        multilevel {
          cbase-input "/cbases/002_concat.cbase" name="First"
          cbase-input "/cbases/012-simple-build_sales.cbase" name="Second"
        } 
      }
    }
  }
  detail-window {
    all-cbase-columns
  }
}

With type inputs, the metadata in the dive window is limited to the following.

Metadata for Inputs