Page 1 of 1
calculations atribute arquitect
Posted: Thu Aug 08, 2013 7:34 pm
by Kazêh
hello guys, i need to ask this pretty stupid question, and im really sorry for it, but im trying to add and "calculation" atribute to my mesure dimension
so i can put calculations on it.
here is a picture of it
im pretty sure that the names are rigth... and the ' ' are rigth too, i think. if not, someone send me a punch in my face, i will take it with no regrets.
I am missing somethings?
i can do the calculations with rules without problems, but i really wanted to just use the calculation atribute from the measure dimension oonly.
Sorry for the trouble
Re: calculations atribute arquitect
Posted: Thu Aug 08, 2013 7:48 pm
by jim wood
Why are you trying to put calculations in attributes? Are they there for reference? If not you really need to take a step back, get some training or at the very least spend some time going through the software documentation.I don't mean that as a put down. We all have to start some where.
Re: calculations atribute arquitect
Posted: Thu Aug 08, 2013 8:06 pm
by tomok
Kazêh wrote:i can do the calculations with rules without problems, but i really wanted to just use the calculation atribute from the measure dimension oonly.
There is no such thing in TM1. Calculations have to be defined in rules (or as a rollup in a dimension hierarchy). Are you perhaps thinking of EP?
Re: calculations atribute arquitect
Posted: Thu Aug 08, 2013 8:13 pm
by Kazêh
i was trying to copy the go new stores examples server with others dimension, so i found up that some of it has this calculation atribute, so i though i needed to ad that to my measure dimension.
but i think there are just for "reference" as jim said.
Sorry to trouble, it's not like i didnt read any manual, i know how to make the calculations with rules, but never used that calculation atribute.
Re: calculations atribute arquitect
Posted: Fri Aug 09, 2013 10:30 am
by me2
The Go New Stores sample model you looked at was probably created through Performance Modeler. In contrast to the legacy/classic (or whatever you want to call them) development UIs, PM supports the concept of dimension types - like Time, Version and also Calculation. For elements of a Calculation dimension you can specify N and C calculation formulas which are stored in text attributes (called "calculation" and "crossdimcalc" respectively). These formulas are used by PM to automatically generate the corresponding rules for cubes which include the calculation dimension.
As said, in Architect and Perspectives the concept of dimension types has no meaning. Here the attributes that store the calculation formulas are just that: attributes. Altering their content doesn't automatically generate the corresponding rules; you have to do that yourself.
In general I'd say it's not recommended to use both the "old" and the new UIs when developing/maintaining a model unless you know exactly what you're doing.
To conclude: the formulas you saw in the sample are not just for reference; they are actually used but only by PM.