Function Percent Change in a TI?

[Toto]

Hello,

isn't it possible to use the data spreading method "percent change" in a TI-process? I only found CellProportionalSpread as a possible function to use in a TI-process.
I want to implement a top-down approach where the user types in a "3" in a cell an for the consolidated shown values the percent change method is executed.

The user should not use the function from the menu (right-mouse-button). Is there another way to implement this, or is it only possible with the TM1Api?

If it is only possible with TM1Api or the menu, is there a way to hide all functions except "percent change" in the pop-up menu?

Thanks a lot!

Toto

[lotsaram]

Percent change is just a variation on proportional spread with some high level precursor arithmetic before doing the proportional spread.

Taking a cell input percent change and then applying the math to multiply against the starting value and then proportional spread is nothing that can't be achieved in a few lines of code on the prolog of your TI.

That is if you insist on this approach. Why not train the users to use spreading via the right-click UI or keyboard shortcuts? Easier for you and I would argue easier for the users also.

[Steve Vincent]

I want to implement a top-down approach where the user types in a "3" in a cell an for the consolidated shown values the percent change method is executed.

Is this desired in a cube view or an excel based report? If its a cube view then TI won't help you - you cannot trigger a TI based on a users input. Depending on the model you could do it via rules quite easily. I have one where data is entered to a scenario and another scenario is rule created based on a percentage entered by the user as an attribute.

Why reinvent the wheel tho, the spreading options are perfectly fine as long as users are trained in the use.

[Toto]

Thanks for your replies. The customer wants to have his actual application rebuilt with TM1, and it should be usable without any training.
I will have an excel-report published with TM1Web.

Thanks again,

Toto