You’re offline. This is a read only version of the page.
44
On voucher transactions form all transactions are shown according to the ledger dimension (ledger-account) which is group of values i.e. mainaccount--businessunit- costcenter-department which is found in dimension attribute value combination table and the default dimension values are found in dimension attribute value set. I have created relationship to obtain the result but its given me multiple values against each ledger dimension. My query is shown attached below:
Does anyone know where I am creating a wrong relationship among the tables and help me create right query. And the requirement is that I want to see all the transaction amount against each department.
Working with these tables directly is quite difficult, as you've already found. You usually can make your life easier by using higher-level objects such as LedgerDimensionFacade class or DimensionAttributeLevelValueAllView view. Give them a try.
Share
Report
All responses (
Answers (
