Sum on TM1 Cube

Post Reply
Jorge Rachid
Posts: 113
Joined: Fri Jul 22, 2016 8:33 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013

Sum on TM1 Cube

Post by 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
Attachments
View of the cube
View of the cube
Cube.jpg (294.13 KiB) Viewed 3691 times
User avatar
paulsimon
MVP
Posts: 808
Joined: Sat Sep 03, 2011 11:10 pm
OLAP Product: TM1
Version: PA 2.0.5
Excel Version: 2016
Contact:

Re: Sum on TM1 Cube

Post by 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
MVP
Posts: 1815
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Sum on TM1 Cube

Post by 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.
Declan Rodger
kangkc
Community Contributor
Posts: 206
Joined: Fri Oct 17, 2008 2:40 am
OLAP Product: TM1, PA , TMVGate
Version: 2.x
Excel Version: 36x
Location: Singapore
Contact:

Re: Sum on TM1 Cube

Post by 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
Posts: 113
Joined: Fri Jul 22, 2016 8:33 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013

Re: Sum on TM1 Cube

Post by 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
Posts: 113
Joined: Fri Jul 22, 2016 8:33 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013

Re: Sum on TM1 Cube

Post by Jorge Rachid »

Hi guys,

It worked. Thanks a lot for helping me.

See ya,

JR
Post Reply