Hi,

I have to be able to reference al level 0 members (Essbase Level_0 or leaves) and I'm not finding where to do this on WebFOCUS. Documentation says that only Parent-Child or By Generation can be used to reference members. So I need to tell WebFOCUS keep members of Essbase Level 0. Another question is if there's any way to supress rows not beying in FML.

Thanks

Gabriel Siler

At this time, the only method to determine level 0 members is to generate a list of member parents in a hold file and a second pass to generate level 0 where member not eq (HOLD)... to restrict rows of all zeroes, you need to test all column values and then do a where total test on the new column

Harry,

Thank you very much for your response. I will be testing your suggestions an will tell you the results.

Thnx again,

Gabriel Siler
Technolabcorp