You’re offline. This is a read only version of the page.
5,901
Hi all,
based on the previous thread, i have to display the dimension set in report dynamically. I have added new design in the report "LedgerTransListAccount"
Kindly let me know how i will display the dimension dynamicaly?
Hi @rp@n,
You can use DimensionFocusNameTmp.generateFocusNamesDefaultDimension method to get dimension values according to dimension set information and update this information to table-source for the report.
I would say you need to do the next steps:
1. Add MainAccount and LedgerDimension fields to LedgerTransactionListTmp and fill values when data is inserted in LedgerTransactionListTmp (if it's not already done)
2. Add 11 pairs (or discuss the max possible level of dimension set with the customer) of field DimValueN and DimAttrNameN (where N from 1..11). DimValueN will store dimension value information and DimAttrNameN can store information about attribute name.
3. Populate unque combinations for MainAccount and LedgerDimension from LedgerTransactionListTmp to DimensionFocusNameTmp table
4. Run DimensionFocusNameTmp::generateFocusNamesDefaultDimension to fill dimension values to separate fields bases on ledger dimension and main account from DimensionFocusNameTmp filled in prev. step
5. Update LedgerTransactionListTmp DimValueN field from DimensionFocusNameTmp
6. In report, add same amount of columns for dimensions as you hae added in step 2.
7. Label for column = First.DimAttrNameN and value DimValueN , if First.DimAttrNameN is empty you need to hide the column from the report.
There are only few examples in standard and one of them is LedgerTrialBalanceDP.generateFocusDescription, but it uses combined value instead of separate columns.
in separate columns on each lines..... it should be dynamic
for example
In report
Suppose in dialog, i have selected
Ledger account Busness UNIT Brand
1222502 000000023 001
1222503 000000025 002
So, it should display all Ledger account which having business and brand. Based on the dimension set selection , the columns should create dynamically.
please give me more shed on this.
thanks!
Hi @rp@n,
Do you need to show dimension values for each line based on the selected dimension set (in separate columns or combined column)? Do you need to implement groping by selected dimensions in dimension set?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (