Measure is not displaying sum as aggregation option

[Former Member]

Hello.

I added a table with the cost which I want to join with my fact table.

I created an analytic view with both tables and made the join by material, when the cost measure is added to the output in the semantic layer is not treated as a measure but like an attribute or something else because it does not let me choose sum as aggregation at report level.

What am I doing wrong??

At report level, the measure only allows count as aggregation:

Thanks in advance.

[Former Member · Accepted solution]

Hi Victor,

When you click "Semantics", you can choose "Attribute" or "Measure" in the "Type" column and choose "SUM/COUNT/MAX/MIN" in the "Aggregation" column.

Best regards,

Wenjun

[Former Member · Accepted solution]

Thanks for the response.

Indeed the field was not set as measure but when I try to activate the view I get this error:

[Former Member · Accepted solution]

I think I found the root of my problem, this post helped me:

I still have to learn a lot.

thanks everyone.

[former_member182302]

Can you share the snap shot of the semantics and let us know if it is marked as attribute or measure?

Also frame a query from SQL console and see if you are getting proper results.

Regards,

Krishna Tangudu