How to display only the levels or level names of hierarchy in a tree prompt

[xyz]

Hi Paul or someone,

Now I am facing the issue is, in my list I have so many columns, which will have to display bullet charts, micro charts and other information along with that I am displaying  descendants(#prompt('treeprompt', 'mun')#,
#prompt('orglevel', 'token')#)
as the each row has to display the data based upon condition. So I have made master detail relationship for micro chart, ul let chart and others. Becuase of this report Is taking long time to run.
How can I improve the performance. Suggestions are appreciated.

[CognosPaul]

DQM has master/detail optimizations that might help here.

Other than that, reports like this are simply slow. I've never found a decent way of speeding them up to an acceptable level. Every chart in every row is one query being thrown to the database (not necessarily true with DQM though). The time it takes to run that query, do any additional local processing, and generating the image, will account for the run time.

There are ways of tracing report execution to get a duration for each step, but that's a bit beyond the scope of what I can do from here. I strongly recommend asking support for guidance with that as it involved modifying config files.