Sum on TM1 Cube

[Jorge Rachid]

Hi guys,

I am facing doubt on trying to sum the amount of the same client in a cube as screenshot below.

In another cube, the customer will choose the "cliente" from a picklist, and I would like that after that the cube get the total value of this "cliente" selected, considering all rows that "cliente" is the same.

I tried to create another cubes to help me but it is not working.

Does anyone have an ideia of how to do this?

Thank in advance,

JR

[paulsimon]

Hi

Make client a dimension instead of a measure and it is easy. At present you have the wrong structure

Regards

Paul Simon

[declanr]

Create a cube (as Paul suggested) with an extra dimension for "client" - this cube can contain all the same other dimensions as the cube in your screenshot and then is simply update by rules that say if the client measure in source cube for "Cliente" is equal to the client element in your dimension then populate "valor bruto" if not then 0.

This extra cube can be hidden and no one actually needs access to it; then in the cube you were going to create anyway; where they select client from a picklist - have that populate the value by looking up the hidden mapping cube.

[kangkc]

If you are on PA, store the client name as attribute and use the attribute as hierarchies. But again this will only work with PAx, Workspace but a more efficient and memory friendly way.

[Jorge Rachid]

Thanks for the reply guys.

I will try this now and if I can't I send a new message.

Thanks a lot,

JR

[Jorge Rachid]

Hi guys,

It worked. Thanks a lot for helping me.

See ya,

JR