Planning Analytics

Hi!
In }ClientGroups, I want to display the name of a person and skip the "Active Directory" prefix. E.g., I want to show "Active Directory/Leifur Eiríksson" as "Leifur Eiríksson". How can I do this?

------------------------------
Asgeir Thorgeirsson
------------------------------

#PlanningAnalyticswithWatson

You can create an Alias on the }Clients dimension to store just the person's name.  Then in the }ClientsGroups cube view you can turn that alias on in the }Clients dimension.
If you don't have the "name" as a stand alone field to load in from your data source you can use the SUBST function, possibly in conjunction with the LONG and/or SCAN functions to derive just the NAME, and then load that to the Alias of the }Clients.  (You could use Rules or TI, but I suggest TI)

-----------------------------
Arden Miller, QueBIT
-----------------------------



Original Message:
Sent: Tue June 09, 2020 06:17 AM
From: Asgeir Thorgeirsson
Subject: Active Directory names

Hi!
In }ClientGroups, I want to display the name of a person and skip the "Active Directory" prefix. E.g., I want to show "Active Directory/Leifur Eiríksson" as "Leifur Eiríksson". How can I do this?

------------------------------
Asgeir Thorgeirsson
------------------------------
#PlanningAnalyticswithWatson

Thank you Arden
}Clients is a Control dimension and the system says, "Control dimensions may not be edited".

------------------------------
Asgeir Thorgeirsson
------------------------------

Original Message:
Sent: Tue June 09, 2020 07:09 AM
From: Arden Miller
Subject: Active Directory names

You can create an Alias on the }Clients dimension to store just the person's name.  Then in the }ClientsGroups cube view you can turn that alias on in the }Clients dimension.
If you don't have the "name" as a stand alone field to load in from your data source you can use the SUBST function, possibly in conjunction with the LONG and/or SCAN functions to derive just the NAME, and then load that to the Alias of the }Clients.  (You could use Rules or TI, but I suggest TI)

-----------------------------
Arden Miller, QueBIT

Original Message:
Sent: Tue June 09, 2020 06:17 AM
From: Asgeir Thorgeirsson
Subject: Active Directory names

Hi!
In }ClientGroups, I want to display the name of a person and skip the "Active Directory" prefix. E.g., I want to show "Active Directory/Leifur Eiríksson" as "Leifur Eiríksson". How can I do this?

------------------------------
Asgeir Thorgeirsson
------------------------------
#PlanningAnalyticswithWatson

You must create the alias first before you can load names to it.  You can do this within the same TI process in the Prolog.


------------------------------
Arden Miller
------------------------------

Original Message:
Sent: Tue June 09, 2020 09:06 AM
From: Asgeir Thorgeirsson
Subject: Active Directory names

Thank you Arden
}Clients is a Control dimension and the system says, "Control dimensions may not be edited".

------------------------------
Asgeir Thorgeirsson

Original Message:
Sent: Tue June 09, 2020 07:09 AM
From: Arden Miller
Subject: Active Directory names

You can create an Alias on the }Clients dimension to store just the person's name.  Then in the }ClientsGroups cube view you can turn that alias on in the }Clients dimension.
If you don't have the "name" as a stand alone field to load in from your data source you can use the SUBST function, possibly in conjunction with the LONG and/or SCAN functions to derive just the NAME, and then load that to the Alias of the }Clients.  (You could use Rules or TI, but I suggest TI)

-----------------------------
Arden Miller, QueBIT

Original Message:
Sent: Tue June 09, 2020 06:17 AM
From: Asgeir Thorgeirsson
Subject: Active Directory names

Hi!
In }ClientGroups, I want to display the name of a person and skip the "Active Directory" prefix. E.g., I want to show "Active Directory/Leifur Eiríksson" as "Leifur Eiríksson". How can I do this?

------------------------------
Asgeir Thorgeirsson
------------------------------
#PlanningAnalyticswithWatson

Thank you, Arden
I was able to create the alias CllientName in the dimension }Clients
Is it possible to dynamically add an attribute rule to substitute the ClientName from the "Default display name"?

------------------------------
Asgeir Thorgeirsson
------------------------------

Original Message:
Sent: Tue June 09, 2020 09:16 AM
From: Arden Miller
Subject: Active Directory names

You must create the alias first before you can load names to it.  You can do this within the same TI process in the Prolog.

------------------------------
Arden Miller

Original Message:
Sent: Tue June 09, 2020 09:06 AM
From: Asgeir Thorgeirsson
Subject: Active Directory names

Thank you Arden
}Clients is a Control dimension and the system says, "Control dimensions may not be edited".

