Rule from different dimension with same elements.

[charan]

Hi,
I have requirement like this are the dimesnions in two different cubes,

Cube1; Cube2;
1)Accounts 1)Accounts
2)Region 2)Region
3)UDI 3)UDI
4)Month 4)Month
5)Version 5)Version
6)Year 6)Year
7)Measure 7)Measure
the accounts and udi are with different hierarchy and remaining dimensions are same.
The requirement is in cube cube1 UDI dimension it has 1500 elements and cube2 UDI has 15 elements ,i need to fetch values of 15 elements from 1500 elements it should not be hard coded.
Cube2 UDI are target and Cube1 is the source.
I tried in writing a rule like
['Jan']=DB('Cube1',!Accounts,!Region,!UDI,'Jan',!Version,!Year,!Measure);
but it have given error like;
missing Region dimension.
Can please give me suggestions to correct my rule.

Thanks and reagards

TM1 9.5.2
Excel 2007

[tomok]

It is not physically possible to have two dimensions with the same name in the same TM1 server instance. With that in mind, the dimension names cannot be as you have listed. Please give us the correct names of all the dimensions in each cube and perhaps we can help you with your syntax problem. Without that I can only guess.

[charan]

yeah,
sorry for that, actually the requirement is like I expalined it is for supplier and provider.
The supplier data should follow into the provider, the only name changes in dimension are
Supplier_Acc
Supplier_UDI
Provider_Acc
Provider_UDI.
the remaining dimension are same.

[mattgoff]

I think tomok's comment was more general in that the best way to get help is to give us exactly the structure of your cube/dimensions (including the real names, there's not really any IP to be "lost" in that), exactly the rules (copy/paste, not a retype, including identification of which rule is in which cube), and exactly the error message you're getting (i.e. not "like" but the exact error). To answer your question with the information given we'd have to have several layers of speculation....

Matt

[charan]

thank you.
find the attachments for the cubes

[charan]

cube2

[qml]

Charan, this is not really what you have been asked to provide. Please read Matt's post again and provide the requested information. Without this no-one will be able to help you.

[charan]

what else you need, I provided my cubes both source and target with all the dimensions.

[qml]

give us exactly the structure of your cube/dimensions (including the real names, there's not really any IP to be "lost" in that), exactly the rules (copy/paste, not a retype, including identification of which rule is in which cube), and exactly the error message you're getting (i.e. not "like" but the exact error)

Screenshots of Cube Viewer views with parts of them paintbrushed out don't even begin to cover the above. It's not even possible to figure out the names or the order of the dimensions from that!

[charan]

those dimesnions are Occupancy and provider UBRs with same FSIs and remaining dimensions are same.

Now my requirement is from Occupancy cube i want fetch the data into provider.

Give me clues how to write a dynamic rule for that or help me.

thank you

[tomok]

I can't speak for the others (but I'm pretty sure they feel the same). I am done with you unless you provide what has been asked for, repeatedly. In case you haven't noticed, this is free help. I don't know about you, but when someone is willing to provide me free help, I bend over backward to give them what they need out of respect for them taking time out of their busy day to give me assistance. This isn't a subscription forum. You paid no money to join and we receive no money to help. I don't have time to put together piecemeal information from a poster who is too lazy to, at a minimum, provide the basics, in a format that is easy to follow and understand. I believe your problem could have easily been solved days ago if you would have provided the correct information. You have one last chance from me. This is what I need:

Cube 1
Dimension 1
Dimension 2
Dimension 3
.......
Dimensionx

Cube2
Dimension 1
Dimension 2
Dimension 3
.......
Dimensionx

Exact rule statement that is giving you the error.
The exact error message

Do not provide pseudo names for any of this information. I NEED THE EXACT NAMES.

[Gregor Koch]

Hi
Apart form that the details are needed to give you a 100% answer (and to get an answer at all from some), here are a few pointers:

I have requirement like this are the dimesnions in two different cubes,

Cube1; Cube2;
1)Accounts 1)Accounts
2)Region 2)Region
3)UDI 3)UDI
4)Month 4)Month
5)Version 5)Version
6)Year 6)Year
7)Measure 7)Measure

