Skip to Content
0
Former Member
May 15, 2008 at 06:01 PM

Hierarchy expansion issue

77 Views

Hi All,

I have an issue with hierarchy expansion; does anybody came across this pls help.we r on BW 3.1c SP 17

i have three queries inside a workbook with same set of selection screen variables. inside these three queries i have two characterstics say A & B. in these queries these char's in rows displayed as hierarchy expands first level upto A.

B is in second level.when i try to expand this B, query does all its calculations going through all master data reports,saplrrk0, then processing finishes on server. but the result wont be coming back to excel. excel just hangs, hangs hangs for like couple of hours then it comes back. B values aren't big around 2000-3000 i guess it wont be problem for excel.

excel is coming back if i cancel excel in task manager(windows) asking me to save then i say save its saving as excel file.

if i use these 3 queries saperately i can expand the hierarchies, no issues. excel hangs only when i put them in one workbook. i swith off query properties of auto refresh, return to global definition on refresh, for all 3 queries.

i have changed individual query in local view and expanded upto B upto 2nd level still its finished on server but excel hangs where as if i do this query by itself apart from that workbook it works.

Does anybody knows what could be the problem.i have seen notes on saplrrk0 report but it