Context sensitivity in Model (Secondary key)

The reason for this suggestion originates in product construction sets. The way products are constructed and then prepared for export to different international markets results in a many to many data table.

One part can be contained in many different final products. The same part can also be in a set. A set can contain many products that can also be sold individually.

To solve this issue we would require a secondary key to be able match data correctly.

The attached images show the tables involved. Our culprit here is the Construction sets table, that shows which components form the final product. We also have the final product table and the parts list table. These two basically contain data on which is which. The diagram shows the basic setup. Finally I've also attached the final result tables. One with only using the product table list and one with using both the final product list and the parts list.

The goal is to be able to add in Discovery either the Parts list or Product list and get data only for those or add them both to get the final information on how many parts were sold based on the construction list. The data is calculated based on the order of columns or which columns are added to the drop zone. This is the main point of context sensitivity. The construction list table is hidden from the end user and is used only to translate data based on input tables.

We already have a functioning many to many table in Pyramid. That is the security table. We need a similar solution for us to use in data modeling side of things.

I hope I managed to explain the problem well enough. If not I can provide further answers to any questions.

I don't know if this can be implemented but it would give us a lot more options to deal with the problems we face on a daily basis.

4 replies

    • "making the sophisticated simple"
    • AviPerez
    • 2 yrs ago
    • Reported - view

    You can implement a many-to-many construct on any table, not just security. If you can articulate your problem with standard SQL syntax, you should be able to frame it with the data model (semantic layer). 

    If you want further help on your problem, upload an example data set, with expected results, so others can simulate your question. 

    • Fotona
    • 2 yrs ago
    • Reported - view

    Yes, I think I would be able to make an SQL script. How can I achieve this? Is there something in the help files I can take a look at?

    • Fotona
    • 2 yrs ago
    • Reported - view

    Just to clarify my question. Where in Pyramid can I make this custom connection? I never found any option to do that.

      • Eduardo_Azanza
      • 2 yrs ago
      • Reported - view

      Bart Hi Bart, Could you contact me at this email address?



Content aside

  • Status Answered
  • 2 yrs agoLast active
  • 4Replies
  • 48Views
  • 3 Following