calculations atribute arquitect

Post Reply
Kazêh
Posts: 44
Joined: Fri Apr 19, 2013 12:59 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2007

calculations atribute arquitect

Post 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
Image

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
User avatar
jim wood
Site Admin
Posts: 3958
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: calculations atribute arquitect

Post 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.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: calculations atribute arquitect

Post 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?
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Kazêh
Posts: 44
Joined: Fri Apr 19, 2013 12:59 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2007

Re: calculations atribute arquitect

Post 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.
me2
Posts: 12
Joined: Fri Apr 12, 2013 1:28 pm
OLAP Product: TM1
Version: 10.1.1
Excel Version: 2003 - 2010

Re: calculations atribute arquitect

Post 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.
Post Reply