TM1 Forum

Hi guru's I have a model whereby I have product data by month. I also have a phasing cube that has %'s for month 1, month 2, ..... Is it possible to write a rule that will take the monthly figure and phase it over the coming months according to the %'s without referring directly to the month element...

yes correct

Hi experts I have a rule which I only want to apply at the C level. My rule calculates correctly on the C level element, however when I view the cube at a consolidated level there are no values. Could you please review my code below and help me understand where I have gone wrong ['reporting_currency...

Thanks declanr, all working

Hi all This is hopefully a simple question, 'Can you use a tm1 defined numeric variable within an MDX query?' I will show my example below; nMin = CellGetN( cControlCube, 'HLC001', pAccount, 'HLE001' ); sCompanyMDX = ' { TOPCOUNT( { [HL Company] . [HLC001] . Children }, nMin , [ ' | cSourceCubeName ...