Using table name (eg LFA1) as a dimension

Hi team

This feels like a simple question but I can’t seem to find a way to do it so thought of asking - I’m looking to create a OLAP table to support data validation that looks like the below:

Table Name__Table Count
LFA1__123
EKKO__456

The idea is that the OLAP will list all tables in the model to easily see the current Table Count for each table.

Is there a way I can define a dimension to list all tables in the model that would populate the 1st column of this OLAP table with all table names?

Thanks
Oliver

Did you try to use a variable instead of the table name? Fill the variable with the Table names and also add the variable as a dimension.

Thanks Marco - I did think about creating a variable for table_name and adding a button drop-down with each table as a drop-down option but then I would have to select each table via the button drop-down, where ideally I wanted to list all tables to see counts at a glance. If you can think of a way to do this via a variable, it’d be great to try - how would the table names be listed/separated in the variable in this case?

As it stands, I’ve had to create an OLAP per table in the model but I’m sure there must be a more elegant solution.

Thanks
Oliver

Hi Oliver,

the Celonis Event Collection offers you an overview on the row count of all tables in the currently loaded data model. You can access it in the following ways:

1. In Process Analytics:

  • Click on the three dots next to the Workspace name
  • Select ‘Data Model
  • Select the tab ‘Data Model Loads
  • Check the # rows in the section ‘Loaded Tables

2. In the Event Collection

  • Select your Data Model in the Section ‘Process Data Models
  • Tab: ‘Data Loads
  • Click ‘Details’ in the box listing the last successful DM Load
  • Check the # rows in the section ‘Data load progress’

These overviews ease validation quite a lot without the extra effort of creating a new analysis/formulas/variables.