Page 1 of 1
How to identify overfeeding
Posted: Thu Jan 16, 2025 7:44 pm
by M1ndbender
Good day all,
I have tried the shadow cube technique from CubeWise to identify overfeeding and either it is not working or I am not overfeeding (which I find hard to believe)
Does anyone have any other tips/tricks to identify overfeeding. I am basically looking to reduce feeder file sizes to decrease the overall instance size.
I have tried to find page 147 from the IBM Cognos TM1 The Official Guide that I have seen referenced in a lot of places with no luck.
Any advice would be appreciated
Bret
Re: How to identify overfeeding
Posted: Sun Jan 19, 2025 6:02 am
by Elessar
Hello, this was asked many times on this forum:
viewtopic.php?t=16766
Re: How to identify overfeeding
Posted: Sun Jan 19, 2025 4:31 pm
by Adam
And the asker always disappears when help is offered.

Re: How to identify overfeeding
Posted: Mon Jan 20, 2025 5:46 pm
by M1ndbender
Thanks for the advice. I have tried the steps on a few of those links and always got a zero or no overfeeding back (which cant be true)
I will try the other listed in that link and see how it goes
Thanks again
Re: How to identify overfeeding
Posted: Wed Jan 22, 2025 9:30 am
by Steve Rowe
Let's start at the beginning then.
What are the symptoms you are experiencing that lead you to believe you are overfeeding?
Re: How to identify overfeeding
Posted: Tue Feb 11, 2025 4:56 pm
by M1ndbender
mostly cube size. We are running into issues with the server getting too close to its limit and I thought one thing I could look at was cube sizes.
Re: How to identify overfeeding
Posted: Tue Feb 11, 2025 6:42 pm
by gtonkin
Have a look at
this article, specifically the section showing }StatsByCube.
I create the calculated member Memory per Populated Cell to give an indication of whether or not reordering dimensions may help.
Over 30 could prompt further review but it is not quite that simple as each dimension needs bytes for the pointer and the bigger the dim, the larger the pointers etc. The view may also give an indication of feeding issues.
Another option may be this:
Code: Select all
DebugUtility( 123, 0, 1, pPath|'\Model_Information.txt', '', '' );
e.g. DebugUtility( 123, A, B, 'Model_Information_0_1.txt', '', '' );
A = 1 suppresses control objects
B = 1 includes additional feeder/cell information