Hello,
I fully understand what Dimensions are and how they work.
What I will need, good example use-cases for this. I understand this is a more business-oriented question, depending on industry, business model / proces and business needs (what data/information/reports do they need so they can make decisions).
However, I also believe here is good BC community using Dimension heavy in production and if you can share some use good (business) case examples.
How many dimensions? Which of them are global? Do you set them as default to customers, or items, or manually entry? Do you use them for purchase, and sales and manual G/L entries etc.
Of course, I expect to use them for reporting using Power BI and analysis of data to make business decisions.
So, from your experience, let's look at several industries and business cases and when it is good practice and suggested to use dimensions, how/when they are used.
I am interested in the industry of an IT company (or could be telco business), which also resells the hardware, the software, but also provides its own services from IT experts as work hours. Please provide some guidance and experience of which dimension you will create, and where you will put the default use etc.