nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

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

Find more posts tagged with

Prompt

Parameter

Oracle Fusion Analytics

Customizing Reports

Fusion AI Data Platform

Comments

Abhishek Bajpai - CEAL Team-Oracle

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

Caroline Blanchard

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!