hierarchy dimension and total element

Post Reply
compilersaysyes
Posts: 9
Joined: Fri Oct 24, 2014 11:08 am
OLAP Product: TM1
Version: 10.2
Excel Version: 15.0.4659.1001

hierarchy dimension and total element

Post by compilersaysyes »

Hi, I am new to TM1 and hope that someone help me with a problem.

Is it possible to remove 'total element' from a hierarchy dimension? All attempts at doing this fail - after executing the process, the 'create total element' box goes back to being ticked, so I assume that this is the case.

Thank you for your guidance in advance.
Wim Gielis
MVP
Posts: 3240
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: hierarchy dimension and total element

Post by Wim Gielis »

Can you be more specific? What is your Turbo Integrator code?
What "Advanced" tabs in the process do you use ?
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
declanr
MVP
Posts: 1831
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: hierarchy dimension and total element

Post by declanr »

The OP is using Performance Modeller wizard to create the dimension as opposed to TI; hence the "Create Total Element" tick box. I've just tested this on an example in 10.2.2 though and left the box unticked when I set up the process; ran it and the dim was created without a Total. I then closed it all down and went back in and it was still unticked as it was when I saved it.

What exact version are you using? Can you post a screenshot of your "Maps" tab from PM?
Declan Rodger
Wim Gielis
MVP
Posts: 3240
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: hierarchy dimension and total element

Post by Wim Gielis »

Oh thanks, I did not realize the Performance Modeler part.
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
declanr
MVP
Posts: 1831
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: hierarchy dimension and total element

Post by declanr »

Just another thought on this, I haven't used PM much for this sort of thing but when I previously did some testing I found that it didn't always seem to like it when i changed an existing process. Did you originally create it with the "create total element" box ticked and then open it up and untick then save? If so I would try recreating from scratch but without ticking the box from the offset.... and then if that resolves it, you can definitely call it a bug and log it with IBM.
Declan Rodger
compilersaysyes
Posts: 9
Joined: Fri Oct 24, 2014 11:08 am
OLAP Product: TM1
Version: 10.2
Excel Version: 15.0.4659.1001

Re: hierarchy dimension and total element

Post by compilersaysyes »

Hello, thank you for your comments. I have attached a screenshot of the maps page. The total has a caption. Could this be causing the issue?

(I am trying to remove total element from the Grades dimension. I can untick the box just fine, but after saving, the box reverts back to being ticked.)

Thank you again
Attachments
screenshot.png
screenshot.png (320.66 KiB) Viewed 4177 times
Post Reply