https://community.oracle.com/tech/apps-infra/discussion/comment/16858528#Comment_16858528 Hi @Federico Venturin I used the SUM with Casting as follows : SUM(cast("Fact"."FTE" as DOUBLE)) And it worked. its not possible to SUM without casting .. Thank you !

Hi, Thank you all so kind of you . It didn't resolve my issue, see pictures:

Hi @Federico Venturin, Thanks for the reply yes the field is varchar in RPD I edited the Formula as : Cast("ColumnName" as Double) and still it didn't aggregate. what is <Put any measure here> ? I have only one column, there is no need for Two conditions here... the only values this column has in 'null' as a string and…

Dear Christian, I am sorry, I am having a hard time understanding the RPD way of working . Does BMM layer support snowflake ? if not, then you have to convert the snowflake to a star schema? in this case there are two options : 1) Bring the columns from the second dimension(Level 2) into the main dimension (in this case…

https://community.oracle.com/tech/apps-infra/discussion/comment/16843516#Comment_16843516 Dear Gianni, Thank you for the assistance! I have one more question : Do I have to make joins between RPD tables(In physical layer) or is there an option to make relationships like other tools do (Power-BI/Tableau) ? I mean…