You’re offline. This is a read only version of the page.
Announcements
370
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.
You can not forget something that you do not know. Thank you for this very valuable info about Source Type and Source No. field on G/L entries..
Try table 352 (Default Dimension) then you see numbers (customer / vendor), type (customer / vendor) and dimension or dimension value. You also have dimension in G/L. then you can use dimension as a key to link them together.
It is no issue about creating Page API on internal Extension, and then using in Power BI to get and link information.
My question is, which BC tables? :/, since i do not see how the g/l entry is connected to customer entry :/
We created custom API since it was much easier then linking and doing it in Power BI. But you need to publish a few pages from BC that I cannot remember now. But you can create custom API then pull all the data you need to create a link then publish that for Power BI
Look into https://www.hougaard.com/designer/
Tx for the info. Yes, COGS is used.
If I create "customer group" dimension and segment the customers, I will have info, but only on a group level/category. Which is ok also for Power BI. But what is missing when using dimension the way to see all traffic for particular customer and not just the group. But ok, thank you for the hint.
How do you connect in Power BI tables from specific customer with G/L entires at the end?
I wonder which G/L account you have in mind.
For example in Account Payable you can see Vendor No. In Account receivable you can see customer No. But if you work with COGS and Revenue then yes you cannot find customer or vendor info there directly. That is a use of dimension
In my company we have the same setup, then in Power BI for drill down we pulled all customers and their dimension in table in BI then linked here and hence we can see those details in drill down.
my goal is to use general ledger entries, not customer or vendor ledger entries. Maybe this is the way that simply BC works, and is not possible on G/l Account level get the information about particular customer and/or vendor. But it would be very usefull.
When using Power BI, all categories are also stored in BC so it is all refreshed at the same time.
In your example case, it is very hard to do analysis inside detailed and more specific end-customer or vendor, since you use dimension but based on group of customers. :/
Hi
You can report and use dimension in Power BI. Also, even without dimension you can go to vendor and customer ledger entry and report for them. But if you have a group of vendor that you want to report under one category then with dimension you can have that group and then use the group in Power Bi instead of adding those vendors together. It makes your Power Bi report more dynamic since anytime new vendor added you do not need to go to your bi and add vendor to that category.
I am not clear on this question "And if you want to filter to specific vendor or customer, it seems it is not possible, please confirm?" you can filter to any vendor from vendor ledger entry.
Again all depends on situation and your goal. We for example have two shortcut dimensions. Customer and Vendor. Then for Vendor we have about 15 different value. For customer about 30 value.
Then we assigned those value to each customer or vendor. And as Kim said the rest is automated.
#1
André Arnaud de Cal...
291,359
Super User 2024 Season 2
#2
Martin Dráb
230,370
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