['Jan']=DB('Cube1',!Accounts,!Region,!UDI,'Jan',!Version,!Year,!Measure);

This obviously won't throw an error as you have not listed the dimensions as they really are.

But if I look at the title of the thread and put that together with the (pretty random) other list of dimensions you listed I can tell you as much.

Say this was really the case:
Cube1; Cube2;
1)Accounts 1)Accounts
2)Region 2)Region
3)UDI 3)Supplier_UDI
4)Month 4)Month
5)Version 5)Version
6)Year 6)Year
7)Measure 7)Measure

and your rule resides in Cube2.

When you use the 'Edit Formula' function in your rule (in cube2) and point that to Cube1 it will sort of automatically create what you showed in your first post.
['Jan']=DB('Cube1',!Accounts,!Region,!UDI,'Jan',!Version,!Year,!Measure);

Yes, you have picked 'Jan' but that is not really necessary. What is necessary is to change the rule to use the dimensions from your target cube (cube2) because a !UDI won't work here as it does not exist in that cube.
What you can and should do though, given that the elements in 'UDI' and 'Supplier_UDI' are the same (and the order is as listed above) is to change the rule to

['Jan']=DB('Cube1',!Accounts,!Region,!Supplier_UDI,!Month,!Version,!Year,!Measure);

(maybe you don't even need Jan on the left side but that I really leave aside)

TM1 will then 'look up' the elements from the Supplier_UDI dimension in the UDI dimension.

Good luck.

[charan]

thank you.
but still it is giving an error the dimension you see in the occupancy cube are same in provider but it is named after provider_UBR and Provider_FSI,the only difference is elements are more in occupancy cube.
After writing the rule the error is, find the attachment,

[Gregor Koch]

Yep and I am with tomok now.
I really tried and I am sure that with the given information you could solve the problem.
If you can't you need to provide the information as described by others.

[charan]

I have given full information now you see all the dimesnion within,
and I tried by wiriting rule for Jan, but still not able get the requirement.

[tomok]

When you write a rule using the DB function all the following conditions must be met:

1) A value must be provided for all the parameters (the cube name and an element from each dimension, or variable that resolves to an element from each dimension)
2) If you use a variable (with the ! notation) that dimension must exist in the cube the rule is being written in.

It appears as if you have violated both conditions.

[charan]

thank you.
I tried with this also as only ubr abd FSi are different dimension in the cubes, for this i have selected single element from the dimension, where as remaining dimensions are same.
The result is like hard coding only the selected element values are fetched from occupancy cube to provider cube.
The rule should be dynamic.

[tomok]

Read my post again. Did I say anything about hard-coding anything? When you denote a dimension element with the syntax !DimName then that is not hard-coding, that is a variable that says "plug in the relative element". However, when you use the !DimName syntax, the DimName portion of the formula has to exist in the cube you are writing the rule in. Comprende? Not only that, but you have to provide a parameter for every dimension in the cube and in the exact same order as the dimension exist in the cube!

Writing this rule:

['Jan'}=DB('Occupancy_cube','Occupancy_UBR,!Occupancy_region,!GBS_month,!GBS_Version,!GBS_Year,!Occupany_FSI');

for the Provider cube is invalid because the Occupancy_UBR, Occupancy__region and Occupancy_FSI dimensions don't exist in the Provider cube. Also, whatever happened to the Accounts dimension you mentioned in the first post????

You should substitute "Provider_" everywhere in the rule where you have "Occupancy_" for starters. Whether that will solve you problem is anyone's guess considering the fragmented and fractured nature of this god-forsaken thread. 17 posts for something that could have been solved in 2 must be some sort of record.

[Gregor Koch]

I have given full information now you see all the dimesnion within,
and I tried by wiriting rule for Jan, but still not able get the requirement.

Uhm... really?

Cube 1
Dimension 1
Dimension 2
Dimension 3
.......
Dimensionx

Cube2
Dimension 1
Dimension 2
Dimension 3
.......
Dimensionx

In order as they are in the cube. And in which of those cubes does the rule sit plus sample rule for that cube.
It's not hard. I am just not going to look at all sorts of screen shots and try and figure out where what is and what the dimension order is.

[charan]

help me.