Hi @KellyS ,
I too am working within the “Epicor” EDA front end. What you are describing is not to do with Epicor, its base functionality.
What you have done is applied the property on the transaction level (fact data) NOT on the dimension.
Heres my example:
You will see the properties you have done if you right click on any value within a query:
What you will need to do is in the designer is click on the dimension and then add a sync feed that is linked to it. For example here is the sales database where I need to add dimension properties to it:
Sorry for crude diagram, basically:
- Click on the dimension
- Apply a sync feed with the unique information. I.e. if its customer data you need to have a sync feed which is 1 row per customer with the details you require NOT the fact data.
- Drag and drop that up into the properties of that dimension.
Details of this can be found here: https://helpphocassoftware.atlassian.net/wiki/spaces/userdoc/pages/589844/Design+a+database#Designadatabase-Mapdimensiongroups
Hello Jon. That is a great help! Great explanation and diagrams! Thank you so much!
No problem and welcome to the wonderful world of Phocas, I too found the Epicor training fast, furious…and no help! Had to get coffee and play with the platform, its a very good system that Phocas have created and you’ll find quite a few people that will help you on this site. EDA = Phocas so please go to tips and tricks section as there is a wealth of info.