You can create an analysis which includes your variables though. Just confirmed with a PORTALPATH session variable.

I don't like your chances of getting this version working with multi-factor authentication even if you get https working. HTTP here so can't test HTTPS.

ODBC/JDBC is there Waterfall charts + some other viz Some other connectors e.g. OBI Subject Areas

Is that really what the tool is for though? I feel like if you need that sort of (amount of) data integration you should be doing it somewhere else and using the output as a data source.

It came out this morning (Australia time) Oracle Data Visualization Desktop Downloads

Do want the user to pick a month and then your query runs for the last day of the previous month? I only use BIP within OBIEE so might not be on the right track but in my scenario I could have a prompt/parameter for the value and then use it in the query e.g. MyDateColumn < LAST_DAY(ADD_MONTHS(:PROMPTDATE,-1)) to get last…