i have made this query and add default dimension range to bankvaccounttable but in dialog form even i dont select any business unit , it showing data only in bank account if business unit is added
query buildQuery() { QueryBuildDataSource qbdsBankAccountTable, qbdsBankAccountTrans,qbdsDefaultDimensionView;//qbdsDimensionAttributeValueSet,qbdsDimensionAttributeValueSetItem,qbdsDimensionAttributeValue,qbdsDimensionAttribute; Query query = new Query(queryStr(OABCashBook)); qbdsBankAccountTable = query.dataSourceTable(tableNum(BankAccountTable)); qbdsBankAccountTrans = query.dataSourceTable(tableNum(BankAccountTrans)); qbdsDefaultDimensionView = query.dataSourceTable(tableNum(DefaultDimensionView)); qbdsBankaccountTrans.addRange(fieldNum(BankAccountTrans, TransDate)).value(queryRange(fromDate, toDate)); qbdsDefaultDimensionView.addRange(fieldNum(DefaultDimensionView, Name)).value('BusinessUnit');
Hi Sachin, That would be because you have added range on Business Unit. Please move business unit range in a if condition. If there is value in business unit from dialog then only range should apply.
André Arnaud de Cal...
292,111
Super User 2025 Season 1
Martin Dráb
230,934
Most Valuable Professional
nmaenpaa
101,156