4
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?
#1
André Arnaud de Cal...
292,886
Super User 2025 Season 1
#2
Martin Dráb
231,768
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
