Can you add attributes to C level elements?
-
- Posts: 67
- Joined: Wed Sep 02, 2015 3:09 pm
- OLAP Product: TM1
- Version: 10_2_2
- Excel Version: 2010
Can you add attributes to C level elements?
Hi -
Is this ever possible and if so why not?
Many thanks in advance.
Is this ever possible and if so why not?
Many thanks in advance.
-
- Posts: 78
- Joined: Wed Jul 31, 2013 4:32 am
- OLAP Product: Cognos TM1, EP, Analyst
- Version: 10.2.2
- Excel Version: 2013
- Location: Sydney AU
Re: Can you add attributes to C level elements?
Have you tried? I am interested to know if you have.
MK
-
- Posts: 67
- Joined: Wed Sep 02, 2015 3:09 pm
- OLAP Product: TM1
- Version: 10_2_2
- Excel Version: 2010
Re: Can you add attributes to C level elements?
Yes and it does not work.
But I cannot seem to find anything on either the forum or developer guide explaining why?

But I cannot seem to find anything on either the forum or developer guide explaining why?
-
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Can you add attributes to C level elements?
Yes you can; that's why it doesn't get special mention in any of the guides - all elements are treated equally in this respect.
Open the }ElementAttributes cube and you will have an easier to view screen than the right click rubbish.
EDIT - Out of interest when you say "It doesn't work"; what made you think that? Is it the subset editor? When you highlight a C-Level element in the subset editor - the properties window just shows its children and their attributes but despite it not showing you the consol's attributes it does still have them.
Open the }ElementAttributes cube and you will have an easier to view screen than the right click rubbish.
EDIT - Out of interest when you say "It doesn't work"; what made you think that? Is it the subset editor? When you highlight a C-Level element in the subset editor - the properties window just shows its children and their attributes but despite it not showing you the consol's attributes it does still have them.
Declan Rodger
-
- Posts: 78
- Joined: Wed Jul 31, 2013 4:32 am
- OLAP Product: Cognos TM1, EP, Analyst
- Version: 10.2.2
- Excel Version: 2013
- Location: Sydney AU
Re: Can you add attributes to C level elements?
Unless there is rule applied to the attribute you are trying to update, or that you don't have edit access. I can not understand why you weren't able update attributes on c levels.
Either way, it is a simple test to find out.
Either way, it is a simple test to find out.
MK
-
- Posts: 67
- Joined: Wed Sep 02, 2015 3:09 pm
- OLAP Product: TM1
- Version: 10_2_2
- Excel Version: 2010
Re: Can you add attributes to C level elements?
Hi - we are not doing it manually but via TI.
It adds it for 'Agency Number' which is N-level but not for the others - 'Head Office', 'Division', etc., which are consolidated elements.
Above is the code in the 'Data' section of the TI.
It adds it for 'Agency Number' which is N-level but not for the others - 'Head Office', 'Division', etc., which are consolidated elements.
Above is the code in the 'Data' section of the TI.
- gtonkin
- MVP
- Posts: 1265
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: Can you add attributes to C level elements?
Is your attribute an alias or text? If an alias, does the TI finish successfully? If not, have you check the logs? Are you trying to assign duplicate aliases (same vSegmentation across multiple elements)?
-
- Posts: 67
- Joined: Wed Sep 02, 2015 3:09 pm
- OLAP Product: TM1
- Version: 10_2_2
- Excel Version: 2010
Re: Can you add attributes to C level elements?
Hello:
Neither are aliases, it is trying to assign the same text value to everything in the elements' hierarchy.
Many thanks in advance.
Neither are aliases, it is trying to assign the same text value to everything in the elements' hierarchy.
Many thanks in advance.
-
- 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: Can you add attributes to C level elements?
Can you go to the }ElementAttributes cube for that dimension and type in the values for the elements and attributes in question? If yes then you're TI process function is not working as you intended. I can confirm with 100% certainty that you CAN assign attributes to C level elements.
-
- Posts: 67
- Joined: Wed Sep 02, 2015 3:09 pm
- OLAP Product: TM1
- Version: 10_2_2
- Excel Version: 2010
Re: Can you add attributes to C level elements?
Yes. I am able to type in attributes manually for these, however the TI does work for the N Level in the code above - the first one 'vAgencyNumber' but not the others.
- gtonkin
- MVP
- Posts: 1265
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: Can you add attributes to C level elements?
Are you sure that the variables you are using contain the right elements you are trying to update?
May be helpful to asciioutput each of the variables list in the AttrPutS statements after the vAgencyNumber and see where TI is trying to send the attribute values.
May be helpful to asciioutput each of the variables list in the AttrPutS statements after the vAgencyNumber and see where TI is trying to send the attribute values.
-
- 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: Can you add attributes to C level elements?
You do realize that vAgencyNumber is just a variable name, not a value. It's a value when it is assigned a value in your code or assigned a value from your input source. Where is the value stored in vHeadOffice_ICEref coming from? Are you sure it's not empty or pointing to the wrong element. You need to put an ASCIIOutput statement in your code to write the values from all your variables into a file so you can see what's in there at run time. It's really the only way to debug TI processes.wigglyrat wrote:Yes. I am able to type in attributes manually for these, however the TI does work for the N Level in the code above - the first one 'vAgencyNumber' but not the others.
-
- 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: Can you add attributes to C level elements?
If I had to bet it's that either:wigglyrat wrote:Yes. I am able to type in attributes manually for these, however the TI does work for the N Level in the code above - the first one 'vAgencyNumber' but not the others.
(a) Your code is not doing what you think it is; eg there may be something in your code that is causing it to skip the consolidations, which is why the RFA guidelines request the complete code; or, equally likely
(b) Your data source does not include the consolidation elements, meaning that the write action never occurs in the first place.
"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.
-
- Posts: 67
- Joined: Wed Sep 02, 2015 3:09 pm
- OLAP Product: TM1
- Version: 10_2_2
- Excel Version: 2010
Re: Can you add attributes to C level elements?
HI Thanks for your replies.
Trying ASCII output proved it was adding the correct variable to the right element, thank you for this suggestion.
This code above however, was initially in the 'Data' tab. Moving it to 'metadata' has solved the issue and now the attributes have been added.
Can anyone please explain why moving it here would make a difference?
Many thanks.
Trying ASCII output proved it was adding the correct variable to the right element, thank you for this suggestion.
This code above however, was initially in the 'Data' tab. Moving it to 'metadata' has solved the issue and now the attributes have been added.
Can anyone please explain why moving it here would make a difference?
Many thanks.
- qml
- MVP
- Posts: 1097
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: Can you add attributes to C level elements?
Do you mean just the code you're showing us, or also some other code that goes with it?wigglyrat wrote:This code above however, was initially in the 'Data' tab. Moving it to 'metadata' has solved the issue and now the attributes have been added.
Can anyone please explain why moving it here would make a difference?
AttrPutS is a data manipulation function, so can be used on any tab of the TI process. It is typically used on the Data tab because that ensures that the changes to the dimension are committed after the Metadata tab and all the required elements are in the dimension when you're trying to populate their attributes.
Kamil Arendt
-
- Posts: 78
- Joined: Wed Jul 31, 2013 4:32 am
- OLAP Product: Cognos TM1, EP, Analyst
- Version: 10.2.2
- Excel Version: 2013
- Location: Sydney AU
Re: Can you add attributes to C level elements?
The chances are that there is operation ( prior to at attrPutS ) in your data tab that has skipped over the attrPutS.
While leaving in metadata tab may work for now, it is not recommended. Depending what you are doing in your prolog and metadata tabs, this can cause potentially issues further down the track.
While leaving in metadata tab may work for now, it is not recommended. Depending what you are doing in your prolog and metadata tabs, this can cause potentially issues further down the track.
MK