Hello everybody,
I would like to know just an information.
Is that possibile is TM1 to create without TI processes a Dimension of attributes?
So I have got a dimension which elements are the attributes of another dimensions. And the update is not done via TI process. just kinda automatic. (like Hyperion if I remember properly)
Thanks in advance for ur time.
ND
Attribute Dimensions
-
Martin Ryan
- Site Admin
- Posts: 1989
- Joined: Sat May 10, 2008 9:08 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
- Location: Wellington, New Zealand
- Contact:
Re: Attribute Dimensions
I think you mean you want to maintain the attributes independently from Turbo Integrator? Yes, it is possible. Right click on the dimension that you wish to work with and choose "Edit Element Attributes...". To add new attributes in the subsequent interface, you can either right click at the top, or go to the Edit menu and choose "Add new attribute".
As for the values themselves they can be input directly into the control cube if you wish, or you can use DBSA formulae from Excel.
Cheers,
Martin
As for the values themselves they can be input directly into the control cube if you wish, or you can use DBSA formulae from Excel.
Cheers,
Martin
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
-
Alan Kirk
- Site Admin
- Posts: 6647
- 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: Attribute Dimensions
Hmm... the only way I could see it being done automatically is if you applied rules to the }ElementAttributes cube. I've never heard of that being done but it might be an interesting experiment, unless someone out there is already doing it?nicola531 wrote: So I have got a dimension which elements are the attributes of another dimensions. And the update is not done via TI process. just kinda automatic. (like Hyperion if I remember properly)
"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.
-
Steve Rowe
- Site Admin
- Posts: 2456
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Attribute Dimensions
Short of a magic wand (aka Triggers) I can't see that this is possible.
I think what you are asking for is, a user changes the value of an attribute to one that has not been used before, this new attribute should then automagically be created as an element in another dimension.
The only way to do that in an automated way would be to set up a chore to run a TI at what ever frequency is required to keep up with the rate of change of the attributes, I would have thought this would be practical unless you are talking an enourmous dimension (i.e. millions of elements)
There is an enhancement request in the enhancement forum that talks about triggers, this is the perfect solution for you. This would mean that a change to the attribute cube (the trigger) would run the TI to update the second dimension in the background.
(just as a side thought if the rate of change was attributes was high and the dimension large I would think a chore rather than a trigger would still be the way to go)
If this isn't what you meant then just pretend you didn't read the above!
Cheers
I think what you are asking for is, a user changes the value of an attribute to one that has not been used before, this new attribute should then automagically be created as an element in another dimension.
The only way to do that in an automated way would be to set up a chore to run a TI at what ever frequency is required to keep up with the rate of change of the attributes, I would have thought this would be practical unless you are talking an enourmous dimension (i.e. millions of elements)
There is an enhancement request in the enhancement forum that talks about triggers, this is the perfect solution for you. This would mean that a change to the attribute cube (the trigger) would run the TI to update the second dimension in the background.
(just as a side thought if the rate of change was attributes was high and the dimension large I would think a chore rather than a trigger would still be the way to go)
If this isn't what you meant then just pretend you didn't read the above!
Cheers
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
nicola531
- Posts: 43
- Joined: Thu Oct 22, 2009 7:58 am
- OLAP Product: TM1
- Version: 9.5.1
- Excel Version: 2007
Re: Attribute Dimensions
Thaks for all reply...
By the way I was using attributes in Excels prespective as filters in order to filter the dimension where they are set.
I must build some combo box with the list of this attributes to select the right one and to apply the filter but I don't know if there are some easy way to do it because I would need a unique subset.
With element is very easy to do it wit DIMIX so I wanted to have a dimension to use just to create the element for filters and then to actually filter the values to use a MDX in the TM1RPTROW function.
Maybe is just not feasable but I'm quiet new to this world so I wanted to ask.
Thanks a lot again.
ND
By the way I was using attributes in Excels prespective as filters in order to filter the dimension where they are set.
I must build some combo box with the list of this attributes to select the right one and to apply the filter but I don't know if there are some easy way to do it because I would need a unique subset.
With element is very easy to do it wit DIMIX so I wanted to have a dimension to use just to create the element for filters and then to actually filter the values to use a MDX in the TM1RPTROW function.
Maybe is just not feasable but I'm quiet new to this world so I wanted to ask.
Thanks a lot again.
ND