TM1 Forum

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 tod...

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 performanc...

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

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, !Inven...

Hierarchy-> Countries dimension. Hierarchy - Country ->USA->EAST,WEST,NORTH, SOUTH ->states. Now the report should look like Sale Product category NORTH 50 EAST 100 West 150 South 200 Now the issue here is user doesnt want one state under South to be shown in report , South should include state Flor...

Okay , I have written the feeders in the source cube now . Bit I am not getting the complete correct result . Now Zero suppression still shows me the cost . but my question is cost has no relation with quantity , why does cells with zero quantity gets suppressed even it has cost . Just trying to und...

now assume in this cube i want to see the cost for like 50 materials , then I have the n level 50 items shown with cost . Assume there is only cost for 35 materials and rest 15 are zero and I wanted to only see the materials with cost . Then I hit zero suppression and everything disappears .I expect...

Yes that was the issue . Thanks All !!

why should feeder read based on quantity . what if i have only cost in the columns .I am not getting it .

Thanks,

let me check .

Thanks

Hi Tomok , I am facing the issue you stated below , doing zero suppression removes the entire Cost - Standard Price column from the view , even though the rule calculated value is present in the intersections . Attached the screenshot after and before zero suppression is turned on . SKIPCHECK; ['Cos...

Hi Guys, I had an issue with subset creation and when I moved a part of code to epilog it started working. Can you tel me if there was anything wrong having the code in prolog itself . Prolog : Creating a subset through a mdx statement . Subset Name : ALL X Customers Now with All X customers subset ...

Hi , In my inventory cube I have a rule to get the cost of the material from cost sets cube. ['Cost - Standard Price'] = N: DB('Cost Sets', !Plants, '10', !Currencies, !Months, !Items, 'Standard', 'Cost - Standard Price'); So my feeders for this is : DB('Cost Sets', !Plants, '10', !Currencies, !Mont...

Thanks Wim !!

yes oh i got it , so i will write a rule in exchange rates cube to pick the month and prior months average ending rate and store it as a calculated measure .

Yeah thanks , really appreciate your suggestions . But the average rate is not always on the same months , its done on the month the user selects and its prior month . How would I calculate this as a calculated measure in the exchange rates cube . I cannot say do an average of jun and July . It has ...

Can I have this :

[Currency:'Local Currency','MX','Sales Measure':'Budget','FX Rate':'Actual']] => ['MX',Currency:'USD','Sales Measures':'Budget'];

Thanks !! But its odd some time with just dimensionelement component add some items are added as n level .
But its safer to have the above code .

Hi , Cube has data loaded in local currency for Mexico and USA . For budget alone, we wanted Mexico 's value to be converted to USD .so that we can see budget in usd as a whole . SO I am writing the below rule : ['MX',Currency:'USD', 'Sales Measures': 'Budget','FX Rate':'Actual'] = N: ['MX',Currency...

Hi , I have a TI process which adds an element to the dimension in run time . IF (DIMIX('Inventory Movement Types', vMovementType) = 0); DIMENSIONELEMENTCOMPONENTADD('Inventory Movement Types','All Inventory Movement Types', vMovementType,1.000000); I have a parent All Inventory Movement Types creat...