Hello -
I have a Task Dimension consisting of the below. If Contractor Y logs in, I want them to only see only their data. I have granted them read access for their data. Issue is when I enable drilling, the total project line is showing the total for all contracts (X + Y + Z). I only want to show the total for Y. I currently have the security set to READ to "read" for Contractor Y.
I realize, the total project is really just a "number" in the TM1 model and it's not doing any on the fly calculations based on what you are running the report for. BUT Is there a way to limit the total project line to show only contractor Y total in TM1??
Total Project
Contractor X
Contract 1
Subtask 1.1
Contractor Y
Contract 2
Subtask 2.1
Contractor Z
Contract 3
Subtask 3.1