You are right. Lets get back to original problem. I only need the LATEST from Performance Monitor for now.David Usherwood wrote:@abcuser, I think we have two different issues in this thread.
Yes view include the data that I am trying to show in BI. What I am confused is why "Memory Used for Calculations" in }StatsByCube is still 0 for this cube? (see attachment red rectangle)David Usherwood wrote:The original issue you raised was performance of BI reports running over TM1. Does your view include the data you are trying to show in BI? If it does, running ViewConstruct should populate the calculation cache and make your report much faster.
Just for testing purpose I have created three-dimensional cube with only few members (cubename=reclaim, see attachment green rectangle), just to test this Performance Monitor. But interesting for this cube I can see "Memory Used for Calculation" is 15104. Why is there "Memory Used for Calculations" for cube reclaim but there is 0 for NAB_PREMIJA? Is there any settings that influence when "Memory Used for Calculation" is used?
P.S. I have double checked that ViewConstruct('NAB_PREMIJA',test); is written correctly and getting message "Process Completed Successfully" when process is run.