TM1 Forum

Thanks Peter, Can you elaborate on you suggestion, im fairly new to TM1 and dont fully understand ['Number of active stores','dummy department','dummy manager',.....]=IF(['Sales','Total Department','Total Manager', .......]>0,1,STET); Whats is the dummy department and manager and Total Department an...

Thanks kpk, I've just got a few qustions in regards to the store count rule. You said this should do the trick SKIPCHECK; ... ['Number of active stores']=IF(['Sales']>0,1,STET); ... FEEDERS; ... ['Sales']=>['Number of active stores']; ... However wont this just put a 1 against any element that has a...

Sorry my mistake you were right and its not in the dimension, however im not sure why it not in there as im creating my dimension through a TI process to and it should be picking all the products up from the product table but it not. Any ideas why this might be happening?

Thanks, Please find below the Data script. You mentioned that it might not be able to find the element with in the Original Suppliers dimension, this is what i orignially thought so i check and it is in there. #****Begin: Generated Statements*** vTVRegion=MEMID; vMangers=MEMID; vNisaCategories=PROID...

Thanks for your help. Please find attached details of my dimensions and sizing. I need to be able to count the number of stores at the leaf element with the NISA Account Group dimension. The structure looks like this 'All NISA Account Group' 'NISA Account Number' 'Account Group' 'Store' I'd like to ...

Thanks, Just to understand that a bit more. Am i right in saying the test dimension order rebuilds the cube with the new dimension order in the background on the server? So would I need the same amount of memory of the current cube available on the server for this test?

Regards
Dave

Hi, I've build my cube using TI process, however, once it completes it completes with error warnings and im not entirley sure what they mean. Could you help me understand why these are occuring. Listed below are just a few examples coming from log file. "4.09","1.","4.09&quo...

Hi,

Thanks for your response. I've applied the fucntion ELCOMPN to the rules, however it takes a very long time to save the rule and open the cube now.

Any suggestions why this might be?

Hi, Thanks for your post it was very useful. I went down the route of ordering my dimensions small to big and that seemed to reduce the size of the cube in memory. However is still quite large at 4gb. I think the next excise is to work out the sparse dimensions and put that theory into practice.. If...

Hi Guys,

Im pretty new to TM1 and was wondering if i could get some advice with the dimension order within the TI Cube creation. I want to try and optimize performance as well as take minimum memory space

Please find attached my dimensions


Any help would be appreciated

Dave

Hi Guys, I’m new to TM1, so please excuse me if my question comes across very straight forward. One of the measures I require is a count of stores, Would I create this in the rules? I need to be able to count the number of IDs (lower leaf element) in one of the dimensions. Any help would be apprec...