TM1 Forum

Hi All,
I am still waiting for a reply.

Hi, We have a dimension such as ProductA ProductA.0112 ProductA.0212 ...ProductA.1212 ProductB ProductB.0112 ProductB.0212 ...ProductB.1212 we want process in which we can sort out above hirearchy in the decreasing order dynamically, we can use MDX expression for the same but level is not fixed, so ...

Hi,

I agree with your point, but I cant understand why two similar sheets created for each element.

Hi, Thanks for reply,I have used the feeder also but still its not working ,please find below Rule ['PY_ACTUAL'] = DB('Cube',ATTRS('xx_Year',!xx_Year, 'Prior'),'ACTUAL',!xx_Month,!xx_Cost_Center,!xx_PnL_Account); Feeders ['ACTUAL'] => DB('cube',ATTRS('xx_Year',!xx_Year,'Prior'),'PY_ACTUAL',!xx_Month...

Hi, When we select items in dimension title to export in excel snapshot ,we got the option choose dimension title to export, if we tick that option. Then, after export two sheets generated for each title element. For example: select title dimension( 2 items): Product ProductA when export two sheets ...

Hi, we have three elements Elements Weight Actual 1 PY Actual -1 Actual vs PY Actual Actual+PY Actual(Calculated) In this PY Actul data derived from rule to take Actual data of previous year problem: Actual vs PY Actual value is not calculating properly, it only showing Actual value it means rule de...