How to ... compare two different dimensions

[Former Member]

Hi everybody,

I have following topic: in a MultiCube there are two key figures with two different units of measure

1) from InfoCube 1 -> ZZKWMEN1 with 0BASE_UOM units and

2) from InfoCube 2 -> ZG_Qvvm01 with ZG_Uvvm01 units

when I start a report / query then there are two rows:

InfoCube1 InfoCube2

0Base_Uom -> 100 ST

ZG_Uvvm01 -> 150 ST

How is it possible to unify those two lines and report them as one row with only one unit dimension? Dimension 0UNIT or 1CUDIM doesn't work properly.

Function NODIM doesn't help a lot, because there could be another Units as well.

Do you have any idea?

Thank you very much

Standa

[Former Member · Accepted solution]

Hi Standa,

May be I'm completely misunderstanding your isuue, but why don't you just create a calculated KYF adding ZZKWMEN1

snd ZG_Qvvm01 ?

Regards

Joe

[Former Member · Accepted solution]

Thank you Joachim,

of course, I forgot to mention it. I did create a calculated field. My query result is:

KYF A = ZZKWMEN1 + ZG_Qvvm01

IP1 IP2

Units KYF A KYF A

ST # 150

1. ST 100

Two lines because there are two different Unit-Dimensions.

How to create from this result only one line??

Thank you

Standa

[Former Member · Accepted solution]

Hi Standa,

I actually completely misunderstood

I think there is no way to resolve this issue in a multi provider scenario. An option could be creation of a new cube using

existing cubes as datasources and introducing KYFs with

identical unit of measurement. Then restrict UOM to desired

value and you are able to compare KYFs.

Please let me know, if there is a more convenient solution.

Regards

Joe

[Former Member · Accepted solution]

Hi Joe,

i was afraid to resolve the issue only by doing this, but was hoping to get real bi solution, not another data copy.

If there isn't any other chance, i will do it. This is probably the solution.

Thank you

Standa

[Former Member]

hi,

i guess u can use constant selection option here.

reward points if helpful.

regards,

rakesh.

[Former Member]

Of, course, Rakesh,

a constant selection would be fine as well, but only in this example. We have different currencies and of course more units as well. The query should stay at least a little bit flexible.

Standa

[Former Member]

Solution is either to use Function NODIM() but better is to use currency translation on two different columns to one currency and then define on them a formula

=translated column1

=translated column2

Then difference between these two columns could be created.

Standa