Categories
- All Categories
- Oracle Analytics Learning Hub
- 19 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 232 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 87 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Add Expression Filter in Data Flow
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
Answers
-
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
0 -
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.
0 -
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.
0 -
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)0 -
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
0 -
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.
0 -
Version: 105.3.0-100 0 -
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.
0 -
This is fixed in the upcoming version and you should be able to save the filter expression.
0
