TM1 Forum

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,

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.

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

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.

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,

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,

In ops console, the rule attach function is running for all other cube feeders.