Results 1 to 3 of 3

Thread: Need help related to MDX please

  1. #1
    Join Date
    Dec 2003
    Posts
    140

    Need help related to MDX please

    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. Is there a format function that I can use in MDX and how to use it???

    Many TIA

  2. #2
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607

    Formatting in MDX ...

    If you are looking for a means of formatting within MDX, check out the FORMAT_STRING cell property. Simply search on FORMAT_STRING in the MSSQL Server / MSAS Books Online, and you'll be presented with all the options.

    I would think, too, that your client app would allow formatting ...

    Let us know if this helped ...

    Happy Holidays.

    Bill Pearson

  3. #3
    Join Date
    Dec 2003
    Posts
    140
    HiIsland1,

    Thanks for the reply but my front-end (Microsoft Data Analyzer) does not offer any such function.

    The problem (with Data Analyzer) is (seems to be) that even if I define the format in Analysis Services as without decimal places, Data Analyzer still shows it with decimal places :cry:

    Regards.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •