Here, I tried optimizing the Bex query read mode with following settings:
Read Mode: " A " Query to Read All Data At Once
cache mode: "2" Main Memory Cache with Swapping
Persistence Mode: BLOB
Then I clicked "Generate Report"
After sucessful run of the query, I assumed the available entry for the above run query in "cache monitor->Main Memory->Buffer Objects:Hierarchical Display", but unfortunately I could not find the above run query from the available list.
Could some one please help me to fix this. This is requried as the second run for the same query sould be from main memory rather from the infoprovider/Database.so that run time for the second time can be reduced.
Hope I am clear with my requirement.
Kindly let me know if you need any additional information from the same.
Thanks in advance!