My Oracle Support Banner

E1: CAF1: How to Map a Power BI Report link with Dynamic Filter Parameter in a CafeOne Layout (Doc ID 2669017.1)

Last updated on MAY 12, 2020

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.

Goal

Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.

A CafeOne layout with URL content is design to dynamically link to Power BI reports.

The following shows an example of a Power BI Report URL link with dynamic filter:

  

When adding filters onto an embedded link for power BI this is the syntax:

    URL?filter=Table/Field eq 'value'
 
   
In this example,  &filter=pCompany/pCompany eq 34   where 34 is the dynamic link value from the Branch/Plant column in E1 form.
It requires an eq instead of an =, but CafeOne does not recognize that as a Parameter ending point so the Parameter ends up being "Filter", and the value gets filled in as the Power BI parameters instead of the dynamic value that need to pass into the syntax (in this case 34).

  


Is there a way to map that value to the correct parameter (&filter=pCompany/pCompany eq)?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.