Hi Guys
i am new on tm1 area so maybe my question can sound a bit simple but there you go.

i have a daily entry cube as cash flow where i have accounts and day and month as the grain.
i also have a monthly expense allocation cube where i want to bring the daily information from my daily cash flow summarized  by month to my expense cube which has month and year as the grain.

i created the rule on my expense cube as is below

#Region System
FEEDSTRINGS;
SKIPCHECK;
#EndRegion
['Mazda CX5 Payments','Actual']=N:DB('Cube_Daily Entry for Cash Flow','Mazda CX5 Payments',!Time,'Actual');

when i open the cube , the month is loaded, however the year and the column for that month and all elements for the level Car for example is not added the value or total let say that.

see the picture



------------------------------
Kleber Vieira
------------------------------

#PlanningAnalyticswithWatson

Hi Kleber, 
Welcome to the community. When writing rules that you to consolidate you'll need to write a corresponding feeder statement. There are plenty of great documents out there that layout the ins and outs of feeders.

Based on what you provided it would look something like.

(IN THE DAILY CUBE) 
FEEDERS;
['ACTUAL', 'ENTRY FOR CASH FLOW', 'MAZDA CX5'] =>
     DB('Expense Cube',!model,attrs('days',!days, 'month'), !version) ;

Note you'll need an attribute or string manipulation to relate days to months. 



------------------------------
Ryan Clapp
------------------------------

Original Message:
Sent: Wed June 17, 2020 12:39 AM
From: Kleber Vieira
Subject: Consolidation Rule

Hi Guys
i am new on tm1 area so maybe my question can sound a bit simple but there you go.

i have a daily entry cube as cash flow where i have accounts and day and month as the grain.
i also have a monthly expense allocation cube where i want to bring the daily information from my daily cash flow summarized  by month to my expense cube which has month and year as the grain.

i created the rule on my expense cube as is below

#Region System
FEEDSTRINGS;
SKIPCHECK;
#EndRegion
['Mazda CX5 Payments','Actual']=N:DB('Cube_Daily Entry for Cash Flow','Mazda CX5 Payments',!Time,'Actual');

when i open the cube , the month is loaded, however the year and the column for that month and all elements for the level Car for example is not added the value or total let say that.

see the picture

------------------------------
Kleber Vieira
------------------------------

#PlanningAnalyticswithWatson

Thanks Ryan
will test it

------------------------------
Kleber Vieira
------------------------------

Original Message:
Sent: Wed June 17, 2020 01:13 AM
From: Ryan Clapp
Subject: Consolidation Rule

Hi Kleber, 
Welcome to the community. When writing rules that you to consolidate you'll need to write a corresponding feeder statement. There are plenty of great documents out there that layout the ins and outs of feeders.

Based on what you provided it would look something like.

(IN THE DAILY CUBE) 
FEEDERS;
['ACTUAL', 'ENTRY FOR CASH FLOW', 'MAZDA CX5'] =>
     DB('Expense Cube',!model,attrs('days',!days, 'month'), !version) ;

Note you'll need an attribute or string manipulation to relate days to months. 



------------------------------
Ryan Clapp

Original Message:
Sent: Wed June 17, 2020 12:39 AM
From: Kleber Vieira
Subject: Consolidation Rule

Hi Guys
i am new on tm1 area so maybe my question can sound a bit simple but there you go.

i have a daily entry cube as cash flow where i have accounts and day and month as the grain.
i also have a monthly expense allocation cube where i want to bring the daily information from my daily cash flow summarized  by month to my expense cube which has month and year as the grain.

i created the rule on my expense cube as is below

#Region System
FEEDSTRINGS;
SKIPCHECK;
#EndRegion
['Mazda CX5 Payments','Actual']=N:DB('Cube_Daily Entry for Cash Flow','Mazda CX5 Payments',!Time,'Actual');

when i open the cube , the month is loaded, however the year and the column for that month and all elements for the level Car for example is not added the value or total let say that.

see the picture

------------------------------
Kleber Vieira
------------------------------

#PlanningAnalyticswithWatson

You might want to watch out for over feeding.

------------------------------
Tong Meng Lee
------------------------------

Original Message:
Sent: Wed June 17, 2020 12:39 AM
From: Kleber Vieira
Subject: Consolidation Rule

Hi Guys
i am new on tm1 area so maybe my question can sound a bit simple but there you go.

i have a daily entry cube as cash flow where i have accounts and day and month as the grain.
i also have a monthly expense allocation cube where i want to bring the daily information from my daily cash flow summarized  by month to my expense cube which has month and year as the grain.

i created the rule on my expense cube as is below

#Region System
FEEDSTRINGS;
SKIPCHECK;
#EndRegion
['Mazda CX5 Payments','Actual']=N:DB('Cube_Daily Entry for Cash Flow','Mazda CX5 Payments',!Time,'Actual');

when i open the cube , the month is loaded, however the year and the column for that month and all elements for the level Car for example is not added the value or total let say that.

see the picture

------------------------------
Kleber Vieira
------------------------------

#PlanningAnalyticswithWatson