Alias Impact On Cube Performance

[tgaluskapatterson]

TM1 10.1 64 Bit and Excel 2007
Architect

Do loading aliases have an impact on performance? I have a dimension with 374,456 elements and all have an alias. The element is the AR Customer Number and the AR Customer Name is the alias. I have looked through the Install and Config User Guide and located a parameter on the tm1s.cfg file called SkipLoadingAliases. It seems to imply that if you don't load the alias load time of the cube might be improved possibly. I don't want to turn off the loading of my aliases however if this does impact performance I could give my AR department a better understanding of why the cube errors and a maximum memory box appears when they expand the AR Customer dimension to the 0-level. I tested the SkipLoadingAliases in a development environment however it didn't seem to help performance of the cube.

Memory Used for Views 0
Number of Stored Views 0
Number of Stored Calculated Cells 0
Number of Populated String Cells 0
Number of Populated Numeric Cells 10400891
Number of Fed Cells 0
Memory Used for Calculations 0
Memory Used for Feeders 343932928
Memory Used for Input Data 427824128
Total Memory Used 771757056

[PlanningDev]

You could also try changing the view size and timeout settings so users don't get errors when expanding down to that level. It would also depend on the number of n level elements under each c level item as well I believe.

[tomok]

Your issue has nothing to do with aliases. If you have a 300,000+ member dimension and you are trying to display a cube view with that dimension on either the rows and columns, and have all the leaf elements in the view, you are going to get errors. Neither Architect or Perspectives is going to be able to handle a cube view with that many elements. You will have to filter the dimension down to a smaller subset or break it up via mid-level parental hierarchy.

[tgaluskapatterson]

Thanks for the feedback. We have a redesign meet next week for this cube. I will bring these suggestion to the table. Appreciate it!

[Wim Gielis]

Just a quick note when I see that you have a dimension with 374,456 elements.
Try to make changes to the dimension through TI, rather than through the user interface (Edit Dimension Structure).
That will be quicker and more stable.

Good luck with the redesign !