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, 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
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.
