How to get the top value of a measure

Dear All,

I need to get the top value of a measure using MDX, i.e. by creating a calculated member what code i need to get the top value?

Please reply,

ghadeer

I think you're looking for the TopCount function.

Chris.

How to get statistics on DML statements per table

Can I get statistics on which type of DML statements (e.g. insert, delete, update) that are executed by users on a table without creating triggers? I want to be able to show the number of executed statements per statement type. I have tried the 2005 Profiler but it outputs the entire batch statement which makes it a bit more difficult to create statistics.

Rgds

Bob

There is no easy way to obtain this information. You could also take a look at 3rd party tools that can get this sort of information from the transaction logs.

How to get number of pages per group

I am creating an invoice print using Reporting Services and have
managed to figure out how to reset the Page number for each group
change.
Now, I need to figure out how many pages will print for each group
change. The report is rendered for many invoices (each invoice is a
group change) and each invoice may or may not have multiple pages.
I need to hide the page footer until the last page of the invoice.
Any ideas on how to do that?
Thanks!can't you adapt your sql query ? add an extra field (that uses a count by
grouping). And add that count field in your group footer...
just a mind spinning ;)
"Sher" wrote:
> I am creating an invoice print using Reporting Services and have
> managed to figure out how to reset the Page number for each group
> change.
> Now, I need to figure out how many pages will print for each group
> change. The report is rendered for many invoices (each invoice is a
> group change) and each invoice may or may not have multiple pages.
> I need to hide the page footer until the last page of the invoice.
> Any ideas on how to do that?
> Thanks!
>|||can't you adapt your sql query ? add an extra field (that uses a count by
grouping). And add that count field in your group footer...
just a mind spinning ;)
"Sher" wrote:
> I am creating an invoice print using Reporting Services and have
> managed to figure out how to reset the Page number for each group
> change.
> Now, I need to figure out how many pages will print for each group
> change. The report is rendered for many invoices (each invoice is a
> group change) and each invoice may or may not have multiple pages.
> I need to hide the page footer until the last page of the invoice.
> Any ideas on how to do that?
> Thanks!
>