Hello, my name is Edith Aquino and I'm learning IBM Planning Analytics, I tried to run a process but I get and error due to a missmatch in the names of the Month dimension members and the data in the table for my Franchisce Revenue.
Here's my script, the origin of the data and the month Dimension:



------------------------------
Edith Aquino
------------------------------

#PlanningAnalyticswithWatson

Hi Edith,

You actually could change your element names as below:

You can add a new alias to the dimension called "NewName".
And in that alias populate the name you want your elements to have.

Then create a TI process with just the line below in it (replace <DimName> with the name of your dimension) and run it once.

SwapAliasWithPrincipalName ( <DimName>, 'NewName', 0 );

That will swap the names in your alias with the principal names, after this you can delete the "NewName" alias.

Just be careful that if you specifically use the element name on rules or TI processes, they will need to be updated.


Or you can amend your TI process to load accordingly:

Take SubSt ( vMonth, 4, 3 ) as you have and that will give you the month name in English as per the datasource (strips off the 07- from the front which i assume is the day number) then you can have an Engligh Alias in your month dimension for where the names differ.
TM1 allows you to use alias names in statements just as it allows you to use the Prinipal Name.


------------------------------
Declan Rodger
------------------------------

Original Message:
Sent: Fri November 13, 2020 09:30 AM
From: Edith Aquino
Subject: How to fix a misspelled member name if it already has data and cubes associated

Hello, my name is Edith Aquino and I'm learning IBM Planning Analytics, I tried to run a process but I get and error due to a missmatch in the names of the Month dimension members and the data in the table for my Franchisce Revenue.
Here's my script, the origin of the data and the month Dimension:

I know it's not possible to modify the names on my Moth dimension but I want to know if there's a solution to this problem, if ayone can help.
Thank you and good day.

------------------------------
Edith Aquino
------------------------------
#PlanningAnalyticswithWatson

Thanks for your response! I have one more question. How can you dump values from one member to another in the same dimension?
I tries to run this code and it runs but does nothing:



------------------------------
Edith Aquino
------------------------------

Original Message:
Sent: Fri November 13, 2020 10:30 AM
From: Declan Rodger
Subject: How to fix a misspelled member name if it already has data and cubes associated

Hi Edith,

You actually could change your element names as below:

You can add a new alias to the dimension called "NewName".
And in that alias populate the name you want your elements to have.

Then create a TI process with just the line below in it (replace <DimName> with the name of your dimension) and run it once.

SwapAliasWithPrincipalName ( <DimName>, 'NewName', 0 );

That will swap the names in your alias with the principal names, after this you can delete the "NewName" alias.

Just be careful that if you specifically use the element name on rules or TI processes, they will need to be updated.


Or you can amend your TI process to load accordingly:

Take SubSt ( vMonth, 4, 3 ) as you have and that will give you the month name in English as per the datasource (strips off the 07- from the front which i assume is the day number) then you can have an Engligh Alias in your month dimension for where the names differ.
TM1 allows you to use alias names in statements just as it allows you to use the Prinipal Name.


------------------------------
Declan Rodger

Original Message:
Sent: Fri November 13, 2020 09:30 AM
From: Edith Aquino
Subject: How to fix a misspelled member name if it already has data and cubes associated

Hello, my name is Edith Aquino and I'm learning IBM Planning Analytics, I tried to run a process but I get and error due to a missmatch in the names of the Month dimension members and the data in the table for my Franchisce Revenue.
Here's my script, the origin of the data and the month Dimension:

I know it's not possible to modify the names on my Moth dimension but I want to know if there's a solution to this problem, if ayone can help.
Thank you and good day.

------------------------------
Edith Aquino
------------------------------
#PlanningAnalyticswithWatson

Hi Edith,

Following the code you wrote in your first post, I don't understand the first line in Data section.
You write : IF ('Month Prueba' @= 'ene.');
It can never be the case, you compare 2 strings "fixed". They can never be equal.
I think that if you write:
IF (vMonth @= 'ene.');​​
that should do the job you expect.
I think the best way is to have an "English alias" as explained in previous posts.
But you could manage it this way
IF (vMonth @= 'ene.');
vFinalMonth = '​Jan.');
ELSEIF (vMonth @= 'feb.');
vFinalMonth = '​Feb.');
etc.

Regards

------------------------------
Catherine BIDOIRE
------------------------------

Original Message:
Sent: Fri November 13, 2020 02:37 PM
From: Edith Aquino
Subject: How to fix a misspelled member name if it already has data and cubes associated

Thanks for your response! I have one more question. How can you dump values from one member to another in the same dimension?
I tries to run this code and it runs but does nothing:

------------------------------
Edith Aquino

Original Message:
Sent: Fri November 13, 2020 10:30 AM
From: Declan Rodger
Subject: How to fix a misspelled member name if it already has data and cubes associated

Hi Edith,

You actually could change your element names as below:

You can add a new alias to the dimension called "NewName".
And in that alias populate the name you want your elements to have.

Then create a TI process with just the line below in it (replace <DimName> with the name of your dimension) and run it once.

