You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to make a dashboard prompt work with a custom logical sql?

in Reporting and Analytics for ERP 5 comments

Summary:

Hi

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...

Content (required):

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...

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!