Hi
I am new to mdx.i want to know can we implement paging in mdx query? is there any function in mdx so that i can return resultset based on count.i am using topcount function to return 10 rows.but i want to return result for next top 10 and so on.. in same query. like we do in paging.
Thanks in advance
There are probably ways of doing this, one that comes to mind would be to use a combination of topcount and tail
eg. page1... TopCount( <set>, <expression>, 10)
page2... TopCount( <set>, <expression>, 20).tail(10)
No comments:
Post a Comment