Fusion Analytics Tech Tips :Dynamic parameters - Creating custom Calc & Prompts based on logical Sql

Abhishek Bajpai - CEAL Team-Oracle

https://videohub.oracle.com/embed/secure/iframe/entryId/1_6zi1aedt/uiConfId/35965902

The video is the continuation of the community post

https://community.oracle.com/products/oracleanalytics/kb/articles/21-dyanmic-parameters-prompts-and-parameters-in-fusion-analytics-s-data-visualization

We further explore the power of dynamic parameters - Creating prompts using logical sql and creating custom calculations

Abhishek Bajpai - CEAL Team-Oracle

@Jamie Anderson - Thanks for kind words this is the second part of the video

CarolineAnderson

Hi @Abhishek Bajpai -CEAL Team-Oracle ,

This video was really helpful for getting logical SQL parameters to work for me! I've finally gotten the drop down menu to work how I'd like it to.

The part I struggle with is defining the parameters that use Logical SQL in custom calculations so I can put the selection into a table or visualization. I was wondering if in a further video you could show the 'Ledger' calculation you used for the columns in the second example? Thanks!