Attibutes Vs Dimix

Post Reply
TM1ethusiast
Posts: 27
Joined: Wed Mar 06, 2013 2:48 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007

Attibutes Vs Dimix

Post by TM1ethusiast »

Can we substitute attribute instead of DIMIX .How could it enhance performance of the TM1.Thanks
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Attibutes Vs Dimix

Post by Alan Kirk »

TM1ethusiast wrote:Can we substitute attribute instead of DIMIX .How could it enhance performance of the TM1.Thanks
Leaving aside the fact that attributes and DimIx server two completely different purposes:
Request for assistance guidelines (PLEASE READ)
RFA Guidelines wrote:3) Try to make the question as specific as possible. A general question like "How do I write a rule?" is difficult to answer without copying out the whole of the user manual. A question like "I have a payroll cube which contains the following dimensions {details} and a general ledger cube which contains the following dimensions {details}, and although I've read through the Rules Guide I'm still not sure how to write a rule to give me average sales per employee" is far more likely to get the answer your need.
RFA Guidelines wrote:6) Give a brief outline of what you've done to find the answer; which manuals or guides you've looked in, what tests you've done.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
User avatar
Martin Ryan
Site Admin
Posts: 2003
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Attibutes Vs Dimix

Post by Martin Ryan »

I assume you're talking about things like feeding last year to next year? E.g ['Some Value'] => DB('SomeCube', !Dim1, !Dim2, dimnm('Year', dimix('Year', !Year)+1, !Dim4);

You can change this to ['Some Value'] => DB('SomeCube', !Dim1, !Dim2, attrs('Year', !Year, 'Next'), !Dim4);

Obviously you'll need to have an attribute in your "Year" dimension called "Next" that contains the appropriate information. You'll also need a "Previous" attribute for the other half of the rule/feeder combo.

The attributes method is significantly faster than dimix. It's also more reliable because it won't get stuffed up if someone introduces a new element or messes with the dimension order.

Given that your question was rather vague I may have missed the mark completely. If so, please provide more detail.
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Post Reply