how to create delta measure on union query

Tony_OAS_Apex_User

i have created union with measure in different year and want to compare that two years and get a delta column in union when it gets showing on pivot.

product                FY2020               FY2019            Delta

------------------------------------------------------------------------------

Toy                      1650                      1630               ?

Electronics          45000                    54200             ?

any idea?

thanks.!

Gianni Ceresa

Why a union in your analysis instead of a simple analysis getting the 2 years ?

A union disable many features of OBIEE, so it's generally the last option ever you try when there is no way to get things without.

Are FY2020 and FY2019 in different business models?

Tony_OAS_Apex_User

Thanks Gianni,

Yes, I came to a last option ..

yes it's from different models.

[Deleted User]

user2074645 wrote:Yes, I came to a last option ..

What did you try before? Which approaches did you do?

Joel Acha

Have you used a result column to calculate the delta?

@Gianni Ceresa

As @Gianni Ceresa mentioned, it may be a better option to federate the data in the repository so that you get all the data from a single logical fact and dimension and therefore, a single analyses without any set operation required.