Skip to main content
Question

Using table name (eg LFA1) as a dimension

  • May 8, 2020
  • 3 replies
  • 5 views
O
Level 2

Hi team

This feels like a simple question but I cant seem to find a way to do it so thought of asking - Im 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

3 replies

M
Level 3
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.
O
Level 2
  • oliver.mcwil
  • Author
  • Level 2
  • May 8, 2020

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, itd be great to try - how would the table names be listed/separated in the variable in this case?

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

Thanks

Oliver

C
Level 0
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.
Community Code of ConductAccessibility statement