How to make a dashboard prompt work with a custom logical sql?
I have created a custom logical sql, because I needed an outer join between two Subject Areas(Payables Invoices - Transactions Real time and Payables Payments - Disbursements Real Time).
It works fine, but I'm a little bit confused on how to make this custom sql work with a dashboard prompt, as it should be part of a dashboard, with lots of other analysis, that is 'just' created from standard Subject areas...
How do I make this custom logical sql work with a dashboard prompt? I have attached a catalog file with the dashboard and it is the Invoice Number in the DB Prompt, I want to be applied to the column "s_9" in the analysis...