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

Add Expression Filter in Data Flow

Brian666H

Summary

Trying to add Expression Filter in a Dataflow

Content

I have a Data Flow with one column. I want to SUM all values that are under 10.00. I get an error.

"Data element syntax incorrect, fully qualified path required. Example: "Sample Sales"."Facts"."Revenue""

See images

X_PAID_AMT >= 10.00

Version

18 , Cloud

Find more posts tagged with

Analysis

Prepare and Model Data

Accepted answers

All comments

Gianni Ceresa

Hi,

Looks like the "expression" box has some issues in the validation. The column name is auto-completed while writing it, therefore it's right, but the expression expect the fully qualified name of a column (which at this point not sure what it could be as this step isn't based on a source directly but another step before).

As alternative could you maybe use the "standard" filter for that kind of logic? It works at least

Gianni Ceresa

Looks like a fresh issue as it was working fine in OAC 105.1.0-217, while I have your same error in 105.3.0.

Brian666H

Bad screenshot on my part. We need less 10 or less "value<= 10.00" I did try the range. No error but the results were not right.

Question where do I find the OAC version. All I can find is the ADW version.

Gianni Ceresa

I see it in the cloud "My Service" console page, where I can start/stop the whole service. Still couldn't find the proper info in the front-end

In my few tests the range one did work (using only one of the 2 range to get it act as simple >= or <= and not like a BETWEEN).
Ideally you would need to raise a SR reporting the issue, as it's a regression hopefully they can fix it quite easily.
(As I don't have a 105.3.0 right now in my own account I couldn't open the SR myself at the moment, will try to find a different way to get the info to Oracle)

Brian666H

This is the screen I get when I open My Service (see image). I can't find a version number. Odd. Yes I'll open an SR

Gianni Ceresa

If you go in "Analytics" you will see a list of the instance you currently have. Click on the instance name representing the one you are using and there you must see the version.

Brian666H

Version:

105.3.0-100

Gianni Ceresa

Keep applying updates when they are available for that instance.

I tested in a new release preview and it is fixed, you will be able to use the expression filter without the error.

Lalitha Venkataraman-Oracle

This is fixed in the upcoming version and you should be able to save the filter expression.