SwapAliasWithPrincipalName ( <DimName>, 'NewName', 0 );

That will swap the names in your alias with the principal names, after this you can delete the "NewName" alias.

Just be careful that if you specifically use the element name on rules or TI processes, they will need to be updated.


Or you can amend your TI process to load accordingly:

Take SubSt ( vMonth, 4, 3 ) as you have and that will give you the month name in English as per the datasource (strips off the 07- from the front which i assume is the day number) then you can have an Engligh Alias in your month dimension for where the names differ.
TM1 allows you to use alias names in statements just as it allows you to use the Prinipal Name.


------------------------------
Declan Rodger

Original Message:
Sent: Fri November 13, 2020 09:30 AM
From: Edith Aquino
Subject: How to fix a misspelled member name if it already has data and cubes associated

Hello, my name is Edith Aquino and I'm learning IBM Planning Analytics, I tried to run a process but I get and error due to a missmatch in the names of the Month dimension members and the data in the table for my Franchisce Revenue.
Here's my script, the origin of the data and the month Dimension:

I know it's not possible to modify the names on my Moth dimension but I want to know if there's a solution to this problem, if ayone can help.
Thank you and good day.

------------------------------
Edith Aquino
------------------------------
#PlanningAnalyticswithWatson

Hello Declan

Always learning :-)

Seeing this solution I wonder if there is a way to fix a misspelled Dimension name.

Many thanks
Hallgrimur

------------------------------
Hallgrimur Bergsson
------------------------------

Original Message:
Sent: Fri November 13, 2020 10:30 AM
From: Declan Rodger
Subject: How to fix a misspelled member name if it already has data and cubes associated

Hi Edith,

You actually could change your element names as below:

You can add a new alias to the dimension called "NewName".
And in that alias populate the name you want your elements to have.

Then create a TI process with just the line below in it (replace <DimName> with the name of your dimension) and run it once.

SwapAliasWithPrincipalName ( <DimName>, 'NewName', 0 );

That will swap the names in your alias with the principal names, after this you can delete the "NewName" alias.

Just be careful that if you specifically use the element name on rules or TI processes, they will need to be updated.


Or you can amend your TI process to load accordingly:

Take SubSt ( vMonth, 4, 3 ) as you have and that will give you the month name in English as per the datasource (strips off the 07- from the front which i assume is the day number) then you can have an Engligh Alias in your month dimension for where the names differ.
TM1 allows you to use alias names in statements just as it allows you to use the Prinipal Name.


------------------------------
Declan Rodger

Original Message:
Sent: Fri November 13, 2020 09:30 AM
From: Edith Aquino
Subject: How to fix a misspelled member name if it already has data and cubes associated

Hello, my name is Edith Aquino and I'm learning IBM Planning Analytics, I tried to run a process but I get and error due to a missmatch in the names of the Month dimension members and the data in the table for my Franchisce Revenue.
Here's my script, the origin of the data and the month Dimension:

I know it's not possible to modify the names on my Moth dimension but I want to know if there's a solution to this problem, if ayone can help.
Thank you and good day.

------------------------------
Edith Aquino
------------------------------
#PlanningAnalyticswithWatson

Edith:

This AskQueBIT Knowledge Base article should answer your question:

https://quebit.com/askquebit/IBM/how-to-change-an-element-name-in-tm1-ibm-planning-analytics/

Regards
AG

------------------------------
Ann-Grete Tan
Chief Strategy & Marketing Officer
QueBIT Consulting

Analyze. Plan. Achieve.
https://quebit.com
------------------------------

Original Message:
Sent: Fri November 13, 2020 09:30 AM
From: Edith Aquino
Subject: How to fix a misspelled member name if it already has data and cubes associated

Hello, my name is Edith Aquino and I'm learning IBM Planning Analytics, I tried to run a process but I get and error due to a missmatch in the names of the Month dimension members and the data in the table for my Franchisce Revenue.
Here's my script, the origin of the data and the month Dimension:

I know it's not possible to modify the names on my Moth dimension but I want to know if there's a solution to this problem, if ayone can help.
Thank you and good day.

------------------------------
Edith Aquino
------------------------------

#PlanningAnalyticswithWatson

Hi Edith,

You may want to check out WIm's recent post on this - you should find some very useful insights.
https://www.wimgielis.com/tm1_renameanelement_EN.htm

------------------------------
George Tonkin
------------------------------

Original Message:
Sent: Fri November 13, 2020 09:30 AM
From: Edith Aquino
Subject: How to fix a misspelled member name if it already has data and cubes associated

Hello, my name is Edith Aquino and I'm learning IBM Planning Analytics, I tried to run a process but I get and error due to a missmatch in the names of the Month dimension members and the data in the table for my Franchisce Revenue.
Here's my script, the origin of the data and the month Dimension:

I know it's not possible to modify the names on my Moth dimension but I want to know if there's a solution to this problem, if ayone can help.
Thank you and good day.

------------------------------
Edith Aquino
------------------------------

#PlanningAnalyticswithWatson