Hi All,

On Setting LoadPrivateSubsetsOnStartup = T, noticed a TM1 Warning Message "GetCollection() called for pr_CubeExpressionBasedViews" Which is taking close to 70% of the overall server load time. The impact is observed with expression based view (.xbv) objects.

Can someone advise what processes run behind the scene on this event and Suggested alternatives to reduce the impact on server load time due to the prevailing .xbv obejcts.

Thanks in advance.

Regards,
Niranjan



------------------------------
Niranjan Prasad
------------------------------

#PlanningAnalyticswithWatson

Hi Niranjan,

The warning you are seeing wrt Expression Based Views there, not sure why we decided this would be of any value to customers and therefore why it is there, is effectively indicating that we didn't expect that GetCollection function to be called for that 'type' any longer and that it returns an empty collection. I.o.w. that by itself is not the cause of the slowdown you are experiencing.

Loading private subsets on startup itself however could take a long time. As the name of the setting suggests, the server is going to find and load all private subsets for all users at startup time which, depending on the amount of users and private subsets they have, might indeed take a while.

------------------------------
Hubert Heijkers
------------------------------

Hi Hubert Heijkers,

Many thanks for looking into this.
I have monitored the impact on server load time after setting "LoadPrivateSubsetsOnStartup = F". I have observed the load time was reduced by 60 percent, However deleting .xbv files from server improved further load time by additional 60 percent.

So despite of setting "LoadPrivateSubsetsOnStartup = F", .xbv objects are still impacting the server load time.

Thank you.

------------------------------
Niranjan Prasad
------------------------------

Original Message:
Sent: Tue July 12, 2022 05:06 AM
From: Hubert Heijkers
Subject: GetCollection() called for pr_CubeExpressionBasedViews

Hi Niranjan,

The warning you are seeing wrt Expression Based Views there, not sure why we decided this would be of any value to customers and therefore why it is there, is effectively indicating that we didn't expect that GetCollection function to be called for that 'type' any longer and that it returns an empty collection. I.o.w. that by itself is not the cause of the slowdown you are experiencing.

Loading private subsets on startup itself however could take a long time. As the name of the setting suggests, the server is going to find and load all private subsets for all users at startup time which, depending on the amount of users and private subsets they have, might indeed take a while.

------------------------------
Hubert Heijkers
------------------------------

Hi @Niranjan Prasad,

Ok, wasn't implying .xbv's wouldn't have any impact, just that grabbing the collection (which doesn't do anything) and the LoadPrivateSubsetsOnStartup were unrelated to each other.

So these .xbv's (expression based views aka MDX views), are those all private views? And removing those gives you another boost of 60% (after the initial 60% - iow some 24% overall if all is on)?

Cheers,

------------------------------
Hubert Heijkers
------------------------------

Original Message:
Sent: Tue July 12, 2022 07:20 AM
From: Niranjan Prasad
Subject: GetCollection() called for pr_CubeExpressionBasedViews

Hi Hubert Heijkers,

Many thanks for looking into this.
I have monitored the impact on server load time after setting "LoadPrivateSubsetsOnStartup = F". I have observed the load time was reduced by 60 percent, However deleting .xbv files from server improved further load time by additional 60 percent.

So despite of setting "LoadPrivateSubsetsOnStartup = F", .xbv objects are still impacting the server load time.

Thank you.

------------------------------
Niranjan Prasad
------------------------------


Original Message:
Sent: Tue July 12, 2022 05:06 AM
From: Hubert Heijkers
Subject: GetCollection() called for pr_CubeExpressionBasedViews

Hi Niranjan,

The warning you are seeing wrt Expression Based Views there, not sure why we decided this would be of any value to customers and therefore why it is there, is effectively indicating that we didn't expect that GetCollection function to be called for that 'type' any longer and that it returns an empty collection. I.o.w. that by itself is not the cause of the slowdown you are experiencing.

Loading private subsets on startup itself however could take a long time. As the name of the setting suggests, the server is going to find and load all private subsets for all users at startup time which, depending on the amount of users and private subsets they have, might indeed take a while.

------------------------------
Hubert Heijkers

Thank you @Hubert Heijkers for getting back on this thread. Yes all of the .xbv files are private views and deleting these files from server improved instance load time.

------------------------------
Niranjan Prasad
------------------------------

Original Message:
Sent: Tue July 12, 2022 08:10 AM
From: Hubert Heijkers
Subject: GetCollection() called for pr_CubeExpressionBasedViews

Hi @Niranjan Prasad,

Ok, wasn't implying .xbv's wouldn't have any impact, just that grabbing the collection (which doesn't do anything) and the LoadPrivateSubsetsOnStartup were unrelated to each other.

So these .xbv's (expression based views aka MDX views), are those all private views? And removing those gives you another boost of 60% (after the initial 60% - iow some 24% overall if all is on)?

Cheers,

------------------------------
Hubert Heijkers
------------------------------


Original Message:
Sent: Tue July 12, 2022 07:20 AM
From: Niranjan Prasad
Subject: GetCollection() called for pr_CubeExpressionBasedViews

Hi Hubert Heijkers,

Many thanks for looking into this.
I have monitored the impact on server load time after setting "LoadPrivateSubsetsOnStartup = F". I have observed the load time was reduced by 60 percent, However deleting .xbv files from server improved further load time by additional 60 percent.

So despite of setting "LoadPrivateSubsetsOnStartup = F", .xbv objects are still impacting the server load time.

Thank you.

------------------------------
Niranjan Prasad


Original Message:
Sent: Tue July 12, 2022 05:06 AM
From: Hubert Heijkers
Subject: GetCollection() called for pr_CubeExpressionBasedViews

Hi Niranjan,

The warning you are seeing wrt Expression Based Views there, not sure why we decided this would be of any value to customers and therefore why it is there, is effectively indicating that we didn't expect that GetCollection function to be called for that 'type' any longer and that it returns an empty collection. I.o.w. that by itself is not the cause of the slowdown you are experiencing.

Loading private subsets on startup itself however could take a long time. As the name of the setting suggests, the server is going to find and load all private subsets for all users at startup time which, depending on the amount of users and private subsets they have, might indeed take a while.

------------------------------
Hubert Heijkers