Developer forum

Forum » Dynamicweb 10 » PIM - Dynamic workspace with the same hierarchy as a data model

PIM - Dynamic workspace with the same hierarchy as a data model

Barend Mosch
Reply

Hi there,

Say we have 2 data models ,'Reports' and 'Product Categories'. Both data models are some levels deep, and we have a product that has a relation to both models. See test product below:


Since the data model hierarchy does not visualise the products, a dynamic workspace is created with the hope that it will show the full hierarchy of 1 of the models, not both.
I can make a dynamic workspace with the 'Reports' data model as top level, but this only shows the data model and not the full hierarchy:

Adding the top level groups higher in the levels results in showing all the top level groups, not just the groups of the Report data model.

My question being, can the hierarchy below be shown with Dynamic Workspaces? My purpose here is to show the products with the same hierarchy (just like a warehouse)


If I'm missing key components of how data visualisation and modelling works, please elaborate.
Thanks!

Kind regards,
Barend Mosch


Replies

 
Barend Mosch
Reply

Hi!

Does someone has any findings for me? 

For now, I'm thinking about implementing a warehouse instead of using dynamic workspaces, just like DW9.
The DW10 documentation states that using a warehouse is only there to make the migration from DW9 -> DW10 easy, but I believe that the above situation is not possible with data models + dynamic workspaces.

Kind regards,

Barend Mosch

 
Michael Knudsen
Reply

Hello Barend,

- implementing a Warehouse in DW10 will give you many other challenges, since standard DW9 features as "Add to group" won't exist in DW10 and there will properly be many more features missing.

I find a combination of dashboards + shared queries makes my customers happy, but it of course adds some more configuration. You can also add some 'navigation' fields to the data models, and then let the dynamic workspaces look at these fields = replication of the warehouse.

I think data models needs a setting, where you could select if you want to display 'data sets' or 'products', that way would it be much easier for DW9 customers to use DW10.

Br. Michael Knudsen

 
Barend Mosch
Reply

Hi Michael, thanks!

I was also thinking about group names and layers as navigation on the products for the dynamic workspaces. This does require more setup than I would like to, but it does replicate the warehouse hierarchy.

I agree on the additional setting on the model. It would be nice to visualise/display the products on the sets. Or an easy way to replicate the hierarchy on the dynamic workspaces without the need of additional fields.

Thanks!

Any more findings are welcome, I would like fully understand and grasp the intent of the model and workspaces.

 
Barend Mosch
Reply

Hi there,

I created a test setup where the group hierarchy is filled in custom product fields. Some weird findings below:

Setup:
2 custom product fields (text 255) indicating level 1 (top level) and level 2 (second level)


These are the data model groups. We cannot use of the generated fields called 'top level groups' etc since a product can exist is more than 1 data models and we want separate the hierarchy.

Creating the dynamic workspace and assigning the levels:


Result:

Questions:
- Why is it split by space? Can this be changed? A dynamic workspace based on data model key instead of product fields shows the full name instead of splitting.
- Why does it remove the capitals?

My goal is to create the same hierarchy as the data model as a dynamic workspace. But currently, using the data model key or using the product fields will not provide me with the same hierarchy.

Am I correct in assuming that using a warehouse is the only way to visualize products with the same hierarchy as the data model?

Edit: I created a feature request in git for this issue

Kind regards,

Barend Mosch

 
Michael Knudsen
Reply

Hello Barend,

- it's the field in the index that's analyzed, but check this for a solution: https://doc.dynamicweb.com/forum/pim/pim/structured-query-splits-one-custom-value-into-several-unwanted-sub-catgories

Br. Michael Knudsen

 
Barend Mosch
Reply

Hi Michael,

Cheers for your reaction.

This does fix the splitting:


Now I'm facing the challenge of filling these custom fields with the levels of this specific data model. I'm thinking SQL or some custom code, but the client would like to avoid custom code in general.

Do you have some general advise when working with data models and dynamic workspaces? My goal is simulate the warehouse hierarchy and visualise the products with the same hierarchy.
Clients like the warehouse since it's easy to setup, require little to no configuration and it's easy on the eye. Moving to dynamic workspaces introduces more barriers than necessary, might be difficult to explain it the clients.

All the advise and tips are welcome. Thanks!

Kind regards
 

 

You must be logged in to post in the forum