Hi,

Is there a format function in MDX which will help me solve the following
scenario:

One of my measures is Net Sales and I have tried all different formats
in Analysis Services so that it shows without the decimal places i.e.
instead of showing the Net Sales for any selected combination of
Dimensions as 123,456.04, I want to show it as 123,456

When I browse the cube (in Analysis Services), I can meet my
requirement. However, in my front-end (Microsoft Data Analyzer), I am
still getting it as 123,456.04 (even when the same in Analysis services,
i.e. when I browse the cube, is being shown as 123,456).

I do not have much choice at the moment and am stuck with Microsoft Data
Analyzer and unfortunately have not been able to solve this

Can someone think of a solution/workaround/use of MDX which will help me get the results being displayed without the decimal.

Many TIA


************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

This is because Data Analyzer doesn't respect server's formatting and
applies it's own.
You can create calculated member with expression Round([Net Sales]) but it
will still show up as 123,456.00
Apparently Data Analyzer always binds to double data type and always formats
the result to have to digits after the dot.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

"Learner" <wantnospam (AT) email (DOT) com> wrote

Mosha,

Many sincere thanks for your reply. Though it is dissapointing to find that it is not possible at all in Data Analyzer but at the same time I can now forget about this requirement and focus on other things on my learning list.

Many thanks once again for your kind help n reply.

Regards.
P.S.
Can you kindly recommend an OLAP front-end which is pretty much similar in the look n feel/functionality (or even better than) Data Analyzer but costs pretty much in the same range. I'm asking this becuase some of the tools (though they are really excellent e.g. ProClarity) are quite expensive. I am looking for either a desktop OLAP front-end or an Excel add-in.

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

P.S.

We are willing to provide 'o2olap' for Analysis Services at $200 a copy.
This is a once off offer for your company and the order needs to be received
by 15 December 2004. You can trial o2olap first as well.

For structure and overview go to www.o2olap.com/o2olap_structure.htm
for reports go to www.o2olap.com/o2olap_reports.htm

Regards
Howard.Taylor@ domain below
www.o2olap.com

wrote in message news:OjttRig0EHA.804 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
can now forget about this requirement and focus on other things on my
learning list.
pretty much in the same range. I'm asking this becuase some of the tools
(though they are really excellent e.g. ProClarity) are quite expensive. I am
looking for either a desktop OLAP front-end or an Excel add-in.

To qualify you must not be in a stage of trial with any of our resellers.

"aa" <aa (AT) bb (DOT) com> wrote

I cannot recommend you one client tool over the other - I can only point you
to the list of available client tools - both standalone and Excel Add-Ins,
some free some commercial, the list is pretty long:

http://www.mosha.com/msolap/util.htm

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

wrote in message news:OjttRig0EHA.804 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
can now forget about this requirement and focus on other things on my
learning list.
pretty much in the same range. I'm asking this becuase some of the tools
(though they are really excellent e.g. ProClarity) are quite expensive. I am
looking for either a desktop OLAP front-end or an Excel add-in.