Loading cube from other cube with different number of dims

[itsme_maverick]

Hello All,

We are planning to load a target cube with 4 dimension from a source cube of 3 dimensions.Example shown below

Source_cube
Dimensions - Product, Period, Discount
P1,2010Q1,10
P2,2010Q2,25

Target_cube ( Data required)
Dimensions - Customer, Product, Period, Sales
Cust1,P1,2010Q1,10
Cust1,P2,2010Q2,25
Cust2,P1,2010Q1,10
Cust2,P2,2010Q2,25

In target, every element of customer dimension should get the entire set of source data.

Can you please suggest as how we can achieve this?
Thanks in advance

[mattgoff]

What sorts of things have you tried so far and/or how do you think you could solve the problem? Illustrating that you've at least tried is going to get you more help around here.

Matt

[itsme_maverick]

I created a TI process to load the target cube with 4 dimensions from source cube of 3 dimensions. In Variables tab, I defined a extra parameter to avoid the error of inconsistent number of dimensions.
The extra variable had a formula defined ='dummy'. But it does not seem to work as it is looking for 'dummy' element in target dimension.

[Martin Ryan]

How is TI supposed to know which customer the data goes to?

[mattgoff]

If you really want to load the same data to every customer, you can use DIMSIZ and DIMNM to loop through every element in your customer dim in each run of your Data tab.

Matt

[David Usherwood]

I think it's very likely your design isn't right. If you need to use the discount in the target cube just write a rule. DONT feed the rule from the source cube, just use it in your calculations.