TM1 Forum

Maybe my statement is too extreme but I think when your (or rather my) model is not well designed (well thought out) from the beginning, its complexity should be overcome by horrendous nested if statement in rules which impact the overall performance (that's way I think the additional calculation cu...

Hi every one.

Finally with more data my model is really slow so the redesigned is in process .

In conlusion the inter cubes rules with if complex statements are not the good idea.

Thanks for your help

ACorp.docx Hello Guys, Thanks a lot four your advices. As I see I was not exhaustive enough in the description of my model, so I included (in the attached file) all relevant rules. And I'd like to highlight one point: the model will always include only 2 years: the current (Est) + the next one (Bud...

Hello, The software used Cognos Express 10.1. and your help needed and very welcome (as I did not find the similar topic). The simple model to calculate the depreciation of new assets, consists of 2 cubes: -> BUD_Assets_Attr (2 dimensions: F_BUD_Assets_item + M_BUD_Assets_Attr) where user will input...

Perfect, thanks a lot

Thanks for your quick answer, but it still does not work as I expect. When I use it in TextOutput (c:\ .., dimNameVariable, .., .., SValue) with dimNameVariable = 'DimName' in Prologue section, I get the DimName x times in the export file instead of having all elements from this dimension. Hope my e...

Hi Is there any possibility to set / define the element variable (based on the cube view) in Advanced Tab (with the variables tab content set to ignore) in the way to use this element variable’ name in different TI functions? Hope my question is clear (I did not find the related topic in the forum)....

Prefect (brilliant) idea with hidden numeric measure
Never thought about it
Thanks a lot

Hi I am struggling with the follwoing rule issue and wonder if anyone may help me: I would like to put - either zero at the string consolidation level elements when direct child elements (string) have no value entered, - either 1 when any of n-level (child) elements has string value entered. Could a...

Thanks a lot.
It helps, however every time the user select "All", he creates kind of 'disorder' in the hierarchy.

Hello. Maybe somme may help me with the following topic. My source file is structred as follows: V1 => element-1 , element-2 , .... V2 => element-a , element-b, .... I'd like to set up 2 hierarchies with TI Groupe1 -element-1 -elemnt-2 Groupe2 -element-a -elemnt2-c When I'm trying to set up these 2 ...

You're right. Thanks a lot

As the beginner i'm traying to solve the follwing issue in TI: The imported % data is set up as whole number in the source file (25, 35, ...). When imported to the cube, where format is set for %, these data becomes 2500%, 3500% (inested of 25%, 35%). My idea is to divide imported data by 1000 in TI...