Alias update and stargate view

Post Reply
kenship
Posts: 81
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: TM1 10.2
Excel Version: 2010

Alias update and stargate view

Post by kenship » Tue Jan 16, 2018 3:38 pm

Hi,

I have a TI process that transfer data from input cube to report cube, it's run every 5 min.

I have another TI process that updates alias of a certain dimension every 10 min.

I have noticed that the time needed to execute the input to report cube process is significantly more after alias update process executes. I suspect the stargate view needs to be rebuilt.

My question is: is there any way to update the alias without interrupting the stargate view?

User avatar
jim wood
Site Admin
Posts: 3539
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Alias update and stargate view

Post by jim wood » Tue Jan 16, 2018 5:38 pm

I'm pretty certain that the system regards an alias change as meta change and would lock down the system. It may be taking longer as it will wait for any user activity to end before executing where as a data load (unless you're updating a dimension) will go in as a thread and will not halt user activity.
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 7 64-bit. TM1 Version: 10.1.1

kenship
Posts: 81
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: TM1 10.2
Excel Version: 2010

Re: Alias update and stargate view

Post by kenship » Tue Jan 16, 2018 5:59 pm

I'm not sure at this time about user activity as there's only one user in the instance for now.

The alias update process takes 0.00s from start to finish so I believe this is not the problem.
But I noticed every time after the alias update process is run, the input to report cube process (which includes the dimension updated by the alias update process) takes much much more time to finish.

Thanks.

Kenneth
jim wood wrote:
Tue Jan 16, 2018 5:38 pm
I'm pretty certain that the system regards an alias change as meta change and would lock down the system. It may be taking longer as it will wait for any user activity to end before executing where as a data load (unless you're updating a dimension) will go in as a thread and will not halt user activity.

User avatar
macsir
Community Contributor
Posts: 486
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1, SSAS
Version: 9.5 - 10.2
Excel Version: 97 - 2013
Contact:

Re: Alias update and stargate view

Post by macsir » Wed Jan 17, 2018 1:28 am

Can you check if there is lock contention which is causing the delay?
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/

User avatar
Elessar
Posts: 113
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: Alias update and stargate view

Post by Elessar » Wed Jan 17, 2018 7:33 am

I think updating an alias (like updating a rule) will purge all the affected stargates: rules use element aliases, so the calculated data may change after the "alias update".

You can turn ON the stargate logging and see how "alias changing" affects the stargates.
Sachin has described the stargate logging very well in his blog: https://everanalytics.wordpress.com/201 ... _deepdive/
Sorry for my English ;)

kenship
Posts: 81
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: TM1 10.2
Excel Version: 2010

Re: Alias update and stargate view

Post by kenship » Wed Jan 17, 2018 1:15 pm

Elessar wrote:
Wed Jan 17, 2018 7:33 am
I think updating an alias (like updating a rule) will purge all the affected stargates: rules use element aliases, so the calculated data may change after the "alias update".

You can turn ON the stargate logging and see how "alias changing" affects the stargates.
Sachin has described the stargate logging very well in his blog: https://everanalytics.wordpress.com/201 ... _deepdive/
This is useful, thanks. I guess this is something I have to live with.

Post Reply