Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

DV Version 12.2.4.1.1- Data Flows

Received Response
91
Views
8
Comments
Roberta Tagliatti
Roberta Tagliatti Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

Summary

DV Version 12.2.4.1.1- Data Flows

Content

Hi Everyone,

 

I created a Data flows to remove a column (Concatenate) . After that I created a new project and all the measures have become alpha.

 

 

Data Source Excel File After data flows

 

Could you please tell me how can i solve this problem?

Thanks

Answers

  • Doug Ross
    Doug Ross Rank 6 - Analytics Lead

    I have seen the same behavior with a number of different steps in the Data Flows.  It converts numeric values to text.

  • Roberta Tagliatti
    Roberta Tagliatti Rank 2 - Community Beginner

    Do you solve the problem? How you solve this one?

    Thanks

  • Luke Sharma
    Luke Sharma Rank 4 - Community Specialist

    No problem, please will you mark the answer as correct so this discussion is resolved?

  • Roberta Tagliatti
    Roberta Tagliatti Rank 2 - Community Beginner

    Problem solved.

    Thank.

  • Luke Sharma
    Luke Sharma Rank 4 - Community Specialist

    Hi - well if you would want the values to be measures straight out of the data flow, use the Aggregate function in the data flow and set aggregations on the columns that you want to be measures on output. This should resolve your problem. Aggregating a column usually outputs a measure rather than an attribute. Do the Aggregation in the final step before you save the data set.

  • Luke Sharma
    Luke Sharma Rank 4 - Community Specialist

    Hi there! It seems to be changing all of your values to attributes. If you go to the data tab and select the newly created table, and "Edit" it, you can find the columns that should be measures and right click, you can very easily change the properties of them (including change data type) e.g.

    changing data type.JPG

    Please let me know if this helps you, and if you have any further questions!

  • Doug Ross
    Doug Ross Rank 6 - Analytics Lead

    Yes, but that doesn't explain why it happens in the first place.  What is causing numeric values to become text?  No reason for that.

  • Gabby Rubin-Oracle
    Gabby Rubin-Oracle Admin

    The Aggregate workaround will work, but we are going to treat it as an issue and resolve it in an upcoming release.

    Thanks,

    Gabby