Analytics FAQ

Seek answers to commonly asked ION Analytics Questions.

Last updated 27 days ago

Was this helpful?

Seek answers to commonly asked ION Analytics Questions.

The most common reason your are not working is that the last ION environment you logged into was your "Sandbox" environment. Doing so has marked your user credentials as "Sandbox" and thus production"Production" exports can not be performed against those credentials.
The solution is to make sure that they last environment you log into is your "Production" environment before you expect any exports to occur.
We also recommend using a dedicated ION service account to set up your scheduled exports in Analytics. This helps minimize cross-environment credential conflicts by reducing the need to log into multiple environments. For example, a service account intended for the production-pub environment should only be used there, ensuring consistent access and export behavior.

See the manual page . To manage read or write access in ION Analytics, choose a permission set from ION’s Settings menu. These permission sets can be assigned to roles (e.g., engineer) so that the correct permissions are automatically applied when roles are granted during onboarding.

Our analytics platform is designed to handle robust, in-depth queries across millions (if not billions) of data points. As is standard with modern BI tools (Power BI, Tableau, Looker, etc.), certain dashboard views and reports may take longer to generate due to the complexity of the underlying queries.
ION manages complex manufacturing processes, and the resulting data is just as intricate and interconnected.
Simple reports often appear within seconds, while more complex dashboards will take longer to load (including up to a few minutes) depending on data size and the number of calculations involved.
How to Improve Performance
- Refine Queries: Limit the scope of analysis with filters or break large dashboards into smaller, targeted views.
- Limit joins: Limit the number of joins across data sets
- Request Datasets: If you find yourself consistently trying to join a large number of tables that revolve around a specific use case.
For enterprise customers running very large queries and looking to incorporate additional data sources, utilize your access to IONs Data Connector to bring this information into a platform of your choosing.

This is made possible through the entities table and two joins.

Take your desired attributes and join attributes -> entities (join on entity_id = entity_id)
Join users onto the new entities with two join keys as follows, entities -> users (join on entity_id = entity_id AND entities.TYPE = "user")
From you can get users.name / users.email as the associated ION User attribute type!

Last updated 27 days ago

Was this helpful?

The most common reason your are not working is that the last ION environment you logged into was your "Sandbox" environment. Doing so has marked your user credentials as "Sandbox" and thus production"Production" exports can not be performed against those credentials.
The solution is to make sure that they last environment you log into is your "Production" environment before you expect any exports to occur.
We also recommend using a dedicated ION service account to set up your scheduled exports in Analytics. This helps minimize cross-environment credential conflicts by reducing the need to log into multiple environments. For example, a service account intended for the production-pub environment should only be used there, ensuring consistent access and export behavior.

See the manual page . To manage read or write access in ION Analytics, choose a permission set from ION’s Settings menu. These permission sets can be assigned to roles (e.g., engineer) so that the correct permissions are automatically applied when roles are granted during onboarding.

Our analytics platform is designed to handle robust, in-depth queries across millions (if not billions) of data points. As is standard with modern BI tools (Power BI, Tableau, Looker, etc.), certain dashboard views and reports may take longer to generate due to the complexity of the underlying queries.
ION manages complex manufacturing processes, and the resulting data is just as intricate and interconnected.
Simple reports often appear within seconds, while more complex dashboards will take longer to load (including up to a few minutes) depending on data size and the number of calculations involved.
How to Improve Performance
- Refine Queries: Limit the scope of analysis with filters or break large dashboards into smaller, targeted views.
- Limit joins: Limit the number of joins across data sets
- Request Datasets: If you find yourself consistently trying to join a large number of tables that revolve around a specific use case.
For enterprise customers running very large queries and looking to incorporate additional data sources, utilize your access to IONs Data Connector to bring this information into a platform of your choosing.

This is made possible through the entities table and two joins.

Take your desired attributes and join attributes -> entities (join on entity_id = entity_id)
Join users onto the new entities with two join keys as follows, entities -> users (join on entity_id = entity_id AND entities.TYPE = "user")
From you can get users.name / users.email as the associated ION User attribute type!