Attibutes Vs Dimix
-
- Posts: 27
- Joined: Wed Mar 06, 2013 2:48 pm
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2007
Attibutes Vs Dimix
Can we substitute attribute instead of DIMIX .How could it enhance performance of the TM1.Thanks
-
- 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
Leaving aside the fact that attributes and DimIx server two completely different purposes:TM1ethusiast wrote:Can we substitute attribute instead of DIMIX .How could it enhance performance of the TM1.Thanks
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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
- 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
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.
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
Jodi Ryan Family Lawyer