Error in MDX Query for ASO calc scripts -

i have calculation script aso cube copies data 1 version . in pov section of code using crossjoin function of mdx create set of tuples

pov "crossjoin({filter([accounts].members, isleaf([accounts].currentmember))},  crossjoin ({[d100]},  crossjoin ({[2014]},{[usd]})))"  sourceregion "crossjoin({[actl]}, {[eop]})" ; 

but on execution mdx using maxl getting following error

maxl shell completed error  error - 1300033 - upper-level members, example [ac0001], not allowed in argument [pov]. select level-0 member.  error - 1241190 - custom calculation terminated essbase error 1300033 in pov. 

i using filter function filter out lev 0 members account dimension in pov section, somehow still returning parent level members. tried [accounts].levels(0).members

but faced same problem.

can me out going wrong ?

calculation scripts typically used calculate accounts derived input accounts in 1 application.database. calculation script uses consolidation operators (+) or formulas in bso.

assuming trying extract portion of data 1 aso application.database application.database, 1 option use report script syntax similar following extract level 0 members only. can right click on report script in essbase administration services , execute it. report scripts easier write multi-dimensional expressions. above state trying filter out level 0 members when asos need loaded @ level 0. roll higher levels in outline.

to load text file extract, build rules file , validate in eas (you can use eas load directly relational database tables). select "file" - "open data file". once file validated can use eas load file other application.database. once complete process in eas can automate using maxl code , run process command prompt.

if trying copy or mirror entire application.database, right click on application , select copy in essbase administration services.