olap universe functions

[former_member186586]

hi everbody.

i am working about mdx..simple querys.

for example;

select {[Measures].[Sales Amount],[Measures].[Extended Amount]} on columns,

ancestors([Ship Date].[Hierarchy].[English Month Name].&[2003]&[3]&[September],2) on rows

from [Adventure Works DW]

i write this for ssas.and it works.

but in designer;

i wrote for TEST object: <EXPRESSION>ANCESTORS(@Select(Ship Date.Hierarchy\Calendar Year),2)</EXPRESSION>

and i got error in web intelligence.and same for topcount function.

how can i write this simple mdx in universe designer??(bo xi 3.1 sp5)

[Former Member]

Hi Kevin,

Please through this link for MDX functions.

http://www.sdn.sap.com/irj/boc/go/portal/prtroot/docs/library/uuid/c0a45246-ce76-2b10-e688-f5c820620...

[former_member186586]

yes i know this document.

but i couldnt with this.