Dear Community,

i have a little problem setting up an ETL process, for my Palo Project.

What i'm facing are several cube with various dimensions including a time dimension. The measure dimension of my transaction data cubes consists of various values and three other date-values. In simple, I would like to take a date of the measure dimension and turn it into the time dimension of another cube. First question, is it possible? And if it's possible, which transform-functions have to be chosen? I've tried a lot but I wasnt able to find a solution yet.

Summary: Cube 1: Date (Measure) --transform --> Cube 2: Date (Dimension)

Thanks in advance for all suggestions.

Greets,

Peter.

i have a little problem setting up an ETL process, for my Palo Project.

What i'm facing are several cube with various dimensions including a time dimension. The measure dimension of my transaction data cubes consists of various values and three other date-values. In simple, I would like to take a date of the measure dimension and turn it into the time dimension of another cube. First question, is it possible? And if it's possible, which transform-functions have to be chosen? I've tried a lot but I wasnt able to find a solution yet.

Summary: Cube 1: Date (Measure) --transform --> Cube 2: Date (Dimension)

Thanks in advance for all suggestions.

Greets,

Peter.

Post was edited 1 time, last by “Peter Parks”: Solution found. ().