------------------------------
Asgeir Thorgeirsson

Original Message:
Sent: Tue June 09, 2020 07:09 AM
From: Arden Miller
Subject: Active Directory names

You can create an Alias on the }Clients dimension to store just the person's name.  Then in the }ClientsGroups cube view you can turn that alias on in the }Clients dimension.
If you don't have the "name" as a stand alone field to load in from your data source you can use the SUBST function, possibly in conjunction with the LONG and/or SCAN functions to derive just the NAME, and then load that to the Alias of the }Clients.  (You could use Rules or TI, but I suggest TI)

-----------------------------
Arden Miller, QueBIT

Original Message:
Sent: Tue June 09, 2020 06:17 AM
From: Asgeir Thorgeirsson
Subject: Active Directory names

Hi!
In }ClientGroups, I want to display the name of a person and skip the "Active Directory" prefix. E.g., I want to show "Active Directory/Leifur Eiríksson" as "Leifur Eiríksson". How can I do this?

------------------------------
Asgeir Thorgeirsson
------------------------------
#PlanningAnalyticswithWatson

In this example:

The Client element is:  123456/John

And, we know that we will always have 7 characters before the NAME begins.

You could use the following to get "John":

SUBST ( Client , 8 ,  LONG ( Client ) – 7 ) )

If your prefix length varies you may need to use a variation of this syntax with the SCAN function to see where the "/" begins.

See this link for more details on function syntax:
https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_prism_gs.2.0.0.doc/c_textrulesfunctions_n8203e.html

------------------------------
Arden Miller
------------------------------

Original Message:
Sent: Tue June 09, 2020 09:47 AM
From: Asgeir Thorgeirsson
Subject: Active Directory names

Thank you, Arden
I was able to create the alias CllientName in the dimension }Clients
Is it possible to dynamically add an attribute rule to substitute the ClientName from the "Default display name"?

------------------------------
Asgeir Thorgeirsson

Original Message:
Sent: Tue June 09, 2020 09:16 AM
From: Arden Miller
Subject: Active Directory names

You must create the alias first before you can load names to it.  You can do this within the same TI process in the Prolog.

------------------------------
Arden Miller

Original Message:
Sent: Tue June 09, 2020 09:06 AM
From: Asgeir Thorgeirsson
Subject: Active Directory names

Thank you Arden
}Clients is a Control dimension and the system says, "Control dimensions may not be edited".

------------------------------
Asgeir Thorgeirsson

Original Message:
Sent: Tue June 09, 2020 07:09 AM
From: Arden Miller
Subject: Active Directory names

You can create an Alias on the }Clients dimension to store just the person's name.  Then in the }ClientsGroups cube view you can turn that alias on in the }Clients dimension.
If you don't have the "name" as a stand alone field to load in from your data source you can use the SUBST function, possibly in conjunction with the LONG and/or SCAN functions to derive just the NAME, and then load that to the Alias of the }Clients.  (You could use Rules or TI, but I suggest TI)

-----------------------------
Arden Miller, QueBIT

Original Message:
Sent: Tue June 09, 2020 06:17 AM
From: Asgeir Thorgeirsson
Subject: Active Directory names

Hi!
In }ClientGroups, I want to display the name of a person and skip the "Active Directory" prefix. E.g., I want to show "Active Directory/Leifur Eiríksson" as "Leifur Eiríksson". How can I do this?

------------------------------
Asgeir Thorgeirsson
------------------------------
#PlanningAnalyticswithWatson

But this has to be a process function right, a rule is not possible, or is it?

------------------------------
Asgeir Thorgeirsson
------------------------------

Original Message:
Sent: Tue June 09, 2020 10:00 AM
From: Arden Miller
Subject: Active Directory names

In this example:

The Client element is:  123456/John

And, we know that we will always have 7 characters before the NAME begins.

You could use the following to get "John":

SUBST ( Client , 8 ,  LONG ( Client ) – 7 ) )

If your prefix length varies you may need to use a variation of this syntax with the SCAN function to see where the "/" begins.

See this link for more details on function syntax:
https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_prism_gs.2.0.0.doc/c_textrulesfunctions_n8203e.html

------------------------------
Arden Miller

Original Message:
Sent: Tue June 09, 2020 09:47 AM
From: Asgeir Thorgeirsson
Subject: Active Directory names

Thank you, Arden
I was able to create the alias CllientName in the dimension }Clients
Is it possible to dynamically add an attribute rule to substitute the ClientName from the "Default display name"?

------------------------------
Asgeir Thorgeirsson

Original Message:
Sent: Tue June 09, 2020 09:16 AM
From: Arden Miller
Subject: Active Directory names

