TM1 Forum

How can i allow my expense cube to show actuals from nov to feb and show budget data values from march to october for our second quarter projection?Presently,the cube is showing the actuals data values for nov to feb.I want it to show the actuals values from nov to feb and show budget values from march to oct.

{Post reinstated by Admins from the archives. Please don't edit past posts in a way that makes them meaningless.}

EDIT: since the OP has deleted the original question it rather places things out of context which may be to the detriment of others who may find the thread useful if they have a similar question. Therefore I have quoted the original question verbatim, in case anyone should otherwise think I was either psychic or having a conversation with myself. No other changes were made to the answer.
(incidentally if the OP would like to provide an explanation as to why the thread was renamed and posts truncated to "How" and "Thanks", it would be appreciated, seems a little bizarre to me.)

segunfunwaoluwa wrote:How can i allow my expense cube to show actuals from nov to feb and show budget data values from march to october for our second quarter projection?Presently,the cube is showing the actuals data values for nov to feb.I want it to show the actuals values from nov to feb and show budget values from march to oct.

A common approach would be to create a 2D "control cube" that stores a parameter for the current year and month. You also have a version called "actbud" or "latest update" or similar with a rule in the reporting or planning cube along the lines of if a past month then get actual else get budget.

Thanks lotsaram,your reply is highly appreciated.Could you please write out the rule for me please?From reply,i will have to create a cube(must it be a control cube?)with 2 dimensions being the version dimension and which other one?I am relatively very new to TM1 hence i need all the help i can get.Appreciate your timely response.Thanks
Right now my Expense cube has the following dimensions in it:-
Expense Measures
Account
Activity
Cost Center
Months
Scenario
Fiscal Year
Currency
Version.
All of them have subsets in them.Please let me know which one of this dimensions to add to the version dimension for the cube mentioned and the the rule that will help in feeding this cube.Thanks.

{Edit: Post reinstated by Admins from archive copies.}

EDIT: since the OP has deleted the original question it rather places things out of context which may be to the detriment of others who may find the thread useful if they have a similar question. Therefore I have quoted the original question verbatim. No other changes were made to the answer.
(incidentally if the OP would like to provide an explanation as to why the thread was renamed and posts truncated to "How" and "Thanks", it would be appreciated, seems a little bizarre to me.)

segunfunwaoluwa wrote:Thanks lotsaram,your reply is highly appreciated.Could you please write out the rule for me please?From reply,i will have to create a cube(must it be a control cube?)with 2 dimensions being the version dimension and which other one?I am relatively very new to TM1 hence i need all the help i can get.Appreciate your timely response.Thanks
Right now my Expense cube has the following dimensions in it:-
Expense Measures
Account
Activity
Cost Center
Months
Scenario
Fiscal Year
Currency
Version.
All of them have subsets in them.Please let me know which one of this dimensions to add to the version dimension for the cube mentioned and the the rule that will help in feeding this cube.Thanks.

By "control cube" I don't literally mean a new control object (cube starting with "}"). This is just terminology or jargon that TM1 developers commonly use to mean a cube that holds parameter values that can be used to control behavior and calculations elsewhere in the model. I wouldn't think such a cube would include a version dimension, a "system parameter" dimension and a "measure" dimension would be enough. The "measure" dimension only needs to have one element ("string" or "value", although I usually like to include an additional "validation" element which is rule calculated to check that the data entry is valid.)

segunfunwaoluwa wrote:All of them have subsets in them.Please let me know which one of this dimensions to add to the version dimension for the cube mentioned and the the rule that will help in feeding this cube.Thanks.

I don't really know what you mean by this. Seems like you are getting your terminology confused on several fronts.

If you are new to TM1 then I would suggest sitting down with a colleague or consultant to go through this in more detail. Note the solution includes (roundabout) reference to a 2nd "helper" cube the "system time" cube (or cubes) which you may hear others refer to as a "zDates" cube. This is very useful, I would say essential for doing or at least simplifying many time based lookup calculations. The system time cube reference in this case is a numeric value called "index" assigned to each year-month combination in sequential order, the parameter cube then also contains a rule derived value of the "last actual month index" which is looked up via rule from the system time cube. Doing this once and once only in the parameter cube then makes all such rules in all other cubes much simpler and is also much more calculation efficient.

['Version':'Rolling ActBud'] = N:
IF( DB('SYS_Time_YearMonth', !FiscalYear, !Months, 'Index') <= DB('SYS_Parameters', 'last actual month index', 'Value'),
['Version':'Actual'],
['Version':'Budget']
);

(NOTE: if the level of detail that actual and budget is stored are different from each other then likely you would need the full DB() notation not square brackets which would complicate the rule but if everything is the same level of detail then it's all quite simple.

Feeders;
['Version':'Actual'] => ['Version':'Rolling ActBud'];
['Version':'Budget'] => ['Version':'Rolling ActBud'];

...I'm sure you get the concept but in terms of technical detail hopefully that's not too much to bite off for you in one go or someone else might elaborate.

Hi,
Can I suggest that you try and do this yourself and then revert to the forum if you have a specific issue?

We find that its not a good idea to spoon field people technical solutions since in general people should develop the skills they need themselves. They will then understand and be able to support the solution on an ongoing basis, which ought to be best for all parties involved.

What you are trying to do is very straight forward and with the pointers that lotsaram has given plus the contents of the manuals it should be easy to build.

Cheers,

FEEDERS;
['Actual'] => ['Scenario':'Q2 Projection'],['Scenario':'Q4 Projection'];
['Currency'] => ['CAD Consolidated'];
['Scenario':'Budget', 'Final Version', 'Amount' ] => ['Scenario':'Q2 Projection', 'Non_Final_Version', 'Amount'];
['Scenario':'Budget', 'Final Version', 'Amount' ] => ['Scenario':'Q4 Projection', 'Non_Final_Version', 'Amount'];
['Total Months'] => ['Actual Total'], ['Projection Total'];

1[‘Actual’] => [‘Scenario’:’Q2 Projection’,’Nov’,’Dec’,’Jan’,’Feb’];
2[‘Actual’] => [‘Scenario’:’Q2 Projection’,{‘Nov’,’Dec’,’Jan’,’Feb’,}];
3[‘Actual’] => [‘Scenario’:’Q2 Projection’,’W_Q2P_Version’,’FA_Q2P_Version’,’W_Training_Version’,{‘Nov’,’Dec’,’Jan’,’Feb’,}];


Hi lotsaram, thanks for your help so far. Above feeders numbered 1-3 are the feeder statements that I have written.Please peruse and let me know which of them would resolve a part of my issue being the input of actual values in my Expense Cube only for the months of ‘Nov,Dec,Jan,Feb.
The first four FEEDERS lines is the only statement in the Expense Cube as at now.
My next need will be for me to write another rule or feeder to populate the rest of my Expense cube with the budget values after populating the actual.
Thanks for all your help.

{Edit: Post reinstated by Admins from archive copies.}

How.

Thanks.

FEED.

This thread is hilarious.

I did try to understand this thread honest!!

Christopher Kernahan wrote:

How.

Thanks.

FEED.

This thread is hilarious.

Welcome.

Christopher Kernahan wrote:

How.

Thanks.

FEED.

This thread is hilarious.

We were aware of the problem but hadn't had time to repopulate the posts from the archive. That's now been done and two posts which had nothing to do with the original topic have been split into a separate thread.

I have no idea why the OP deleted their original content.

The OP sends me a private email seeking help on this question (with page length rules attached)

@ OP: I will not go into questions by private emails, there is this wonderful board where you can interact.
Please learn how to post a topic properly and I'm sure help will be given.

Wim

Thank you guys for all your advice and help so far.I still haven't resolved the issue though.More pointers to the resolution of this problem, will be highly appreciated.Thanks.