stat group dashboard or reports

Has anyone created a dashboard or set of reports that show all the stat groups and possible values for customer stats, products stats, and analytical stats? This should help us better understand how we can better query our data. Alternatively, does anyone have a better suggestion for showing these results?

Parents
  • 0

    If you're looking for the data of the stat groups assigned to particular master data, you can create a graphical query in X3 to pull the following in separate queries.

    1. Product Stat Group values in the ITMMASTER table and stat group values are in the TSICOD  field.

    2. Customer Stat Group values in BPCUSTOMER table and stat group values are in the TSCCOD field.

    3. With regards to analytical values (dimension values) you can query the Dimension type (DIE) table and Dimension values are in the (CCE) table.

Reply
  • 0

    If you're looking for the data of the stat groups assigned to particular master data, you can create a graphical query in X3 to pull the following in separate queries.

    1. Product Stat Group values in the ITMMASTER table and stat group values are in the TSICOD  field.

    2. Customer Stat Group values in BPCUSTOMER table and stat group values are in the TSCCOD field.

    3. With regards to analytical values (dimension values) you can query the Dimension type (DIE) table and Dimension values are in the (CCE) table.

Children