Columns Vs Dimensions

Hi Raman ,

A column may or May not be used in a dimension. Column is basically the format where data is stored vertically. Dimension is an identifier: which helps us to understand more insight of a data when used along with a KPI.

For Example:

I want to see how many vendors sites are there in my system.

This vendor site information is stored in the column of Vendor site table and vendor information is stored in Vendor table column.

Now : We need to understand the count of the vendor sites for a vendor.. So , vendor is used here as a dimension and count of vendor site is defined as KPI.

Hope this helps!

Regards

Ayan

alright, so actually a dimension is an identifier for KPI right?

A column is a specific type of data in your tables, which can be used to calculate KPI's or depict dimensions. A dimension is therefore one of the use-cases of a column.

Table:

ID || Value || Customer

1 || 500 || ACrop

2 || 300 || BCorp

Here we have three columns. We can use Value as a KPI (AVG(Value)) and Customer as a dimension (CustomerName)

Kind of yes.

Request you to mark my response as best , if it is helpful

In terms of the visualizations in Celonis, dimension is a data attribute which categorizes the records. The records could be events, cases, ... . You can calculate aggregates (KPIs) for each distinct value of a dimension.

Example: I have a P2P process, the purchase order (PO) item is a case, and each PO item has a supplier. Let's suppose I want to count the number of cases for each supplier. Then the "Supplier" attribute would be a dimension, and case count would be a KPI.

A column is a vertical representation of attribute values in a table - either in one of a source tables (perhaps that's what you meant in the first place) or in OLAP table in a dashboard.

You can use source tables' columns as dimensions in Celonis visualizations, or you can create a custom dimensions from a combination of source tables' columns and various functions.

In case of OLAP tables, you could also call all the dimensions and KPIs as columns of the OLAP table.