How to identify overfeeding

[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

[Elessar]

Hello, this was asked many times on this forum: viewtopic.php?t=16766

[Adam]

Hello, this was asked many times on this forum: viewtopic.php?t=16766

And the asker always disappears when help is offered.

[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

[Steve Rowe]

Let's start at the beginning then.

What are the symptoms you are experiencing that lead you to believe you are overfeeding?

[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.

[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