RAM Usage much larger than Cubes

Post Reply
Mark2007
Posts: 25
Joined: Tue Jan 07, 2014 12:07 pm
OLAP Product: Cognos TM1
Version: 10.2
Excel Version: Excel 2010

RAM Usage much larger than Cubes

Post by Mark2007 » Fri Jul 12, 2019 9:42 pm

Hi there,
I've a question regarding RAM-Usage. My Application is running Planning Analytics 2.0, Windows Server 2016

Task Manager shows it's RAM usage ~25 GB
}Stats by Server also shows total RAM of 25 GB, Garbage ~11 MB
}Stats by Cubes shows total RAM for all Cubes ~ 5GB
Dimensions size in Total is ~ 6 GB

So, Cube 5 GB + Dimensions 6 GB => where can I find the difference between 25 GB RAM in Total?

Thanks in advance!

Mark

User avatar
paulsimon
MVP
Posts: 694
Joined: Sat Sep 03, 2011 11:10 pm
OLAP Product: TM1
Version: PA 2.0.5
Excel Version: 2016
Contact:

Re: RAM Usage much larger than Cubes

Post by paulsimon » Sat Jul 13, 2019 10:59 am

Hi Mark

Have you recently upgraded to PA? If so, it is probably due to MUNs. From memory the topic that I raised on this was called something like Planning Analytics using twice the memory. Do a search and you should find it. Unfortunately there is nothing you can do about it other than buy more RAM.

Regards

Paul Simon

User avatar
Alan Kirk
Site Admin
Posts: 5928
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2 Classic (PAW-free zone)
Excel Version: 2010 and 2016
Location: Sydney, Australia
Contact:

Re: RAM Usage much larger than Cubes

Post by Alan Kirk » Mon Jul 15, 2019 4:56 am

paulsimon wrote:
Sat Jul 13, 2019 10:59 am
Hi Mark

Have you recently upgraded to PA? If so, it is probably due to MUNs. From memory the topic that I raised on this was called something like Planning Analytics using twice the memory. Do a search and you should find it.
It can be found here, in fact. I've also added it to Miss Havisham's favourite thread, the FAQ one. When I have a moment I think I shall don a hazmat suit and go in and clean that thing out. I'm not sure that anyone cares overly much about 8.4 any longer. I don't want to dump the older entries but I think they need to be archived somewhere, with some fresh blood flushed into the thing.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.

Mark2007
Posts: 25
Joined: Tue Jan 07, 2014 12:07 pm
OLAP Product: Cognos TM1
Version: 10.2
Excel Version: Excel 2010

Re: RAM Usage much larger than Cubes

Post by Mark2007 » Mon Jul 15, 2019 5:56 am

Thanks, specially to Paul. It was the right hint and your tool to derive number of elements an number of Member Unique Names (MUN) was a great help!

I modified it a little bit:
a) it gave errrors when a dimension had no elements
b) it had problems with special signs (that should not be used, I know ) as ä, ü, ö

might be it helps someone else, too.

Mark
Attachments
TM1DimElemAndMUNCountLister_004.zip
(34.55 KiB) Downloaded 3 times

Post Reply