Palo Community Forum

Dear All,

still quite a new user I am so far quite ok with working with basic Palo, but now that I go into more compley topics, I do need your advise basically on how to link different sources of information in one or several cubes.
Lets say I do have several input sources like:

Source 1: Dimensions (Country, Month (consolidated to year), Customer Number, Transaction Currency and Transaction Describtion) --- Sales Quantity and Revenue per transaction (several per month per customer)

Source 2: Dimensions (Country, Month, Customer Number) --- Outstanding payments at the end of the month

Source 3: Dimensions (Country, Year) --- Market Size per year

So my point where I am now is that, as you see, I do have repeating dimensions in the 3 sources, however never the same dimensions.

My aim is later to compare via a subset e.g. in month May which customer had the highest revenue but also the highest outstanding payments, or per year in which country was the highest revenue compared to the market size.

Thank you for your help and advise.
Bassanio

Dear Holger,

thank you for your fast and helpful answer. All cubes are now created and data is uploaded. Just to make sure: I have so far put all "key numbers" like revenue or market size in one dimension called measures. Is that for future analysis the correct way or shall I create 3 different measures dimensions where I will upload the data from every input source?
And how will it be possible for me to spread the subset over 2 cubes?
Or would it be more helpful to create only one cube in which, in case that e.g. "Transaction Currency" is not available in Source 3, I here refer this value in the Setdata forula to a value called "Total".
Thank you and a Happy Easter Holidays to everybody in the Forum...

Bassanio