TI Process View Creation Error

[tgaluskapatterson]

TM1 10.2
I currently have a TI process that creates view zLoadDriverDetail in my Driver cube. Something strange is occuring to the view when it is created. If i comment out the last two lines which are assigning subsets to the rows of this view results come back with no error. If I remove the comments on the last two lines no data returns. Not even the zeros and if I click recalculate on the view nothing changes. I have attached the TI process code and print screens to help better display the issue. I should also mention that the process runs with no error and completes sucessfully with or without the last two lines commented out. Any ideas? Or has anyone run into this before? Thanks!

[deepakjain2020]

TM1 10.2
I currently have a TI process that creates view zLoadDriverDetail in my Driver cube. Something strange is occuring to the view when it is created. If i comment out the last two lines which are assigning subsets to the rows of this view results come back with no error. If I remove the comments on the last two lines no data returns. Not even the zeros and if I click recalculate on the view nothing changes. I have attached the TI process code and print screens to help better display the issue. I should also mention that the process runs with no error and completes sucessfully with or without the last two lines commented out. Any ideas? Or has anyone run into this before? Thanks!

Try to comment out only the last line and share your result. I hope there should be something.

The last line which you commented out might not have data with combination to element 'Driver Number'.


Regards,
Deepak Jain