You must create the alias first before you can load names to it.  You can do this within the same TI process in the Prolog.

------------------------------
Arden Miller

Original Message:
Sent: Tue June 09, 2020 09:06 AM
From: Asgeir Thorgeirsson
Subject: Active Directory names

Thank you Arden
}Clients is a Control dimension and the system says, "Control dimensions may not be edited".

------------------------------
Asgeir Thorgeirsson

Original Message:
Sent: Tue June 09, 2020 07:09 AM
From: Arden Miller
Subject: Active Directory names

You can create an Alias on the }Clients dimension to store just the person's name.  Then in the }ClientsGroups cube view you can turn that alias on in the }Clients dimension.
If you don't have the "name" as a stand alone field to load in from your data source you can use the SUBST function, possibly in conjunction with the LONG and/or SCAN functions to derive just the NAME, and then load that to the Alias of the }Clients.  (You could use Rules or TI, but I suggest TI)

-----------------------------
Arden Miller, QueBIT

Original Message:
Sent: Tue June 09, 2020 06:17 AM
From: Asgeir Thorgeirsson
Subject: Active Directory names

Hi!
In }ClientGroups, I want to display the name of a person and skip the "Active Directory" prefix. E.g., I want to show "Active Directory/Leifur Eiríksson" as "Leifur Eiríksson". How can I do this?

------------------------------
Asgeir Thorgeirsson
------------------------------
#PlanningAnalyticswithWatson

I just learned that the attribute rule could be written for the cube  }ElementAttributes_}Clients' like this :) :) :)
['}ElementAttributes_}Clients':{'ClientName'}]=S:SUBST(DB('}ElementAttributes_}Clients', !}Clients, '}TM1_DefaultDisplayValue'),18,50);

Thanks for all the help Arden, you made my day a lot easier :)
Case closed

------------------------------
Asgeir Thorgeirsson
------------------------------

Original Message:
Sent: Tue June 09, 2020 10:11 AM
From: Asgeir Thorgeirsson
Subject: Active Directory names

But this has to be a process function right, a rule is not possible, or is it?

------------------------------
Asgeir Thorgeirsson

Original Message:
Sent: Tue June 09, 2020 10:00 AM
From: Arden Miller
Subject: Active Directory names

In this example:

The Client element is:  123456/John

And, we know that we will always have 7 characters before the NAME begins.

You could use the following to get "John":

SUBST ( Client , 8 ,  LONG ( Client ) – 7 ) )

If your prefix length varies you may need to use a variation of this syntax with the SCAN function to see where the "/" begins.

See this link for more details on function syntax:
https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_prism_gs.2.0.0.doc/c_textrulesfunctions_n8203e.html

------------------------------
Arden Miller

Original Message:
Sent: Tue June 09, 2020 09:47 AM
From: Asgeir Thorgeirsson
Subject: Active Directory names

Thank you, Arden
I was able to create the alias CllientName in the dimension }Clients
Is it possible to dynamically add an attribute rule to substitute the ClientName from the "Default display name"?

------------------------------
Asgeir Thorgeirsson

Original Message:
Sent: Tue June 09, 2020 09:16 AM
From: Arden Miller
Subject: Active Directory names

You must create the alias first before you can load names to it.  You can do this within the same TI process in the Prolog.

------------------------------
Arden Miller

Original Message:
Sent: Tue June 09, 2020 09:06 AM
From: Asgeir Thorgeirsson
Subject: Active Directory names

Thank you Arden
}Clients is a Control dimension and the system says, "Control dimensions may not be edited".

------------------------------
Asgeir Thorgeirsson

Original Message:
Sent: Tue June 09, 2020 07:09 AM
From: Arden Miller
Subject: Active Directory names

You can create an Alias on the }Clients dimension to store just the person's name.  Then in the }ClientsGroups cube view you can turn that alias on in the }Clients dimension.
If you don't have the "name" as a stand alone field to load in from your data source you can use the SUBST function, possibly in conjunction with the LONG and/or SCAN functions to derive just the NAME, and then load that to the Alias of the }Clients.  (You could use Rules or TI, but I suggest TI)

-----------------------------
Arden Miller, QueBIT

Original Message:
Sent: Tue June 09, 2020 06:17 AM
From: Asgeir Thorgeirsson
Subject: Active Directory names

Hi!
In }ClientGroups, I want to display the name of a person and skip the "Active Directory" prefix. E.g., I want to show "Active Directory/Leifur Eiríksson" as "Leifur Eiríksson". How can I do this?

------------------------------
Asgeir Thorgeirsson
------------------------------
#PlanningAnalyticswithWatson