Hi I have the following rule in my cube .
SKIPCHECK;
['Beginning Balance','Total Qty on Hand'] = IF(NUMBR(ATTRS('Months', !Months, 'Month Number')) > 201601,(IF (SUBST(ATTRS('Months',!Months,'Month Number'),5,2) @='01',DB('Inventory_New', !Company Codes, !Storage Locations, !Inventory Buyers, !Inventory Ty
pes, !Inventory Methods, !Materials, !Vendors, STR(NUMBR(SUBST(ATTRS('Months',!Months,'Month Number'),1,4)
)-1,4,0) | '12', !Currencies, !Valuation Class, !Inventory Stock Category,'Ending Balance', !Inventory Measures),
DB('Inventory_New', !Company Codes, !Storage Locations, !Inventory Buyers, !Inventory Types, !Inventory Methods, !Materials, !Vendors,ATTRS('Months', !Months, 'Prior'), !Currencies, !Valuation Class, !Inventory Stock Category, 'Ending Balance ', !Inventor
y Measures)
)),STET);
Take prior months ending balance and apply to the current month , do it different for 1 st month alone .
FEEDERS;
['Ending Balance'] => ['Beginning Balance'];
The rule is simple the cube initial data is loaded from july 2016 which 201601 so the rule should be effective from 201602 .
My issue is the consolidation doesnt take place for August , total quantity on hand .
Attached the screen shot of the issuse .
Thanks,
Rule consolidation Issue
-
- Posts: 128
- Joined: Tue May 23, 2017 12:45 pm
- OLAP Product: Tm1
- Version: 9.5
- Excel Version: 2010
Rule consolidation Issue
- Attachments
-
- issue.png (24.87 KiB) Viewed 3628 times
-
- Trace Calculation.png (15.18 KiB) Viewed 3628 times
-
- MVP
- Posts: 1815
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Rule consolidation Issue
Your rule is pulling from prior month so you need to alter your feeder to push to the next month. Currently you are feeding the same month.
Declan Rodger
-
- Posts: 128
- Joined: Tue May 23, 2017 12:45 pm
- OLAP Product: Tm1
- Version: 9.5
- Excel Version: 2010
Re: Rule consolidation Issue
Any sample on how to push to next month on feeder .
The rule is if curremonth number is 01 then get the prior years last month value other wise get the prior month value .
Thanks
The rule is if curremonth number is 01 then get the prior years last month value other wise get the prior month value .
Thanks
-
- MVP
- Posts: 2831
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Rule consolidation Issue
Just like you have an attribute on your Months dimension called "Prior", so should you have one called "Next". Then your feeder would look something like this:
You have to use the full DB syntax in order to do this. Substitute your cube name and dimension names in above. The ATTRS code string would replace the !Months reference in the rule.
Code: Select all
['Ending Balance'] => DB(CubeName, Dim1, Dim2,..., ATTRS('Months', !Months, 'Next'), 'Beginning Balance');
-
- Posts: 128
- Joined: Tue May 23, 2017 12:45 pm
- OLAP Product: Tm1
- Version: 9.5
- Excel Version: 2010
Re: Rule consolidation Issue
Okay this worked perfectly .
But when i expand a hierarchy in any dimension as part of a cube view , its taking more time to update . but its give the correct results .
The below mentioned was my only rule in the cube .Is there a way I am doing doing something wrong which is affecting the performance .
Thanks,
But when i expand a hierarchy in any dimension as part of a cube view , its taking more time to update . but its give the correct results .
The below mentioned was my only rule in the cube .Is there a way I am doing doing something wrong which is affecting the performance .
Thanks,
-
- Posts: 128
- Joined: Tue May 23, 2017 12:45 pm
- OLAP Product: Tm1
- Version: 9.5
- Excel Version: 2010
Re: Rule consolidation Issue
Okay i think this happened earlier as well . When I save this cube rule it happens to save all other cubes rules . I am seeing this in operation console .
Last time I think what fixed was deleting the rule and restarting the server and readding the rule back .
I am not sure if that will fix this today .but will give it a try .
Any idea why this causing this.
Thanks,
Last time I think what fixed was deleting the rule and restarting the server and readding the rule back .
I am not sure if that will fix this today .but will give it a try .
Any idea why this causing this.
Thanks,
-
- Posts: 128
- Joined: Tue May 23, 2017 12:45 pm
- OLAP Product: Tm1
- Version: 9.5
- Excel Version: 2010
Re: Rule consolidation Issue
In ops console, the rule attach function is running for all other cube feeders.