How to create prompt dashboard that accomodate same column name from different subject area
Summary
Create prompt dashboard to accomodate 2 different subject areaContent
Hi..
I have OTBI dashboard report that has 2 content report and each content comes from different subject areas, ex: content 1 from General Ledger - Journals Real Time subject area and content 2 from Payables Invoice - Transaction Real Time. Some of the column name are same, such as accounting period name, currency, accounting year, account code.
How could i create a dashboard prompt, that will filter both content? Let's say if i want to filter by account code, even the column name is same "account code", but account code's content 1 comes from "Journal Lines/Natural Account/Account code" and account code's content 2 comes from "Distribution/Distribution Natural Account Segment/Account code"
1