Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Add Expression Filter in Data Flow

Received Response
443
Views
9
Comments

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

Capture06.JPG

Welcome!

It looks like you're new here. Sign in or register to get started.

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 :) 

    Capture.PNG

  • 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.

  • Rank 6 - Analytics Lead

    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.

  • 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)

  • Rank 6 - Analytics Lead

    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

    Capture10.JPG

  • 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.

    Capture.PNG

  • Rank 6 - Analytics Lead
    Version:   105.3.0-100
  • 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.

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

Welcome!

It looks like you're new here. Sign in or register to get started.