Calculated value doesn't display

[iansdigby]

Sorry to keep asking questions! As soon as I get the hang of these TM1 quirks I will try and help others by answering some. There are two parts to this query and I am really appreciative of the selfless help which the gurus on this forum give.

Imagine two cubes:
1. 'ProjectStatus' which has 5 dimensions, (Project, Status, Code, Person, Week, Measure)
2. 'ProjectBudgets' which has 2 dimensions (Project, Measure)

We wish to populate 'ProjectStatus' with values from 'ProjectBudgets', so we used a rule as follows:

SKIPCHECK;
['Budget Hours']= N:DB('ENGINEERING_ProjectBudgets', !ENGINEERING_Task, 'Budget Hours');
FEEDERS;

Where are the feeders you may ask? I don't know how to derive them. Logically, I think, one would use an inter-cube feeder, but how to supply information for the missing dimensions in the destination cube? Perhaps multiple feeders, one for each element of the missing dimesions? This would mean hundreds of separate feeders.

Without SKIPCHECK it is just too slow loading, but without feeders, we come to part 2 of this query: the calculated ['Budget Hours'] values are invisible unless we turn off zero suppression, which then results in a display of millions of zeros!

I hope this all makes sense and would greatly value any insights anyone may have into this problem.

Ian Digby

[Steve Rowe]

Hello again!

Two options
If you only want the Budget hours visible when some other measure in the Project Status is populated (from another source) then you could feed with that measure.

So in the Status cube you would have

['Some Measure Thats Populated and Is the Dataset that I care about']=>['Budget Hours'];

I'd prefer that option if possible

or
You need to have a either a total or an explicit reference to all the extra dimensions in Status that are not in Budgets and then your feeder in the Budgets cube is

['Budget Hours']=>DB('Project Status', !Project, 'status - failed due to lack of interest', 'AllCodes' ,'Allpeople','Allweeks', 'Budget Hours');

This option is going to be nasty and I would think to you having values where you don't want them...

HTH

[Martin Ryan]

Hi Ian,

You can also take a look on this article on feeders, which may help you a bit: http://wiki.olapforums.com/index.php?title=TM1_Feeders

Regards,
Martin