Dynamic Views (Non MDX)
Posted: Thu Nov 17, 2011 7:36 am
Hi
First time poster and great board! I was wondering if anyone has come across the issue below?
Looking at the blueprint from cognos for workforce planning (it is called Workforce Planning Performance Blueprint Powered by TM1 and can be found here http://www-01.ibm.com/software/data/cog ... nning.html).
Playing around in this model i have spotted an “anomaly”. In the existing employees cube there are a number of static views i.e. EmployeeInformation etc. If you open this view automatic recalc is set already.
When you change the title elements the row dimension (Existing Employees) automatically updates to show the relevant employees for the title element you selected. i.e. i selected Australia procurement and the resulting view changes to show the employees for Aust procurement.
I then change it to Aus Manufacturing control and you see the row dimension update to show the relevant employees again.
I have looked at the following:
1) if there was any MDX in any of the subsets but none existed.
2) The only thing i have picked up is that there is cell security set but the cube appears to be empty.
3) There is also no zero suppression set.
4) One other thing i have picked up is that there appears to be a number of MDX related processes including one that makes a dynamic subset static (}tp processes).
So my question is....... how do they do it?
I am on TM1 9.5.2 FP1.
Thanks,
Jan
First time poster and great board! I was wondering if anyone has come across the issue below?
Looking at the blueprint from cognos for workforce planning (it is called Workforce Planning Performance Blueprint Powered by TM1 and can be found here http://www-01.ibm.com/software/data/cog ... nning.html).
Playing around in this model i have spotted an “anomaly”. In the existing employees cube there are a number of static views i.e. EmployeeInformation etc. If you open this view automatic recalc is set already.
When you change the title elements the row dimension (Existing Employees) automatically updates to show the relevant employees for the title element you selected. i.e. i selected Australia procurement and the resulting view changes to show the employees for Aust procurement.
I then change it to Aus Manufacturing control and you see the row dimension update to show the relevant employees again.
I have looked at the following:
1) if there was any MDX in any of the subsets but none existed.
2) The only thing i have picked up is that there is cell security set but the cube appears to be empty.
3) There is also no zero suppression set.
4) One other thing i have picked up is that there appears to be a number of MDX related processes including one that makes a dynamic subset static (}tp processes).
So my question is....... how do they do it?
I am on TM1 9.5.2 FP1.
Thanks,
Jan