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.

  • 0 in reply to Rafael

    I'm trying to show our team what stat groups exist and what the possible values are for each group. This isn't about actual values being used yet, it is simply about the possible choices. Where are the stat groups and possible values stored so I can query them? Thanks.

  • 0 in reply to ITP

    You can attempt to query the information from the ATABDIV table. (Miscellaneous Tables)

Reply Children