I am using SQL Server Analysis service 2000, I got about 10 measures
and
three calculated Member, On cube browser, Is there any anyway to change

order of display, , my calculated memeber is display at end. I want to
display calculated member first then my measures.


Any help please


Thanks
Kalyan

Hi Kalyan.

Probably the easiest way to do this is to create a set that orders the
measures exactly how you want. For example, if I have 2 regular
measures (Sales, Cost) and 1 Calculated Measure (Net Profit) then I
would create a named set that looked like this:

{Measures.[Net Profit], Measures.Sales, Measures.Cost}

This will put the calc member first, followed by your regular ones.
Also, by putting them in a set you get to see the member names.

HTH

V

Hi Voorshwa

Thanks for reply, but

I created namedset like this
{Measures.[Net Profit], Measures.Sales, Measures.Cost}

On cube browser,
Net Profit, Cost, my calculated memeber, Net Profit, cost (this is because
of named set)

If i hide regular measure, named set also hide

please give more details about your idea

thanks

"Voorshwa" wrote:

Hi Kalyan,

I'm trying to do the same thing with measeures inside my cubes and I would
like to know if any solution has been found yet.

Thanks


"Kalyan" wrote:

I have not tested this myself, but have you tried hidding all the raw
measures and setting up every measure you want the users to see as
calculated members?

You could set up all your standard measures as [Net Profit Raw] [Cost
Raw] and then set up calculated members called [Net Profit] and [Cost]
that just return their respective "raw" values. In theory, this should
get around the issue of calculated measures sorting last.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <7F8027DA-FEA8-49A5-A56A-AD95C6726A0E (AT) microsoft (DOT) com>, Pat.
@discussions.microsoft.com says...

Thanks Darren,


"Darren Gosbell" wrote: